Sessions - How to Tumble Ondish Sessions?

[MuLtAnI]

Dae galera .... I wanted to know if anyone can help me with the following situation ....
I need to monitor the users of the users and if it reaches a certain amount of aciosity I overthrow ... can do this Based on the result of this select?

Select all

 
select v$session.sid, v$session.serial#, v$session.user#,  v$session.username, v$session.osuser, 
       v$session_wait.seconds_in_wait,v$session.status,  v$session_wait.state 
from 
   v$session, v$session_wait 
where 
   v$session.sid = v$session_wait.sid and 
   v$session.status in ('INACTIVE', 'KILLED') 

grateful

[] 's

[tfg]

If I do not mistake, there is a native form of Oracle do this. (A parameter, or something like that .. -> without using "gambiarras", hehe)

I'll see if I find something ... hence I put it here.

[MuLtAnI]

I imagined that there was such a control ... but I could not get anything about and ateh where I know the session controls are the V $ session tables ... if anyone can give me a light of how to manipulate any startup parameter or Something of the genre for me to inform conditions to overthrow the fiko grateful session ...

I'm researching TFG, if I find something I'll post here in the forum!


[] 's

[dr_gori]

You will get this using profiles ... Read on the subject!
See this link:
http://download-west.oracle.com/docs/cd ... tm#2052167

Select all

ALTER PROFILE default LIMIT IDLE_TIME  10;  --em minutos 
ALTER PROFILE engineer LIMIT IDLE_TIME UNLIMITED; 

No 8i works. I do not know if in previous versions they also work.

[MuLtAnI]

valeu Glufke!