-
Archives
- April 2019
- March 2019
- September 2018
- August 2016
- July 2016
- May 2015
- April 2015
- December 2014
- November 2014
- August 2014
- February 2014
- January 2014
- November 2013
- July 2013
- June 2013
- March 2013
- December 2012
- September 2012
- August 2012
- July 2012
- June 2012
- May 2012
- March 2012
- October 2011
- August 2011
- June 2011
- May 2011
- April 2011
- March 2011
- December 2010
- November 2010
- October 2010
- August 2010
- July 2010
- May 2010
- April 2010
- March 2010
- February 2010
- January 2010
- December 2009
- November 2009
- October 2009
- September 2009
-
Meta
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