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…
g0bggfqrddc4w: PL/SQL LOCK TIMER EVENT TAKES UP THE MOST OF DBTIME
Repeating query with SQL_ID g0bggfqrddc4w in a monitored database takes up most of the database time.
CRITICAL: NUMBER OF FAILED LOGIN ATTEMPTS EXCEEDS THRESHOLD VALUE
How to trace failed login attempts.
WARNING: METRICS PROCESS LIMIT % IS AT 98
What is the query to get the process limit in the Oracle database?