Monthly Archives: July 2013

Recompile database objects (utlrp) fails with: ORA-04045: errors during recompilation/revalidation of SYS.DBMS_REGISTRY_SYS

Hi just discovered another flaw when having the workaround for CVE-2012-3132 in place. If you try to compile invalid database objects it will fail with: SQL> @$ORACLE_HOME/rdbms/admin/utlrp SELECT dbms_registry_sys.time_stamp(‘utlrp_bgn’) as timestamp from dual * ERROR at line 1: ORA-04045: errors … Continue reading

Posted in Oracle in general | 4 Comments

Quick & Dirty: AWR Query for Tablespace groth

The query: select   rtime as time,   sn.snap_id,   ts.name,   round(tablespace_size*tsb.block_size/1024/1024,0) SIZE_MB,   round(tablespace_maxsize*tsb.block_size/1024/1024,0) MAXSIZE_MB,   round(tablespace_usedsize *tsb.block_size/1024/1024,0) USEDSIZE_MB from   dba_hist_tbspc_space_usage tsu,   v$tablespace ts,   dba_hist_snapshot sn,   dba_tablespaces tsb where   tsu.tablespace_id=ts.ts#   and sn.snap_id= … Continue reading

Posted in Oracle in general | Leave a comment