By using our website, you agree to the use of our cookies.
By using our website, you agree to the use of our cookies.
CALL US
Free Oracle Consulting by E-mail
E-MAIL
dbpilot.net@gmail.com
LOCATION
Moscow
WORKING HOURS
09:00 - 21:00 MSK

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 ->…

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….

WordPress Theme built by Shufflehound. dbpilot.net by Victor Khalturin ©