How to Disable All Scheduler Jobs
In the previous post, we introduce a way to disable AUTOTASK jobs to prevent them from impacting other running processes. However, AUTOTASK jobs are only… Read More »How to Disable All Scheduler Jobs
Administration
JOB_QUEUE_PROCESSES, How and Why
JOB_QUEUE_PROCESSES is an initialization parameter which controls the maximum number of processes of scheduler jobs in an instance. In this post, we'll talk about the… Read More »JOB_QUEUE_PROCESSES, How and Why
How to Speed Up CLEAN_AUDIT_TRAIL
CLEAN_AUDIT_TRAIL Runs Slowly ? If you have never purged the unified audit trails in your database, the first time deletion by CLEAN_AUDIT_TRAIL may take a… Read More »How to Speed Up CLEAN_AUDIT_TRAIL
How to Purge Unified Audit Trail in Oracle
Tablespace SYSAUX Since tablespace SYSAUX has grown too big, so we query V$SYSAUX_OCCUPANTS to check the usage of AUDSYS in SYSAUX like this: SQL> show… Read More »How to Purge Unified Audit Trail in Oracle
How to Check LAST_ARCHIVE_TIME
Before you purge some unified audit trails, you may like to know what the current value of LAST_ARCHIVE_TIME has been set by SET_LAST_ARCHIVE_TIMESTAMP. Theoretically, we… Read More »How to Check LAST_ARCHIVE_TIME
How to Add User to OSDBA Group
OSDBA Group In the previous post, we have talked about how to enable an user other than administrator (Windows) or oracle (Linux) to use SQL*Plus… Read More »How to Add User to OSDBA Group
How to Check Group of OSDBA
OSDBA or OSOPER OSDBA and OSOPER are just a symbol name defined by Oracle database, users belonged to either group are natively granted to use… Read More »How to Check Group of OSDBA
How to Change Session Time Zone
TIME_ZONE In the previous post, we have checked the time zone in the current session. Now the question is, how to change it? if it… Read More »How to Change Session Time Zone
DATABASE_PROPERTIES, How and Why
DATABASE_PROPERTIES DATABASE_PROPERTIES is a data dictionary view which is able to describe the nature of a database by collecting its permanent properties Let's see standard… Read More »DATABASE_PROPERTIES, How and Why
How to Resolve ORA-48140: the specified ADR Base directory does not exist
ORA-48108 ORA-48140 ORA-48187 OSD-00002 Tried to startup a database on Windows, but it failed with several errors like ORA-48140. SQL> startup nomount; ORA-48108: invalid value… Read More »How to Resolve ORA-48140: the specified ADR Base directory does not exist