| query and wait problem [message #63798] |
Mon, 08 November 2004 20:11  |
ramya
Messages: 87
Registered: August 2002
|
Member |
|
|
Hi
I am facing a problem my query taking too much time to run(response time is long).I checked the waits.How shall i tune the
system to reduce the waits and imporve the performance.Whether its realted to slow disk system or i have to tune the sga parameters more.
wiht regards
ramya
select EVENT,
TOTAL_WAITS,
TOTAL_TIMEOUTS,
TIME_WAITED,
round(AVERAGE_WAIT,2) "Average Wait"
from v$system_event
EVENT TOTAL_WAITS
db file scattered read 1056638
db file sequential read 1572768
rdbms ipc message 276606
SQL*Net message from client 386402
SQL*Net message to client 386413
|
|
|
|
| Re: query and wait problem [message #63803 is a reply to message #63798] |
Tue, 09 November 2004 02:42  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
Always please post along with relevant information.
Oracle version, execution plan etc.
>>db file scattered reads
indicates that there are more multi-block i/o happening.
without a statspack/trace/plan , let me guess something.
check whether you have the right columns indexed.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
