hi,

Use the ALTER SYSTEM statement to dynamically alter your Oracle instance. The settings stay in effect as long as the database is mounted.

Use the ALTER DATABASE statement to modify, maintain, or recover an existing database.