Oracle 10g slow and hangs

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
MyDanesAsked:
Who is Participating?
 
NicksonKohCommented:
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
 
MyDanesAuthor Commented:
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
 
MyDanesAuthor Commented:
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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
MyDanesAuthor Commented:
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
 
MyDanesAuthor Commented:
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
 
MyDanesAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.