ENTERPRISE MANAGER QUERIES ARE IN TOP AS ELAPSED TIME QUERIES CAUSE OF AUDIT RECORDS
SYMPTOMS The Enterprise Manager Queries are the first CPU/TIME consuming queries in the order by Elapsed time section of a statspack report. For instance ————————————————————- ^LSQL ordered by Elapsed time for DB: MERIDB2 Instance: meridb2 Snaps: 27081 -27 -> Total DB Time (s): 6,849 ->…
HOW TO AUTO-PURGE STATSPACK SNAPSHOTS
GOAL This note shows a way to purge statspack data automatically that is older than a specified number of days SOLUTION To purge unnecessary statspack data use the STATSPACK.PURGE procedure. The procedure has the parameter that accepts the number of days…
GENERATING MULTIPLE AWR REPORTS IN ONE STEP
REQUEST I want to generate AWR reports for all available SNAP ID. SOLUTION This post contains a dbs_gawrr.sh script designed to generate multiple Automatic Workload Repository (AWR) reports automatically based on snapshots ranges. If you need AWR reports, for instance, for 2 weeks,…
Categories
- Linux (8)
- Iptables (2)
- Memory Usage (1)
- Postfix (1)
- Yum (4)
- Networker (2)
- Oracle (69)
- Account (2)
- AWR (4)
- Database Errors (6)
- Database Performance (10)
- Datapump (4)
- 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 (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)
- Tablespaces (1)
- Temporary Tablespace (2)