HOW TO RESCHEDULE THE AUTOMATIC OPTIMIZER STATISTICS COLLECTION JOB
The post provides a number of steps to follow to run the Automatic Optimizer Statistics Collection Job with another time schedule.
HOW TO KNOW WHETHER THE DATABASE COLLECTS STATISTICS REGULARLY
The post provides a number of steps to follow to find out if statistics are collected on a regular basis in the Oracle database.
USER WITH "SELECT ANY TABLE" PRIVILEGE GETS "ORA-00942: TABLE OR VIEW DOES NOT EXIST"
A user with SELECT ANY TABLE privilege gets ORA-00942: TABLE OR VIEW DOES NOT EXIST when quering any table.
HOW TO FIND ALL SESSIONS HOLDING A TABLE LOCK
Query to check table lock in Oracle database.
ORA-02049: TIMEOUT: DISTRIBUTED TRANSACTION WAITING FOR LOCK
oerr ora 02049 - The number of seconds specified in the distributed_lock_timeout initialization parameter were exceeded while waiting for a lock or for a begin transaction hash collision to end.
HOW TO AUTO-PURGE STATSPACK SNAPSHOTS
You must clear statspack snapshots regularly to keep under control the growth of a tablespace occupation allocated for storing statspack data.
GENERATING MULTIPLE STATSPACK REPORTS QUICKLY
A bash script for generating multiple STATSPACK reports.
GENERATING MULTIPLE AWR REPORTS QUICKLY
A bash script for generating multiple AWR reports.
HOW TO MATCH OS PROCESS WITH ORACLE SESSION
What is a particular OS Oracle process (PID) executing in an Oracle database?
WHAT IS DEAD CONNECTION DETECTION (DCD) IN THE ORACLE DATABASE
How to clean up all abnormally terminated sessions between client and database server?