THE FAILED LOGINS AND THE FAILED LOGINS (HISTORICAL) METRICS ARE EXTREMELY SLOW RESULTING IN HIGH IO AND CPU CONSUMPTION
SYMPTOMS The Oracle Enterprise Manager Cloud Control 13c Release 3 and The Oracle Management Agent 13c release 3 are used to monitor the Oracle database 12.1.0.1.0. Both The Failed Logins and Failed Logins (Historical) Metric are enabled and execute on a regular base. The…
HOW TO TURN OFF ORACLE 12C UNIFIED AUDITING AND CLEAN UP ALL UNIFIED AUDITING RECORDS
12c AUDITING Since the Oracle Database 12c Release 12.1.0.1.0 the Oracle invented a new approach of auditing – The Unified Auditing The Unified Auditing can operate in one of 2 available auditing modes – the Mixed Mode Auditing and the Pure Unified…
THE FAILED LOGINS METRIC QUERY IS VERY SLOW BECAUSE OF AUD$ TABLE SIZE
SYMPTOMS The Oracle Enterprise Manage Cloud Control 13c is used to monitor the Oracle database. The Failed Logins Metric is enabled and by default executed every 30 minutes. The related metric queries with SQL_ID 83jcj6at6ugq3 (12c) and 1c74605ddbvjt (11gR2) are very slow and causes…
THE AUD$ TABLE IS VERY LARGE
SYMPTOMS You noticed that your SYSTEM tablespace is too big in size. By reviewing the DBA_SEGMENTS view you found out that the most part of the SYSTEM tablespace is occupied by the AUD$ segment. You are wondering now what is the segment for and…
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…
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…
ENABLING DEAD CONNECTION DETECTION(DCD) IN AN ORACLE DATABASE
REQUEST All abnormally terminated sessions between a database server and a client must be disconnected automatically SOLUTION DCD is intended primarily for environments in which clients power down their systems or client machines crash unexpectedly without disconnecting from Oracle Database sessions….
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…
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….
Categories
- Linux (8)
- Iptables (2)
- Memory Usage (1)
- Postfix (1)
- Yum (4)
- Networker (2)
- Oracle (63)
- Account (2)
- AWR (2)
- Database Errors (6)
- Database Performance (9)
- Datapump (3)
- Enterprise Manager (24)
- Enterprise Manager Metrics (4)
- Environments (4)
- High CPU Usage (2)
- High IO Load (4)
- Initialization Parameters (5)
- job_queue_processes (1)
- Processes (3)
- NLS (1)
- Objects (1)
- Objects DDL (2)
- OJVM/PSU/DRU Patches (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 (2)
- Temporary Tablespace (2)