?
Solved

Oracle 10g slow and hangs

Posted on 2007-04-10
6
Medium Priority
?
6,337 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

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 2000 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

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

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

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…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
Via a live example, show how to take different types of Oracle backups using RMAN.
Suggested Courses

801 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