Solved

Oracle 10g slow and hangs

Posted on 2007-04-10
6
6,312 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Independent Software Vendors: 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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

696 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