Home » RDBMS Server » Performance Tuning » Access to the database is very slow.
Access to the database is very slow. [message #190846] Fri, 01 September 2006 09:55 Go to next message
jesuisantony
Messages: 132
Registered: July 2006
Location: Chennai
Senior Member
We have installed Oracle 10g express edition in a red hat Linux server. All of a sudden the connectivity to the database was extremely slow. Only some 7 users are accessing the database. Not sure what is the problem. Can somebody help me on this? I have pasted few line from the trace log. =================================================================Memory Notification: Library Cache Object loaded into SGA
Heap size 2071K exceeds notification threshold (2048K)
Details in trace file /usr/lib/oracle/xe/app/oracle/admin/XE/udump/xe_ora_18615.trc
KGL object name :GCOTDTEST.SP_ADMIN_WRAPPER
Memory Notification: Library Cache Object loaded into SGA
Heap size 2907K exceeds notification threshold (2048K)
KGL object name ELECT b.object_type, b.owner, b.object_name FROM all_objects a, public_dependency p, all_objects b WHERE a.owner = wner and a.object_name = :name and a.object_type = :type and a.object_id = p.object_id and p.referenced_object_id = b.object_id and a.owner <>
WARNING: inbound connection timed out (ORA-3136)
=================================================================

[Updated on: Fri, 01 September 2006 09:56]

Report message to a moderator

Re: Access to the database is very slow. [message #190887 is a reply to message #190846] Fri, 01 September 2006 20:45 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>All of a sudden the connectivity to the database was extremely slow
Figure out what changed & change it back the way it was before the slowdown.
Re: Access to the database is very slow. [message #198425 is a reply to message #190846] Tue, 17 October 2006 02:38 Go to previous messageGo to next message
sandeepdba
Messages: 1
Registered: August 2006
Junior Member
i am also facing same problem..
plz reply at sandeepdba@gmail.com
if got some solution
Re: Access to the database is very slow. [message #207430 is a reply to message #190846] Tue, 05 December 2006 09:13 Go to previous messageGo to next message
vimal_vpsk
Messages: 18
Registered: March 2005
Junior Member
Hi,

I am also facing the same error. We have installed Oracle 10G version 10.2.0.2.0. Can anyone tell me the solution for this one ASAP?

WARNING: inbound connection timed out (ORA-3136)

Regards
Vimal
Re: Access to the database is very slow. [message #207432 is a reply to message #207430] Tue, 05 December 2006 09:32 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi all,

Ora - 03136

ORA-03136: inbound connection timed out

Cause: Inbound connection was timed out by the server because user authentication was not completed within the given time specified by SQLNET.INBOUND_CONNECT_TIMEOUT or its default value

Action: 1) Check SQL*NET and RDBMS log for trace of suspicious connections. 2) Configure SQL*NET with a proper inbound connect timeout value if necessary.


Go through below link

http://forums.oracle.com/forums/thread.jspa?messageID=1500058&#1500058


hope this helps
Taj
Previous Topic: Stored Procedure Performance Slows
Next Topic: bit confused about Execution Plan
Goto Forum:
  


Current Time: Wed Dec 07 12:24:02 CST 2016

Total time taken to generate the page: 0.19238 seconds