Solved

Oracle 10g slow and hangs

Posted on 2007-04-10
6
6,283 Views
Last Modified: 2013-12-18
oracle 10g SLOW SLOW SLOW - URGENT ****
Everything on my oracle 10g
Windows 2003 server
3gb RAM

Opening the EM console for a database takes a long time and tyring to view a table runs and runs and runs and NEVER opens

MS Access I had to change the timeout on odbc driver to off because just to 'establish' a link connection would error out with ORA-01013

SOMEthing is radically wrong please help
0
Comment
Question by:MyDanes
  • 5
6 Comments
 

Author Comment

by:MyDanes
ID: 18885870
WHEN i LOGIN THROUGH SQLPLUS (DOS THEN SQLPLUS/NOLOG THEN LOGIN TO MY DB) IT WORKS FINE IS SOMETHING WITH APPLICATIONS GAINING ACCESS INCLUDING ODBC AND THE NATIVE ORACLE IE BASED STUFF
0
 

Author Comment

by:MyDanes
ID: 18885931
76.2 PL/SQL execution consumed significant database time. 5SQL Tuning
50.7 Time spent on the CPU by the instance was responsible for a substantial part of database time. 3SQL Tuning
12 SQL statements were not shared due to the usage of literals. This resulted in additional hard parses which were consuming significant database time. 1Application Analysis
8.5 The SGA was inadequately sized, causing additional I/O or hard parses. 1DB Configuration
3.4 SQL statements consuming significant database time were found.
0
 

Author Comment

by:MyDanes
ID: 18885939
i DON'T KNOW WHAT TO DO ABOUT THE ABOVE THINGS I LEARNED i DON'T KNOW HOW TO GET INTO QUERY ANALYZER AND i TRIED TO FIND SOMETHING IN THE MONITORING SECTION TO 'AUTO' TAKE CARE OF THE ISSUES IT FOUND
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:MyDanes
ID: 18885961
OK I FIND LOTS OF 'MONITORING' SECTIONS BUT NOTHING TO ACTUALLY IMPROVE THEM

BEGIN EMD_NOTIFICATION.QUEUE_READY(:1, :2, :3); END;

FOR EXAMPLE THE ABOVE IS GIVEN AND IT SAYS:

SQL statement with SQL_ID "2b064ybzkwf1y" was executed 40 times and had an average elapsed time of 5.3 seconds

Average CPU used per execution was 5.2 seconds.

hOW ON EARTH DO I FIX THIS AND THE OTHER THINGS IT ADVISES???
0
 
LVL 17

Accepted Solution

by:
NicksonKoh earned 500 total points
ID: 18886517
Hi MyDanes,

First thing "calm down". Panicking would only serve to confuse and clot your mind. Go to the toilet and wash your face.

The possible solution (I just know some DBA knowledge :p, so my advise will be very limited) :
- Is restarting the database an option? Best is to shutdown the database and restart the entire server. No harm telling people that the server needs to be restarted especially when it is hanging and I presume everybody can't run the application properly.
- If you have Oracle support, call them for help.
- I am also suspecting that some application is hanging up that entire application. Find and kill that session. It may frustrating to do this especially when the database is performing horribly now.

Cheers,
NicksonKoh
0
 

Author Comment

by:MyDanes
ID: 18907515
After STUBORNLY not wishing to take the system offline (24hr shop) I finally GAVE IN and GUESS WHAT.............................

The going and washing my face and calming down while rebooting TOOK CARE of the issue thanks a lot.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question