Re: Oracle 10g RAC
- From: Martin Berger <martin.a.berger@xxxxxxxxx>
- To: smishra_97@xxxxxxxxx
- Date: Fri, 14 Aug 2009 06:29:29 +0200
Sanjay,
is it only a dedicated sql or does all selects behave like this?
if you have ash/awr licesed, can you run a ash report for this period
of time? (if not, you can manually sample event and seq# from v
$session of the session, which runs the sql currently)
did the execution plan change?
can you pin the time, when execution switch from fast to slow, and can
you classify the overall situation on your instances at this point of
time?
Just some starting questions to reduce guesswork.
regards,
Martin
--
//www.freelists.org/webpage/oracle-l
Am 14.08.2009 um 03:56 schrieb Sanjay Mishra:
Hi
I had 3 Node RAC on Solaris and I am facing one scenario very
frequently where a select query start taking too much time in
execution. It take only few seconds but after some time it changed
to few minutes. At this time if I flush Buffer Cache on all Node, it
come back to same few seconds and then after some time, it changed
back to same situation. Any expert comments as what can be issue
here. Oracle 10.2.0.3. This RAC environment is running 3 Database
sand the problem is only with one Database and so it is not linked
to interconnect which can give this issue. Also Select is only
bringing few records and not high number of records
TIA
Sanjay
Other related posts:
