Question: what is the difference between alter system and alter database?
Answer: - As a general rule "alter system" is an instance command, use to alter parameters (e.g. alter system set db_cache_size=xxx) and altering processes. The "alter database", conversely, is used to change the database strurcture and displays (e.g. alter database backup controlfile to trace).