Contents
What is a quiesce database?
Such a state is referred to as a quiesced state, in the sense that no ongoing non-DBA transactions, queries, fetches, or PL/SQL statements are running in the system. Note: In this discussion of quiesce database, a DBA is defined as user SYS or SYSTEM .
What is restricted session?
When a database is placed in restricted mode, only users that have RESTRICTED SESSION privilege granted to them can connect. to the database. Users that lack this privilege will get an error. Users that are already connected to the database, prior to placing the database in restricted session, will not get disconnected …
What is quiesce in VMWare?
What is Quiescing? According to a VMware® Knowledge Base article, “Quiescing a file system is a process of bringing the on-disk data of a physical or virtual computer into a state suitable for backups.
What does alter system enable Restricted Session do?
‘alter system enable restricted session’ does not “kick out” user automatically. It just blocks new user who does not have the ‘restrict session’ privilege to login, similar to ‘ALTER SYSTEM QUIESCE RESTRICTED’, which blocks new non-dba users.
How to use restricted session to do the same job?
To use ‘restrict session’ to do the same job, DBA might need to have a procedure that is able to keep monitoring the status of the existing transactions and kill the session as soon as the transaction gets completed. I said “you would KICK OUT”, not that “it kicks out”. you just said the same thing I did.
How does a restricted session work in DBA?
It allows all current transactions to complete, and then freezes the user’s session. To use ‘restrict session’ to do the same job, DBA might need to have a procedure that is able to keep monitoring the status of the existing transactions and kill the session as soon as the transaction gets completed.
What’s the difference between a session and an instance?
A Session corresponds to one or more users interacting with the instance. When a user starts a new database session, a process is started on the server and the user’s application interacts with this process (called a dedicated server process) which interacts with the instance.