Home » RDBMS Server » Performance Tuning » Oracle Slows down.
Oracle Slows down. [message #302279] Mon, 25 February 2008 02:58 Go to next message
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
Hi all,

From today morning i face a problem of oracle slows down.
If i execute any qyery it takes more time to execute than the normal time.

I checked if OS processes affecting oracle through TOP command. But at the OS end but no OS process using much resouces.

Please let me know if i want to pinpoint the cause of the Oracle slow down where can i check into oracle or any possible solutions.

Thanks in advance.

[Updated on: Mon, 25 February 2008 02:59]

Report message to a moderator

Re: Oracle Slows down. [message #302291 is a reply to message #302279] Mon, 25 February 2008 03:44 Go to previous messageGo to next message
Michel Cadot
Messages: 63911
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
How to Identify Performance Problem and Bottleneck and OraFAQ Oracle SQL Tuning Guide.

Re: Oracle Slows down. [message #302454 is a reply to message #302279] Mon, 25 February 2008 15:30 Go to previous message
Messages: 282
Registered: March 2005
Senior Member

hi, could you do the following

when you run your query, can you in another session run a vmstat 5 13

this will give an indication of what is happening.

also try this script

select c.* from
    (select disk_reads,
--	    address,
--  	    hash_value,
       from v$sqlarea
       where parsing_user_id !=0
       order by
          buffer_gets/decode(executions,null,1,0,1,executions) desc ) c
where rownum < 5;

and post the result back here


Previous Topic: Effect of size of composite primary key on IOT performance.
Next Topic: Whats the difference between these two queries ? - tunning purspective
Goto Forum:

Current Time: Sat Oct 22 18:44:25 CDT 2016

Total time taken to generate the page: 0.14217 seconds