![]() FALSE – Parameter cannot be changed with ALTER SYSTEM unless a server parameter file was used to start the instance.The change takes effect in subsequent sessions. DEFERRED – Parameter can be changed with ALTER SYSTEM regardless of the type of parameter file used to start the instance.IMMEDIATE – Parameter can be changed with ALTER SYSTEM regardless of the type of parameter file used to start the instance. ![]() Indicates whether the parameter can be changed with ALTER SYSTEM and when the change takes effect: Indicates whether the parameter can be changed with ALTER SESSION ( TRUE) or not ( FALSE) Yes the pga can be changed while the database is up and running.Ģ) How to know which parameter is dynamic/static? ISSES_MODIFIABLE 1) How to set pga size, can you change it while the database is running?Īlter system set pga_aggregate_target=100m
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |