RE: sysaux purge problems
- From: John Hallas <John.Hallas@xxxxxxxxxxxxxxxxxx>
- To: "jeremy.schneider@xxxxxxxxxxxxxx" <jeremy.schneider@xxxxxxxxxxxxxx>, Oracle-L <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 9 Sep 2014 13:25:06 +0100
Have a look at the comments on a recent blog entry of mine - This was related
to a 11.2.0.4 database but it did seem to be a bug
Sorry I have not got more time to investigate myself - just tidying up my
Oracle-L folder and I noticed this
http://jhdba.wordpress.com/2014/07/09/tidying-up-sysaux-removing-old-snapshots-which-you-didnt-know-existed/
John
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Jeremy Schneider
Sent: 05 September 2014 18:36
To: Oracle-L
Subject: sysaux purge problems
I've reviewed the various MOS docs and bugs related to sysaux purge problems
already. I'm just wondering if anyone else out there has specifically seen
inconsistencies where it seems that the AWR is purging fine except for only the
ASH table? Or where DBMS_STATS.GET_STATS_HISTORY_AVAILABILITY reports that
data has been purged, but a select on dba_tab_stats_history shows otherwise?
maybe one of the existing bugs causes this behavior, just seemed to me from the
descriptions that get_stats_history_availability is generally accurate. i'll
work the SR and everything, just wondered if this problem was already solved
and I just missed the doc. the initial support guys aren't bad, but sometimes
oracle-l buddies correct my search misses faster. :)
btw this is on 11.2.0.3 psu11.
======== AWR/ASH:
SQL> select min(begin_interval_time) from dba_hist_snapshot;
MIN(BEGIN_INTERVAL_TIME)
---------------------------------------------------------------------------
2014-05-23 01:30:11
SQL> select min(sample_time) from DBA_HIST_ACTIVE_SESS_HISTORY;
MIN(SAMPLE_TIME)
---------------------------------------------------------------------------
2013-10-09 02:00:01
======== stats history:
SQL> SELECT DBMS_STATS.GET_STATS_HISTORY_AVAILABILITY FROM DUAL;
GET_STATS_HISTORY_AVAILABILITY
---------------------------------------------------------------------------
2014-08-05 00:01:08
SQL> select min(STATS_UPDATE_TIME) from dba_tab_stats_history;
MIN(STATS_UPDATE_TIME)
---------------------------------------------------------------------------
2013-09-15 01:01:06
SQL> select min(savtime) from WRI$_OPTSTAT_HISTHEAD_HISTORY;
MIN(SAVTIME)
---------------------------------------------------------------------------
2013-08-04 21:19:35
--
http://about.me/jeremy_schneider
______________________________________________________________________
Wm Morrison Supermarkets Plc is registered in England with number 358949. The
registered office of the company is situated at Gain Lane, Bradford, West
Yorkshire BD3 7DL. This email and any attachments are intended for the
addressee(s) only and may be confidential.
If you are not the intended recipient, please inform the sender by replying to
the email that you have received in error and then destroy the email.
If you are not the intended recipient, you must not use, disclose, copy or rely
on the email or its attachments in any way.
This email does not constitute a contract in writing for the purposes of the
Law of Property (Miscellaneous Provisions) Act 1989.
Our Standard Terms and Conditions of Purchase, as may be amended from time to
time, apply to any contract that we enter into. The current version of our
Standard Terms and Conditions of Purchase is available at:
http://www.morrisons.co.uk/gscop
Although we have taken steps to ensure the email and its attachments are
virus-free, we cannot guarantee this or accept any responsibility,
and it is the responsibility of recipients to carry out their own virus checks.
______________________________________________________________________
Other related posts:
