If you set profile limits, make sure that you also have "resource_limt =
true"
in your init.ora file.
Glenn Berry wrote in message <34B4FDEC.B436D932_at_gb-data.demon.co.uk>...
>Do NOT do this, a session can be 'inactive' in between queries.
>
>Change the default profile to have an idle time limit.
>
>ALTER PROFILE DEFAULT LIMIT IDLE_TIME 30;
>
>This is in minutes and is very useful.
>
>Glenn.
>
>BT and I have a deal:-
>I don't speak for them, they don't speak for me.
>
>
>Billy Verreynne wrote:
>
>> Niels S. Eliasen wrote in message ...
>> > Anyone figured out how to kill off idle user-processes ??
>>
>> Create a SQL script that selects the sid and seriial# from all inactive
>> sessions from v$session, spools the output to file and then run the
>> spoolfile thru SQL*Plus. Something like this:
>> SELECT 'ALTER SYSTEM KILL SESSION '''||sid||','||serial#||'''' FROM
>> v$session WHERE status='INACTIVE';
>
>
>
Received on Thu Jan 08 1998 - 00:00:00 CST
