Q
Problem solve Get help with specific problems with your technologies, process and projects.

Closing connections to Oracle database takes too long

Closing connections to my Oracle database takes up to 40 seconds. We have several apps that open a connection, grab some data, then close the connection. However the apps are often timing out because closing the connections take so long.

My environment is Oracle 9i on Linux. My problem: closing connections to this DB takes up to 40 seconds. We have several apps that open a connection, grab some data, then close the connection. However the apps are often timing out because closing the connections take so long. It's not just the apps. Closing connections from Toad and other tools takes just as long. Any ideas where to begin looking?
Does the database have a Before Logoff trigger? If it does the problem could be there. Another thing to check, see if Auditing is enabled. If Auditing is enabled, Oracle logs all user disconnects by updating the aud$ table with the logout time. Your aud$ table could be large and if it is doing a table scan this would cause the delay. The best suggestion I have is to start a session trace on your session and then log off. On your database server, go to the UDUMP directory and get that trace file for your session. The trace file will show any and all code that your session executes in the database. Use tkprof to format the trace file and from there you should be able to see what is taking the time.

Dig Deeper on Oracle database performance problems and tuning

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close