STANDARD QUERY g0bggfqrddc4w CAUSES THE PL/SQL lock timer EVENT TO CONSUME MOST PART OF DBTIME
SYMPTOMS In an AWR report or a Statspack report, the PL/SQL lock timer wait event is in the Top Wait Events list. The Wait Event is consuming a large part of the database time. The average wait time of the wait event is about 60 seconds (60000 ms). A…
HOW TO TERMINATE ALL IDLE SESSIONS/PROCESSES IN AN ORACLE DATABASE AUTOMATICALLY
GOAL 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). SYMPTOMS The following statement shows IDLE time for all INACTIVE sessions in a database SET LINES 300 SET PAGES 999 COL DATABASE_USER FOR A20 COL…
ENABLING DEAD CONNECTION DETECTION(DCD) IN AN ORACLE DATABASE
GOAL All abnormally terminated sessions between a database server and a client must be disconnected automatically SOLUTION Dead Connection Detection (DCD) is intended primarily for environments in which clients power down their systems or client machines crash unexpectedly without disconnecting from Oracle Database sessions. This feature is configured on…
WHY MY DATABASE HAS SO MANY PROCESSES CONNECTED
GOAL 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. SYMPTOMS The following query shows that my instance has almost reached the number of permited processes. SET LINES 300 SET PAGES 999…
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 98 Severity=Warning Event reported time=Aug…
ORA-31671: Worker process DW00 had an unhandled exception.
ISSUE During a datapump import you got the error like the following impdp system/password schemas=XXCDB NETWORK_LINK=PROD_SYSTEM DIRECTORY=DROPZONE LOGFILE=your_logfile.log … Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS ORA-39014: One or more workers have prematurely exited. ORA-39029: worker 1 with process name “DW00” prematurely terminated ORA-31671: Worker process DW00 had an unhandled exception. ORA-04030:…
STANDARD EM QUERY WITH SQL_ID dx4nqvbtu06bx IS VERY SLOW AND USES LOTS OF TEMPORARY SPACE
ISSUE The standard recurring query of the Enterprise Manager Cloud Control 13c Release 3 with sql_id dx4nqvbtu06bx is running slow and using huge amount of temporary tablespace while executing in a databases of the release 11.2.0.4. The query dx4nqvbtu06bx is executed every 15-20 minutes. The body of the query…
EM Event: Critical:oradb – Number of failed login attempts exceeds threshold value.
ISSUE Just got the “Number of failed login attempts exceeds threshold value” error from the Enterprise Manager Cloud Control 13c? And you aren’t sure what should you do? Bellow the solution using audit option. SYMPTOMS You received the following alert message from the Enterprise Manager Cloud Control 13c…
HOW TO REPORT MEMORY USAGE PER A PROCESS ON LINUX
The post provides a bash script that gathers and summarize memory usage by every process on Red Hat system
HOW TO FIND WHO AND WHAT SQL IS USING TEMP TABLESPACE?
REQUEST I need details about what exactly is using the space in a Temporary Tablespace. SOLUTION With the TEMP_USAGE view you can point out which a user, a session or a sql_id is currently using your temp space. CREATE OR REPLACE VIEW TEMP_USAGE AS ———————————————————— –…
Categories
- Linux (8)
- Iptables (2)
- Memory Usage (1)
- Postfix (1)
- Yum (4)
- Networker (2)
- Oracle (70)
- Account (2)
- AWR (4)
- Database Errors (7)
- Database Performance (10)
- Datapump (4)
- DBMS_SCHEDULER (2)
- Enterprise Manager (25)
- Enterprise Manager Metrics (4)
- Environments (4)
- High CPU Usage (3)
- High IO Load (4)
- Historical Session Information (3)
- Initialization Parameters (5)
- job_queue_processes (1)
- Processes (3)
- NLS SETTINGS (1)
- Objects (1)
- Objects DDL (2)
- OJVM/PSU/DRU Patches (1)
- Optimizer Statistics Advisor (1)
- PL/SQL (5)
- UTL_FILE (4)
- Prerequisites (1)
- Privileges (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 (3)
- Tablespaces (2)
- Temporary Tablespace (2)