ORA-02049: TIMEOUT: DISTRIBUTED TRANSACTION WAITING FOR LOCK
SYMPTOMS An application reports about multiple errors ORA-02049: timeout: distributed transaction waiting for lock in the application’s log file. RELATED A BLOCKING SESSION ORA-00060: DEADLOCK DETECTED WHILE WAITING FOR RESOURCE DIAGNOSE The error occurs when a session is trying to…
HOW TO TERMINATE ALL IDLE SESSIONS/PROCESSES IN AN ORACLE DATABASE AUTOMATICALLY
REQUEST There are lots of idle sessions/processes in my database. All inactive(Idle) sessions must be disconnected automatically after 8 hours since they have become inactive(idle). DETAILS The following statement shows idle time for all inactive sessions in a database SET LINES 300…
WHY MY DATABASE HAS SO MANY PROCESSES CONNECTED
REQUEST An instance has reached the maximum number of processes. I want to know why I have so many and if there is any to be disconnected safely. DETAILS The following query shows that my instance has almost reached the number of permited…
EM Event: Warning:ORCL_dbpilot.net – Metrics Process Limit % is at 98
SYMPTOMS Oracle Enterprise Manager Cloud Control 13c Release 3 (13.3.0.0.0) sends you emails like the EM Event: Warning:ORCL_dbpilot.net – Metrics Process Limit % is at 98 with the following error messages Host=dbpilot.net Target type=Database Instance Target name=ORCL_dbpilot.net Categories=Capacity Message=Metrics Process Limit % is at…
Search
Certificates
Social Link(s)
Categories
- Linux (8)
- Iptables (2)
- Memory Usage (1)
- Postfix (1)
- Yum (4)
- Networker (2)
- Oracle (61)
- Account (2)
- AWR (2)
- Database Errors (5)
- Database Performance (9)
- Datapump (3)
- Enterprise Manager (24)
- Enterprise Manager Metrics (4)
- Environments (4)
- High CPU Usage (2)
- High IO Load (4)
- Initialization Parameters (4)
- Processes (3)
- NLS (1)
- Objects (1)
- Objects DDL (2)
- PL/SQL (5)
- UTL_FILE (4)
- Prerequisites (1)
- Profile (1)
- Queries (2)
- Redologs (1)
- Resource Limits (1)
- Segment Shrink (1)
- Session (6)
- Spfile (3)
- SQL PLUS (1)
- Spooling (1)
- Standard Queries (7)
- Statistics (2)
- Temporary Tablespace (2)