Home » SQL & PL/SQL » SQL & PL/SQL » Too long sessions
Too long sessions [message #6943] Tue, 13 May 2003 03:31 Go to next message
Eric
Messages: 78
Registered: April 1999
Member
Hi,

Is it possible to parameter a TIME-OUT server side (Oracle 8.1.7), which could kill too long sessions ?

Regards,
Eric

Report message to a moderator

Re: Too long sessions [message #6947 is a reply to message #6943] Tue, 13 May 2003 04:29 Go to previous messageGo to next message
Oskar
Messages: 26
Registered: May 2002
Junior Member
Yes,

Use a profile. Specify the parameter IDLE_TIME to limit the time a session can idle.

Report message to a moderator

Re: Too long sessions [message #6948 is a reply to message #6947] Tue, 13 May 2003 06:22 Go to previous messageGo to next message
Eric
Messages: 78
Registered: April 1999
Member
Thanks, it corrects the case where the session sleeps

But can i limit an SQL ORDER (30 seconds for example), and then kill the session ?

Regards,
Eric

Report message to a moderator

Re: Too long sessions [message #6967 is a reply to message #6943] Wed, 14 May 2003 01:56 Go to previous messageGo to next message
Oskar
Messages: 26
Registered: May 2002
Junior Member
Don't know if there is an easier way but take a look to this site http://asktom.oracle.com/pls/ask/f?p=4950:8:166336518620639516::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:1198012113596,

You could shedule a job which runs every 30 seconds exeuting a procedure that checks long running queries. Then use an ALTER SYSTEM KILL SESSION statement inside this procedure to kill those queries.

Report message to a moderator

Re: Too long sessions [message #7011 is a reply to message #6967] Thu, 15 May 2003 03:36 Go to previous message
Eric
Messages: 78
Registered: April 1999
Member
Thanks, it will help me very much.

Where is the information for resources per session ? (I've searched in v$session, but didn't find it)

How is managed memory (or system resource) in ORACLE ? Some SQL request may consume lots of resources, when is it free ?

Regards,
Eric

Report message to a moderator

Previous Topic: Columns in a select Statement
Next Topic: Wanted to find all related columns in other tables
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 24 20:21:54 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.