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

Editor to share with you what Oracle commands are commonly used, I believe most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

1. Enable and disable Oracle snooping and instances:

Su-oracle switches to oracle user

Lsnrctl status to view monitoring and database status

Lsnrctl start initiates snooping

Sqlplus "/ as sysdba" enters sqlplus as DBA

Startup starts db

Shutdown immediate shuts down db

Exit exits sqlplus

Lsnrctl stop stops snooping

Second, check the initialization parameters and modify:

Show parameter session to view the number of session accepted

Show parameter processes

Alter system set processes=100 scope=both; ERROR at line 1: ORA-02095: specified initialization parameter cannot be modified

Alter system set processes=100 scope=memory; ERROR at line 1: ORA-02095: specified initialization parameter cannot be modified

Alter system set processes=100 scope=spfile; System altered.

One process corresponds to 0, 1 or more session.

3. Number of database connections:

A database connection requires a session whose value is determined by processes. The general relationship is as follows: session = 1.1 * processes + 5

The above is all the contents of this article "what are the Common Oracle commands?" Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.