Home » RDBMS Server » Networking and Gateways » Many connections established at a time (Solaris, 10.2g)
Many connections established at a time [message #308438] Mon, 24 March 2008 05:49 Go to next message
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 #308501 is a reply to message #308438] Mon, 24 March 2008 10:05 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
What can I track when they establish and when they disconnect?

You can use "audit" to log connections.

Quote:
Or at least what the possible reason that the connection is not disconnected?

Your client close his window without disconnecting, for instance.

Regards
Michel
Re: Many connections established at a time [message #308571 is a reply to message #308438] Mon, 24 March 2008 23:11 Go to previous messageGo to next message
Oraclist
Messages: 33
Registered: January 2008
Location: Dhaka, Bangladesh
Member
Please give an idea how I can do "audit" to log connections.

By audit network or how?

Re: Many connections established at a time [message #308607 is a reply to message #308571] Tue, 25 March 2008 01:02 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
AUDIT

Regards
Michel
Re: Many connections established at a time [message #308617 is a reply to message #308438] Tue, 25 March 2008 01:15 Go to previous messageGo to next message
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 #308632 is a reply to message #308617] Tue, 25 March 2008 01:57 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL> audit session;

Audit succeeded.


Regadrs
Michel

[Updated on: Tue, 25 March 2008 01:58]

Report message to a moderator

Re: Many connections established at a time [message #308650 is a reply to message #308438] Tue, 25 March 2008 02:31 Go to previous messageGo to next message
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 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: ORA-12528: TNS:listener: all appropriate instances are blocking new connections
Next Topic: reconfigure of listener port from 1527 to 1521
Goto Forum:
  


Current Time: Fri Mar 29 07:29:06 CDT 2024