Home » RDBMS Server » Server Administration » how to refresh v$session with out kill session (10g & 9i )
how to refresh v$session with out kill session [message #380620] Mon, 12 January 2009 14:33 Go to next message
ah_houssam
Messages: 2
Registered: January 2009
Junior Member
when other machine connect to database i can do

select * from v$session;

but when a pc disconected from the network illegal with in way

the session still showing me his name in v$session how to refresh it automaticaly without having to kill session

pls advice
Re: how to refresh v$session with out kill session [message #380625 is a reply to message #380620] Mon, 12 January 2009 14:54 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
>the session still showing me his name in v$session how to refresh it automaticaly without having to kill session

The database does not know or care the client went missing.
There is no automagic solution.
Re: how to refresh v$session with out kill session [message #380626 is a reply to message #380620] Mon, 12 January 2009 14:58 Go to previous messageGo to next message
JackyShu
Messages: 25
Registered: May 2008
Junior Member
eventually the query will time out.
occasionally, i have to kill it, such as a big query.
Re: how to refresh v$session with out kill session [message #380627 is a reply to message #380620] Mon, 12 January 2009 15:03 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
>eventually the query will time out.
There may not be any active SQL running & the client was just idle with the DB awaiting next command.
So the DB continues to wait & wait & wait.
Re: how to refresh v$session with out kill session [message #380654 is a reply to message #380627] Mon, 12 January 2009 22:20 Go to previous messageGo to next message
ah_houssam
Messages: 2
Registered: January 2009
Junior Member
MY APPLICATION SECURITY IS DEPEND ON V$SESSION TO ASURE THAT THE NAMED USER IS CONNECTED ARE THERE ANY WAY TO NOW THE SESSION CONNECTED EVERY TIME AND IF THE CONNECTION FAILED IT REFRESH AUTOMATICALLY
Re: how to refresh v$session with out kill session [message #380656 is a reply to message #380620] Mon, 12 January 2009 22:34 Go to previous message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you.

It appears your CAPS LOCK key is broken & stuck in the ON position.

The reality is that from Oracle RDBMS perspective the session
still exists; so the DB is unaware of any "problem".
Such a situation is REALLY not a security problem;
since nobody can reestablish a connection to the "dangling" session.

How would an independent observer conclude your problem has been
solved based upon which metric & what value?

Does each application user have their own Oracle schema?
Previous Topic: Local and Global indexes in oracle
Next Topic: sys user problem
Goto Forum:
  


Current Time: Sun Dec 04 02:44:44 CST 2016

Total time taken to generate the page: 0.10262 seconds