Mastering the Oracle Stack, One Post at a Time.
Oracle Database, the related services (cloud) and various options in the database.
This blog identifies the DBA steps required to migrate databases from one disk array to another. Identify the ASM diskgroups and their disk (LUN) sizes Login to the ASM instance and identify the LUNs allocated to server. SQL> SET PAGES 999 SQL> col name format a15 For 11g ASM: SQL> select d.group_number, g.name, d.os_mb from … Read more
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