Shulou(Shulou.com)05/31 Report--

Today, I will talk to you about how to enable and disable restricted session mode in oracle. Many people may not know much about it. In order to make you understand better, the editor has summarized the following for you. I hope you can get something from this article.

Enable and disable restricted session mode:

If you need to perform maintenance operations when the database is in open mode, while ensuring that other users do not establish connections and perform tasks on the database at this time

Alter system enable restricted session

And

Alter system disable restricted session

Set the display mode set pagesize 30 linesize 120

Manage sessions:

Address of the Saddr session

Sid session marking

Serial number of the Serial# session

Identifier of the User# database user

Name of the Username database user

The statement being processed by Command is the statement that was analyzed last.

Current state of the Status session

Identifier of the Schema# scheme user

Name of the Schemaname scenario user

Name of the Osuser operating system user

Process operating system client process

Host of the Machine operating system

Terminal of Terminal operating system

Program operating system program name

Type of Type session

The name of the operation being performed by Action

Use alter system statements to manage sessions

You can use alter system kill session 'sid,serial#' to break the session.

After reading the above, do you have any further understanding of how to enable and disable restricted session mode in oracle? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.