WHAT IS DEAD CONNECTION DETECTION (DCD) IN THE ORACLE DATABASE
How to clean up all abnormally terminated sessions between client and database server?
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 much space each session consumes.
dx4nqvbtu06bx: THE RECURRING QUERY IN THE 184.108.40.206 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 with SQL_ID dx4nqvbtu06bx.
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.
- Bash Scripts
- Default Category
- Directory Objects
- Environment Variables
- Initialization Parameters
- Memory Usage
- Metadata API
- NLS Settings
- Optimizer Statistics
- Oracle Database
- Oracle Enterprise Manager
- Performance Tunning
- Red Hat Enterprise Linux
- Redo Logs
- Wait Events