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?
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 to the expired user account without knowing the original 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 much space each session consumes.
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 with SQL_ID dx4nqvbtu06bx.
- Accounts
- Auditing
- AWR
- Bash Scripts
- Datapump
- Default Category
- Demos
- Directory Objects
- Environment Variables
- Initialization Parameters
- Iptables
- Java Program
- Memory Usage
- Metadata API
- Networker
- NLS Settings
- Optimizer Statistics
- ORA-00942
- ORA-01031
- ORA-01720
- ORA-28001
- ORA-31671
- Oracle Database
- Oracle Enterprise Manager
- Performance Tunning
- Postfix
- Privilegies
- Processes
- Queries
- Red Hat Enterprise Linux
- Redo Logs
- Session Tracing
- Sessions
- SQL Trace
- SQLPlus
- Statspack
- Tablespaces
- UTL_FILE
- UTL_FILE_DIR
- Wait Events
- Yum