| sessions in 9i [message #62194] |
Sun, 04 July 2004 23:35  |
Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland
|
Senior Member |
|
|
Hi all,
we need to determine sessions in our database. My question is how oracle counts the sessions. If I look in v$session I saw 130 sessions. But counts oracle ACTIVE and INACTIVE sessions for reaching the sessions and processes parameter in init.ora ?
We now wants to make a atatistic for used sessions to be prepared when we reache the next borderline of 500 sessions and processes.
does anyone have a good script for me to fix this out and how high is the max number of sessions and processes in 9i.
regards
Uwe
|
|
|
|
| Re: sessions in 9i [message #62203 is a reply to message #62194] |
Mon, 05 July 2004 07:33  |
croK
Messages: 170
Registered: April 2002
|
Senior Member |
|
|
WinNT
oracle 9201
this is my testcase:
init.ora processes=15
startup db
login as system: select*from v$session
returs 6 background processes plus my connection
tried to login from several sqlplus session and i can
only login 4 more sessions, that totals 11 session.
I got ora error 00020 if i try to login again.
So, processes = 15 but i can only have 11 sessions (including oracle background processes).
Best regards...
www.otools.com.ar
|
|
|
|
| Re: sessions in 9i [message #62221 is a reply to message #62203] |
Tue, 06 July 2004 01:02 |
Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland
|
Senior Member |
|
|
But what did you set in sessions ??? I think the logged sessions in v$session will display the sessions and v$processes the processes, arn't they ?
If sessions set to 11 than your v$sessions couild be right.
But my question is if all the sessions count for that limit (ACITVE and INACTIVE) I geuss yes, because this sessions are Inactive but connected.
And what will be the limit of sessions and processes in 9i
|
|
|
|
| Re: sessions in 9i [message #62234 is a reply to message #62221] |
Tue, 06 July 2004 08:24 |
croK
Messages: 170
Registered: April 2002
|
Senior Member |
|
|
Hi, it was my mistake.
PROCESS=15, that's why i couldn't login when reached that value.
And SESSIONS=21 in my system.
Regarding your question: YES, active+inactive sessions
counts for parameter SESSIONS.
V$process list oracle operating system process and some pretty stuff related to those processes.
V$session list sessions initiated within the database.
Regards.
|
|
|
|
| Re: sessions in 9i [message #62240 is a reply to message #62234] |
Tue, 06 July 2004 22:10 |
Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland
|
Senior Member |
|
|
Thanks, CroK
now my only question is about the limits of 9i. I found that 8i has 32767 as limit for sessions. But has 9i the same or raised up ?
That will be good to know, because we want to set up a database with a big mount of users - and now with e.g. 80 users we have 230+ processes. I guess we'll reach some límits before we got the 32767 but it will nice to know to take placve in the conversation with our software-distributor.
thanks
Uwe
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
