SYSAUX Tablespace Growth – Review and Fix

by

Received an alert from one of the databases that SYSAUX tablespace is nearing its allocated 24GB space. 24GB is too much for SYSAUX, especially on a development database… so need to make sure the contents are reviewed before adding more space… Oracle10g+ versions have a view V$SYSAUX_OCCUPANTS, showing what components are in SYSAUX tablespace and … Read more

Time Flies!

by

Just thought that I have not updated the blog for sometime, but did not realize it is almost 10 months since the last update… Time really flies… Oracle Openworld is here, though this is my sixth or seventh OOW at SFO, 2012 is the first OOW where I am part of the event outside of participation… Will … Read more