Oracle DBA
Nothing here yet.
Jan 16 · 1 min read · Query 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...
Join discussionDec 5, 2025 · 4 min read · Query 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...
Join discussionAug 18, 2025 · 3 min read · 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...
Join discussion