| Session increase [message #260002] |
Fri, 17 August 2007 02:26  |
preet_kumar
Messages: 204
Registered: March 2007
|
Senior Member |
|
|
How to increase the sessions and process parameter,is it possible to change it without shutting down the database?
Thanks
|
|
|
|
|
|
|
|
|
|
| Re: Session increase [message #261871 is a reply to message #260002] |
Thu, 23 August 2007 21:34  |
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
|
Senior Member |
|
|
yeah!
I've encountered a problem like that, it noticed to me that "An error encountered when session limited".
Then, I've increase parameter session corresponding processes with:
Session:=(1.1*processes)+5.
And, created a procedure to kill any session with INACTIVE status.
declare
sv_ varchar2(10000);
begin
for zz in (
SELECT SID, SERIAL#, USERNAME, STATUS
FROM V$SESSION
WHERE USERNAME IS NOT NULL
AND STATUS = 'INACTIVE'
)
loop
sv_ := 'alter system kill session '''||zz.sid||', '||zz.SERIAL#||'''';
dbms_output.put_line(sv_);
--execute immediate sv_;
end loop;
end;
And, executed the UTLLOCKT.SQL to monitor LOCK table.
At the end, with Perfstat shema user, I executed spreport.sql to view snap_shot.
What anything else can I do for monitoring?
ORaDB: 10.2.0
OS: Unix
Thank you very much!
|
|
|
|
| Re: Session increase [message #261925 is a reply to message #261871] |
Fri, 24 August 2007 01:26 |
 |
Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...
|
Senior Member
Account Moderator |
|
|
Then you will likeky kill almost every one.
A session is inactive when it currently does not execute something.
Between 2 statements you are inactive for Oracle.
I hope your clients type very fast on their keyboard!
Regards
Michel
[Updated on: Fri, 24 August 2007 02:39] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
