OraFAQ Forum: Performance Tuning » Access to the database is very slow.

Home » RDBMS Server » Performance Tuning » Access to the database is very slow.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Access to the database is very slow. [message #190846]

Fri, 01 September 2006 09:55

jesuisantony
Messages: 166
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

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: Access to the database is very slow. [message #198425 is a reply to message #190846]

Tue, 17 October 2006 02:38

sandeepdba
Messages: 1
Registered: August 2006

Junior Member

i am also facing same problem..
plz reply at sandeepdba@gmail.com
if got some solution

Report message to a moderator

Re: Access to the database is very slow. [message #207430 is a reply to message #190846]

Tue, 05 December 2006 09:13

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

Report message to a moderator

Re: Access to the database is very slow. [message #207432 is a reply to message #207430]

Tue, 05 December 2006 09:32

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

Report message to a moderator

Previous Topic:	Stored Procedure Performance Slows
Next Topic:	bit confused about Execution Plan

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 27 02:49:14 CST 2024