Home » RDBMS Server » Performance Tuning » Oracle Slows down.
Oracle Slows down. [message #302279] Mon, 25 February 2008 02:58 Go to next message
ora_2007
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: 68665
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
How to Identify Performance Problem and Bottleneck and OraFAQ Oracle SQL Tuning Guide.

Regards
Michel
Re: Oracle Slows down. [message #302454 is a reply to message #302279] Mon, 25 February 2008 15:30 Go to previous message
alanm
Messages: 284
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,
            buffer_gets,
            rows_processed,
            executions,
--	    address,
--  	    hash_value,
            first_load_time,
            sql_text
       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

regards

Alan
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: Sun Jun 30 14:17:18 CDT 2024