Solved

Oracle 10g slow and hangs

Posted on 2007-04-10
6
6,217 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

758 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now