minact-scn master-status: grec-scn:0x0000.0206dc80 gmin-scn:0x0000.0206dc31 gcalc-scn:0x0000.0206dc3b – KEBM: MMON action policy violation. ‘Block Cleanout Optim, Undo Segment Scan’ viol=1; err=12751 minact-scn master-status: grec-scn:0x0000.0206dc80 gmin-scn:0x0000.0206dc31 gcalc-scn:0x0000.0206dc3b – KEBM: MMON action policy violation. ‘Block Cleanout Optim, Undo Segment Scan’ viol=1; err=12751
SQL QUERY TO FIND THE NON SYS OBJECTS IN SYSTEM TABLESPACE SQL QUERY TO FIND THE NON SYS OBJECTS IN SYSTEM TABLESPACE
SQL ORDERED BY CPU TIME AND USER I/O WAIT TIME IN AWR REPORT SQL ORDERED BY CPU TIME AND USER I/O WAIT TIME IN AWR REPORT
SQL QUERY TO FIND TOP SEGMENTS IN SYSTEM TABLESPACE IN ORACLE SQL QUERY TO FIND TOP SEGMENTS IN SYSTEM TABLESPACE IN ORACLE
SQL QUERY TO FIND TOP CONTRIBUTORS OF SYSAUX OCCUPANTS SQL QUERY TO FIND TOP CONTRIBUTORS OF SYSAUX OCCUPANTS
BIG PPA TRACE FILES FILL UP QUICKLY IN BACKGROUND DUMP DEST IN ORACLE RAC WITH “WATSON_PRAGMA BEGINAPPEND file=pq.wat “ BIG PPA TRACE FILES FILL UP QUICKLY IN BACKGROUND DUMP DEST IN ORACLE RAC WITH “WATSON_PRAGMA BEGINAPPEND file=pq.wat “
ORA-01658: unable to create INITIAL extent for segment in tablespace SYSAUX ORA-01658: unable to create INITIAL extent for segment in tablespace SYSAUX