| startup upgrade [message #683626] |
Mon, 08 February 2021 14:07  |
 |
Olexandr Siroklyn
Messages: 42
Registered: September 2018
Location: USA
|
Member |
|
|
Hello,
When we call "startup upgrade" from SQL*Plus a lot of "alter system...." statements like 'alter system enable restricted session', 'alter system set _system_trig_enabled=false' are executed. But where is a list of those "alters" stored? What executes "alters"? SQL*Plus, stored procedure, function, background process?
Please share any of your ideas/experiences.
Thank you.
|
|
|
|
| Re: startup upgrade [message #683627 is a reply to message #683626] |
Mon, 08 February 2021 14:49  |
Andrey_R
Messages: 441
Registered: January 2012
Location: Israel
|
Senior Member |
|
|
Olexandr Siroklyn wrote on Mon, 08 February 2021 22:07Hello,
When we call "startup upgrade" from SQL*Plus a lot of "alter system...." statements like 'alter system enable restricted session', 'alter system set _system_trig_enabled=false' are executed. But where is a list of those "alters" stored? What executes "alters"? SQL*Plus, stored procedure, function, background process?
Please share any of your ideas/experiences.
Thank you.
Alter system statements normally work on either the parameters/settings currently in memory, either on PFILE/SPFILE, or both, or others ( for example, control file ) .
Depends on the command, depends on the attributes ( for example, scope=MEMORY).
"Use the ALTER SYSTEM statement to dynamically alter your Oracle database instance. The settings stay in effect as long as the database is mounted."
(https://docs.oracle.com/cd/B12037_01/server.101/b10759/statements_2013.htm)
[Updated on: Mon, 08 February 2021 14:52] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
