Home » RDBMS Server » Server Administration » startup upgrade (any oracle version)
startup upgrade [message #683626] Mon, 08 February 2021 14:07 Go to next message
Olexandr Siroklyn
Messages: 36
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 Go to previous message
Andrey_R
Messages: 441
Registered: January 2012
Location: Israel
Senior Member
Olexandr Siroklyn wrote on Mon, 08 February 2021 22:07
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.

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

Previous Topic: ORA-04031: unable to allocate 4064 bytes of shared memory
Next Topic: how to manually remove components in 12.1.0.2 CDB
Goto Forum:
  


Current Time: Thu Mar 28 08:31:56 CDT 2024