ORACLE view and modify the maximum number of connections

2011-08-16  来源:本站原创  分类:Database  人气:203 

1 View processes and sessions parameters

SQL> show parameter processes

NAME TYPE VALUE
------------------------------------ ----------- --- ---------------------------
aq_tm_processes integer 1
db_writer_processes integer 1
job_queue_processes integer 10
log_archive_max_processes integer 2
processes integer 150

SQL> show parameter sessions

NAME TYPE VALUE
------------------------------------ ----------- --- ---------------------------
java_max_sessionspace_size integer 0
java_soft_sessionspace_limit integer 0
license_max_sessions integer 0
license_sessions_warning integer 0
logmnr_max_persistent_sessions integer 1
mts_sessions integer 165
sessions integer 170
shared_server_sessions integer 165
SQL>

2 sessions to modify processes and values

SQL> alter system set processes = 300 scope = spfile;

System has been changed.

SQL> alter system set sessions = 335 scope = spfile;

System has been changed.

3 sessions modified processes and values ​​to take effect you must restart the oracle server

ORACLE number of connections (sessions) and its parameter file in the number of processes (process) related to their relationship as follows:

sessions = (1.1 * process +5)

Query the database of the current process connections:

select count (*) from v $ process;

View the current session database connections:

select count (*) from v $ session;

View of concurrent database connections:

select count (*) from v $ session where status = 'ACTIVE';

View the current session of databases:

select sid, serial #, username, program, machine, status from v $ session;

Query the database to allow the maximum number of connections:

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

Or: show parameter processes;

Modify the database to allow the maximum number of connections:

alter system set processes = 300 scope = spfile;

(Need to restart the database to connect to the number of changes)

Restart the database:

shutdown immediate;

startup;

See what users are using the current 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 user session corresponding to a operating system process, but Windows is reflected in the thread.

Start oracle

su - oracle

sqlplus system / pwd as sysdba / / into the sql

startup / / start the database

lsnrctl start / / start listening

sqlplus "/ as sysdba"

shutdown immediate;

startup mount;

alter database open;

相关文章
  • Oracle View to modify the maximum number of connections connections 2011-05-30

    Sometimes even get on the database, sometimes Rom. May be the current number of connections on the database has exceeded the maximum it can handle. select count (*) from v $ process - the current number of connections select value from v $ parameter

  • ORACLE view and modify the maximum number of connections 2011-08-16

    1 View processes and sessions parameters SQL> show parameter processes NAME TYPE VALUE ------------------------------------ ----------- --- --------------------------- aq_tm_processes integer 1 db_writer_processes integer 1 job_queue_processes intege

  • oracle view and set the maximum number of connections {turn} 2011-07-15

    The current number of connections select count (*) from v $ process; Set the maximum number of connections (default is 150) select value from v $ parameter where name = 'processes'; Modify the maximum number of connections alter system set processes

  • (R) Oracle view and modify its largest number of cursors 2010-08-28

    The following article is to introduce the Oracle view and modify the maximum number of cursors, this is mainly related to the code through the Oracle leads the way to view and modify the maximum number of cursors practical steps, the following is a d

  • Modify the maximum number of connections MYSQL 3 methods Detailed 2010-10-13

    Modify the maximum number of connections MYSQL 3 methods Detailed Collection Method One: Go to installation directory, open the MYSQL MYSQL my.ini or my.cnf configuration file to find max_connections = 100 max_connections = 1000 revised to restart MY

  • The right to modify the maximum number of connections MySQL are three easy to use program 2010-10-25

    The following article focuses on the right to modify the maximum number of connections MySQL three easy to use program, and we all know that after installing the MySQL database, the default MySQL database, the maximum number of connections is 100, th

  • The right to modify the maximum number of connections MySQL three easy to use program 2010-10-25

    The following article focuses on the right to modify the maximum number of connections MySQL three easy to use program, we all know that after you have installed MySQL database, the default MySQL database, the maximum number of connections is 100, th

  • How to modify the maximum number of connections Sybase 2010-04-19

    Modify the maximum number of connections Sybase There are two ways, as follows: 1, into the Sybase central, right mouse button select the database server (to handle the server), then select the right menu of configuration options, Modify the number o

  • Modify the maximum number of connections MYSQL three methods Detailed 2010-10-13

    Modify the maximum number of connections MYSQL three methods Detailed Collection Method One: Open the installation directory into the MYSQL MYSQL my.ini or my.cnf configuration file to find max_connections = 100 max_connections = 1000 changes to serv

  • Modify the maximum number of connections oracle 2011-01-11

    1. View the current number of sessions, processes and values sessions and found that the number of session and 2 have been very approximate value of the parameter SQL * Plus: Release 10.2.0.1.0 - Production on Monday 9 October 15: 50:21 2006Copyright

  • Modify the maximum number of connections to the Sybase database 2011-10-22

    Today there is a customer that had a database error, let me see. Error: 1601, Severity: 17, State: 3 There are not enough 'user connections' available to start a new process. Retry when there are fewer active users, or ask your System Administrator t

  • modify the maximum number of connections mysql 2010-12-08

    MYSQL database installation is complete, the default maximum number of connections is 100, the general flow of a slightly larger number of forum or website in this connection is not enough, increase the default number of connections MYSQL There are t

  • Modify the maximum number of connections MYSQL three methods 2011-02-23

    MYSQL database installation is complete, the default maximum number of connections is 100, the general flow of a slightly larger number of forum or website in this connection is not enough, increase the default MYSQL connections there are two ways Me

  • Modify the maximum number of connections MySQL database 2010-02-25

    Today in a Glassfish Server to configure MySQL data source, I found the default maximum number of connections MySQL only 100, so decided to change to 200. Log in using the mysql root user, the Executive mysql> set GLOBAL max_connections = 200; OK, bu

  • to modify the maximum number of connections mysql 2010-12-08

    MYSQL database installation is complete, the default maximum number of connections is 100, the general flow of a slightly larger number of forum or website in this connection is not enough, increase the default MYSQL connections there are two ways Me

  • Mysql modify the maximum number of connections 2010-04-12

    Add the following code in the my.cnf [Mysqld] set-variable = max_connections = 1000 Amended 1000, you can restart the MySQL. View: mysqladmin-uroot-pxxxxx variables | grep max_connections Display: max_connections | 1000 Indicated that changes in succ

  • linux operating system to modify the maximum number of connections 2011-01-19

    For example, Linux version 2.6.18-194.el5 1, open vi / etc / security / limits.conf file in the file can be seen at the end of the following configuration: 2, * soft nofile 51200 * Hard nofile 51200

  • (Transfer) Oracle view and modify the number of its largest cursor 2010-08-28

    The following article is to introduce the Oracle view and modify its maximum number of cursors, this paper is the way through the code leads to Oracle view and modify its largest number of practical steps the cursor, the following is a description of

  • oracle View the maximum number of connections and the current number of connections and other information 2010-10-21

    At present the summary statement, in view of data connections are useful, while the test program code to finish the side view of the release of database connections help to analyze the situation of a robust system optimization program. 1. select coun

  • ORACLE maximum number of connections view. Settings 2010-04-02

    The current number of connections select count (*) from v $ process; Set the maximum number of connections (default is 150) select value from v $ parameter where name = 'processes'; Modify the maximum number of connections alter system set processes