Oracle Slows down. [message #302279] |
Mon, 25 February 2008 02:58 |
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 #302454 is a reply to message #302279] |
Mon, 25 February 2008 15:30 |
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
|
|
|