Dynamic parameters in database
The dynamic parameters are used when the database is in running mode.It also change the database property but during instance start up or in the processing.
The dynamic parameters are issued with the ALTER statement and capable to change the mode and structure of the database.An example of the dynamic parameter is shown below which will change the structure and functioning of the database when the database is running means transaction is going on.
Code:
SQL> ALTER DATABASE ARCHIVE LOG;
This is an dynamic parameter which is will change the database status and functioning of database.The database would be changed from NOARCHIVELOG to ARCHIVELOG.
Bookmarks