Guest

Preview Tool

Cisco Bug: CSCvr96003 - SYSAUX tablespace is getting filled up with AWR and OPSSTAT data

Last Modified

Oct 16, 2020

Products (1)

  • Cisco Identity Services Engine

Known Affected Releases

2.4(0.357) 2.6(0.156) 2.7(0.356)

Description (partial)

Symptom:
SYSAUX table space is filling and we can see some disappearance on queries or logging.

Conditions:
Run the show tech-support and check table space is size for SYSAUX.
TABLESPACE SIZE

TABLESPACE           TOTAL_SPACE_MB       USED_SPACE_MB        FREE_SPACE_MB
-------------------- -------------------- -------------------- --------------------
SYSAUX               4325                 4184                 141
CACHETBLSP           100                  1                    99
MNTNS                387800               125808               261992
SYSTEM               840                  771                  69
CPMNS                2700                 1189                 1511

Tue Oct 29 12:02:43 2019
ORA-01683: unable to extend index ORA-01683: unable to extend index SYS.WRH$_EVENT_HISTOGRAM_PK partition WRH$_EVENT__2934536496_4287 by 128 in tablespace SYSAUX
Tue Oct 29 12:45:10 2019
ORA-1688: unable to extend table SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY partition SYS_P21686 by 128 in tablespace SYSAUX
Tue Oct 29 16:07:03 2019
Bug details contain sensitive information and therefore require a Cisco.com account to be viewed.

Bug Details Include

  • Full Description (including symptoms, conditions and workarounds)
  • Status
  • Severity
  • Known Fixed Releases
  • Related Community Discussions
  • Number of Related Support Cases
Bug information is viewable for customers and partners who have a service contract. Registered users can view up to 200 bugs per month without a service contract.