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…
HOW TO AUTO-PURGE STATSPACK SNAPSHOTS
You must clear statspack snapshots regularly to keep under control the growth of a tablespace occupation allocated…
HOW TO CHECK MEMORY USAGE PER PROCESS IN LINUX
A bash script, reporting how much memory a process is using at the time.
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?