| process Vs session [message #62344] |
Thu, 15 July 2004 21:32  |
Tandle
Messages: 3
Registered: July 2004
|
Junior Member |
|
|
In init.ora file we set these parameters
what is the difference between these 2 parameters.how can u monitor from database that how many sessions r used and how many process r used.
processes 200
sessions 225
|
|
|
|
| Re: process Vs session [message #62347 is a reply to message #62344] |
Fri, 16 July 2004 01:50  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
Check the Oracle Reference Guide for the differences. Here is a query to monitor their usage:
SQL> r
1 SELECT * FROM v$resource_limit
2* WHERE resource_name IN ('sessions', 'processes')
RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_AL LIMIT_VALU
-------------------- ------------------- --------------- ---------- ----------
processes 20 24 150 150
sessions 23 31 170 170
Best regards.
Frank
|
|
|
|
| Re: process Vs session [message #62350 is a reply to message #62344] |
Fri, 16 July 2004 04:02 |
BhavinShah
Messages: 105
Registered: February 2004
|
Senior Member |
|
|
hi.
PROCESS PARAMETER SHOWS NO. OF ORACLE PROCESSES RUN AT A TIME.. MEANS HERE ONLY 200 PROCESSES RUNS AT A PARTICULAR TIME.
SESSION PARAMETER TELLS U MAX NO OF SESSION WHICH WILL ALLOW TO CONNECT WITH THE DATABASE..
HOPE U WILL GET SOME THING FROM THIS.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
