View common system information in oracle

View common system information in oracle

It summarizes common SQL statements used to view oracle databases, which helps Analysis and Optimization of a robust system program.

1. Number of current database connections:
Select count (*) from v $ process

2. Maximum number of connections allowed by the database:
Select value from v $ parameter where name = 'processs'

3. Modify the maximum number of connections:
Alter system set processses = 300 scope = spfile;

4. Restart the database:
Shutdown immediate;
Startup;

5. Check which users are using the data:
SELECT osuser, a. username, cpu_time/executions/1000000 |'s ', B. SQL _text, machine from v Sessiona, v Sqlarea B where a. SQL _address = B. address order by cpu_time/executions desc;

6. Number of current session connections
Select count (*) from v $ session

7. concurrent connections
Select count (*) from v $ session where status = 'active'

8. Maximum connections
Show parameter processes