View the number of current connections for Oracle __oracle

How do I see the current number of connections to Oracle? Just use the following SQL statement to query.

SELECT * FROM v$session where username
Is isn't null Select Username,count (username) from
V$session where username is isn't null GROUP by username

To view the number of connections for different users

Select COUNT (*) from v$session

Number of connections

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

Number of concurrent connections

Show parameter processes

Maximum Connection

alter system SET processes = value scope = SPFile;

Restart Database Modify Connection

/home/oracle9i/app/oracle9i/dbs/init.ora/home/oracle9i/app/oracle9i/dbs/spfilexxx.ora
# # Open_cursor

The above related content is the Oracle current connection number related content Introduction, hoped you can have the harvest.