Oracle View and modify session and maximum number of connections

First step, on the cmd command line, enter Sqlplus

Step two, follow the prompts to enter the user name and password

1. View processes and Sessions parameters

Sql> Show parameter processes

NAME TYPE VALUE

Db_writer_processes Integer 1

Gcs_server_processes integer 0

Job_queue_processes Integer 10

Log_archive_max_processes Integer 2

Processes integer 50

Sql> Show Parameter Sessions

NAME TYPE VALUE

License_max_sessions integer 0

license_sessions_warning integer 0

Logmnr_max_persistent_sessions Integer 1

Sessions Integer 60

Shared_server_sessions integer

2. Modifying processes and Sessions values

Sql> alter system set PROCESSES=300 Scope=spfile;

The system has changed.

Sql> alter system set sessions=335 Scope=spfile;

The system has changed.

3. Modifying the processes and sessions values must restart the Oracle server to take effect

The number of connections to Oracle (sessions) is related to the number of processes in its parameter file (process), and their relationships are as follows:

Sessions= (1.1*process+5)

Pick (ii)

　　Query the number of connections to the current process of the database:

Select COUNT (*) from v$process;

To view the number of connections for the current session of the database:

Elect Count (*) from v$session;

To view the number of concurrent connections for a database:

Select COUNT (*) from v$session where status= ' ACTIVE ';

To view the session established by the current database:

Select Sid,serial#,username,program,machine,status from V$session;

Maximum number of connections allowed for query database:

Select value from v$parameter where name = ' processes ';

Or: Show parameter processes;

To modify the maximum number of connections allowed for a database:

alter system SET processes = + scope = SPFile;

(You need to restart the database to make changes to the number of connections)

To restart the database:

Shutdown immediate;

Startup

See which users are currently working with the data:

Select Osuser,a.username,cpu_time/executions/1000000| | ' S ', Sql_fulltext,machine

From V$session A,v$sqlarea b

where a.sql_address = b.address

ORDER BY cpu_time/executions Desc;

Note: UNIX 1 users session corresponds to an operating system process, while Windows embodies the thread.

Start Oracle

Su-oracle

Sqlplus system/pwd as SYSDBA//Enter SQL

Startup//Start database

Lsnrctl start//boot monitoring

Sqlplus "/as sysdba"

Shutdown immediate;

startup Mount;

ALTER DATABASE open;

4. By modifying Oracle configuration file for modificationModify the SPFILEORCL. The value of the processes in the ORA file . 8.1.5 is the init.ora file, in 9i modified init.ora file is invalid, this file is a binary file, cannot be used directly Notepad The editor for this class opens. ora-27101 Shared memory realm does not exist Use ultraedit restart oracle 5. Modifying in the graphical manager via Oracle Enterprise Manager consoleA. Log in as a system administratorB. Entering a database routine-configuration-general information-all initialization parametersC. Modifying The value of a processes d.sessions values are derived from formula sessions=1.1*process + 5 [@[email protected]]

Oracle View and modify session and maximum number of connections