Dbsnmp Query on v$rman_backup_job_details takes 100% Cpu (Doc ID 1103983.1)

Last updated on NOVEMBER 25, 2015

Applies to:

Enterprise Manager for Oracle Database - Version 10.2.0.3 to 11.1.0.1 [Release 10.2 to 11.1]
Information in this document applies to any platform.
***Checked for relevance on 18-Nov-2011***
Checked for relevance on 23-APR-2013

Symptoms

The following query for 10.2.0.5 GRID Control agent monitoring a 11.2.0.1 database consumes high CPU and can take up 2 hours to run:

/* OracleOEM */ SELECT end_time, status, session_key, V$SQLTEXT
  session_recid, session_stamp, command_id, start_time,
  time_taken_display, input_type, output_device_type,
  input_bytes_display, output_bytes_display,
  output_bytes_per_sec_display FROM (SELECT end_time, status, session_key,
  session_recid, session_stamp, command_id,
  start_time, time_taken_display, input_type,
  output_device_type, input_bytes_display,
  output_bytes_display, output_bytes_per_sec_display
  FROM v$rman_backup_job_details WHERE status NOT
  LIKE 'RUNNING%' ORDER BY NVL(end_time, start_time)
  DESC) WHERE rownum = 1

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms