Many connections established at a time [message #308438] |
Mon, 24 March 2008 05:49  |
Oraclist
Messages: 33 Registered: January 2008 Location: Dhaka, Bangladesh
|
Member |
|
|
From Application level in my database at a time many connection is established and those are not disconnected. What can I track when they establish and when they disconnect?
Or at least what the possible reason that the connection is not disconnected?
|
|
|
|
|
|
Re: Many connections established at a time [message #308617 is a reply to message #308438] |
Tue, 25 March 2008 01:15   |
Oraclist
Messages: 33 Registered: January 2008 Location: Dhaka, Bangladesh
|
Member |
|
|
Michel , my apologizes, I know some about auditing. What information exactly I need to audit so that I can know which client is disconnected/exited from database.
I mean audit on schema or audit on network?
|
|
|
|
Re: Many connections established at a time [message #308650 is a reply to message #308438] |
Tue, 25 March 2008 02:31   |
Oraclist
Messages: 33 Registered: January 2008 Location: Dhaka, Bangladesh
|
Member |
|
|
Thank you so much. One last episode about this, when I audit at audit_trail =DB level the entry is populated in DBA_AUDIT_TRAIL and SYS.AUD$ table. I see that after sometime (when I log on and agin log off)new entry is generating and replacing old one.
How I can get back of previous one or at least no entry will be delete / history.
[Updated on: Tue, 25 March 2008 02:32] Report message to a moderator
|
|
|
Re: Many connections established at a time [message #308665 is a reply to message #308650] |
Tue, 25 March 2008 02:54  |
 |
Michel Cadot
Messages: 68737 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
Quote: | I see that after sometime (when I log on and agin log off)new entry is generating and replacing old one.
|
This is not Oracle that does this.
This only thing Oracle does is to UPDATE the logon row with logoff time when you disconnect.
It never replace old rows.
Regards
Michel
|
|
|