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?
WHO IS LOCKING MY ORACLE ACCOUNT?
Why an Oracle user is locked? Who is locking an Oracle user?
HOW TO RESET AN ORACLE ACCOUNT PASSWORD
How can I change a password for a user in Oracle? How to set the same password…
HOW TO FIND WHO AND WHAT SQL IS USING TEMP TABLESPACE?
A query to know which sessions are currently using temporary space in the Oracle Database, and how…
dx4nqvbtu06bx: THE RECURRING QUERY IN THE 11.2.0.4 TARGET DATABASE IS EXTREMELY SLOW AND USES LOTS OF TEMPORARY SPACE
ORA-1652 error is continuously reported in the alert log file. The error is caused by the query…