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
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
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
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
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
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
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
SESSIONTIMEZONE While DBTIMEZONE is to check the database time zone, the built-in function SESSIONTIMEZONE is to check the exact time zone in the current session.… Read More »How to Check Session Time Zone
SYSTIMESTAMP To have a timestamp as of now, we can use the function SYSTIMESTAMP. SQL> select systimestamp from dual; SYSTIMESTAMP --------------------------------------------------------------------------- 09-AUG-23 04.36.54.934270 PM -04:00… Read More »Derive Timestamp from SYSTIMESTAMP