Cursor Invalidations in Standby
From: Rakesh Ra <rakeshra.tr_at_gmail.com>
Date: Thu, 10 Jan 2019 15:32:23 +0530
Message-ID: <CAOGpvWpipn-Y1orWLmd=APFw3kOVojOOFLOtJCJrqsLKJ2WtUw_at_mail.gmail.com>
Hi All,
LAST_LOAD_TIME
------------- ------ ---------- ---------- ------------- -------------
Date: Thu, 10 Jan 2019 15:32:23 +0530
Message-ID: <CAOGpvWpipn-Y1orWLmd=APFw3kOVojOOFLOtJCJrqsLKJ2WtUw_at_mail.gmail.com>
Hi All,
I am seeing some serious cursor invalidations in standby database of version 11.1.0.7 when stats is being run on primary. Even we have no_invalidate set to TRUE while gathering stats on primary as shown below
Primary:
exec DBMS_STATS.GATHER_TABLE_STATS ( ownname=>'xxxxx', tabname=>'yyyyy',
estimate_percent=>20, degree=>4, no_invalidate=> TRUE, cascade=>TRUE );
Standby:
SQL_ID CHILD PLAN_HASH EXECS ETIME AVG_ETIME USERNAME PARSING_SCHEMA_NAME ROWS_PROCESSED INVALIDATIONSFIRST_LOAD_TIME
LAST_LOAD_TIME
------------- ------ ---------- ---------- ------------- -------------
- --------------------------- -------------- -------------
6w6ypapws9bwa 0 2540110261 10 62.57 6.26 READR READR 3239 18 2018-08-10/10:48:36 2019-01-08/23:09:33
Anyone has come across this issue and what could be the possible reason for this?
Regards,
Rakesh RA
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jan 10 2019 - 11:02:23 CET