| Disconnect from oracle DB. [message #466847] |
Wed, 21 July 2010 08:49  |
SAKOURA
Messages: 52
Registered: June 2010
Location: France
|
Member |
|
|
Hi everybody,
Is there any setting on oracle that allows to disconnect users automatically and display a message to users such: "Try a new connection to the db in 30 minutes"?
Thanks in advance for your help.
Sak.
|
|
|
|
|
|
| Re: Disconnect from oracle DB. [message #466872 is a reply to message #466847] |
Wed, 21 July 2010 09:41  |
SAKOURA
Messages: 52
Registered: June 2010
Location: France
|
Member |
|
|
Hi Michel,
According to your link a profile allows many things among them: "•Amount of idle time available for the user's session"
Does it mean that a user is disconnected if he is not using the db?
Thx in advance.
Sak.
|
|
|
|
|
|
| Re: Disconnect from oracle DB. [message #467033 is a reply to message #466881] |
Thu, 22 July 2010 01:33 |
SAKOURA
Messages: 52
Registered: June 2010
Location: France
|
Member |
|
|
Hi Michel,
I found the following command: "create profile appl_profile limit idle_time 15 -- minutes".
Should I run it for under a connection with my db user or the user Sys (or System) or another one?
Thanks in advance for your help.
Sak.
|
|
|
|
|
|
| Re: Disconnect from oracle DB. [message #467073 is a reply to message #466847] |
Thu, 22 July 2010 03:58 |
SAKOURA
Messages: 52
Registered: June 2010
Location: France
|
Member |
|
|
Well, I did ...
I create a new profile (disconnection after 5') with a DBA account then I assigned it to my db user. Next step was a connection to the db through my software and ... nothing happened: After 5, 10, 15'... I could insert infos in the db tables !
Had I forget something? Is there another setting?
Thx in advance for your replies!
Sak.
|
|
|
|
| Re: Disconnect from oracle DB. [message #467125 is a reply to message #467073] |
Thu, 22 July 2010 05:10 |
 |
Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Quote:nothing happened
Had you a look to session status in v$session? The session is killed (SNIPED) but you have nothing on your interface as it is your turn to talk to Oracle and it is waiting for you to ask it to do something to tell you that you have been disconnected.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
