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 high IO in the monitored…
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 if it can be cleared…
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…
Categories
- Linux (8)
- Iptables (2)
- Memory Usage (1)
- Postfix (1)
- Yum (4)
- Networker (2)
- Oracle (71)
- Account (3)
- 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 (2)
- 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)