| how to refresh v$session with out kill session [message #380620] |
Mon, 12 January 2009 14:33  |
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 #380656 is a reply to message #380620] |
Mon, 12 January 2009 22:34  |
 |
BlackSwan
Messages: 26766
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?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
