Re: Oracle 10g RAC
Date: Fri, 14 Aug 2009 06:29:29 +0200
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.
-- http://www.freelists.org/webpage/oracle-l Am 14.08.2009 um 03:56 schrieb Sanjay Mishra:Received on Thu Aug 13 2009 - 23:29:29 CDT
> 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