PMPrasenjit Mahatoinoracledbafindings.hashnode.dev·Jan 16 · 1 min readOEM : migrate monitoring templatesQuery to find the monitoring templates currently used on old server SELECT TEMPLATE_NAME,TARGET_TYPE FROM SYSMAN.MGMT_TEMPLATES; Old Server : OEM 13.5.0.24 [oracle@oldserver1 ~]$ $OMS_HOME/bin/emcli login -username=sysman Enter password Login succe...00
PMPrasenjit Mahatoinoracledbafindings.hashnode.dev·Dec 5, 2025 · 4 min readAutomatic maintenance tasks controls the automatic optimizer statisticsQuery to check the current state of jobs in CDB_AUTOTASK_CLIENT of the database, auto optimizer stats collection job is disabled in PDBs. SELECT COALESCE(p.name, (SELECT name FROM v$database)) AS DATABASE, CASE WHEN c.con_id = 1 THE...00
PMPrasenjit Mahatoinoracledbafindings.hashnode.dev·Aug 18, 2025 · 3 min readDatapump - Exclude table AUD$There was a requirement to exclude the AUD$ table of the SYS schema from the export dump.The AUD$ table is already being collected daily in a separate database and retained for three years for reporting purposes. Excluding it from the export avoids r...00