RMAN LIST BACKUP command takes a long time querying v$log_history (Doc ID 882154.1)

Last updated on OCTOBER 27, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.4 - Release: 10.2 to 10.2
Information in this document applies to any platform.
***Checked for relevance on 30-Mar-2012***

Symptoms

List commands and show commands are very slow.

10046 trace shows problem SQL statement is:

SQL>SELECT RECID , STAMP , THREAD# , SEQUENCE# , FIRST_CHANGE# LOW_SCN ,
FIRST_TIME LOW_TIME , NEXT_CHANGE# NEXT_SCN , RESETLOGS_CHANGE# ,
RESETLOGS_TIME
FROM
V$LOG_HISTORY WHERE RECID BETWEEN :1 AND :1 AND RESETLOGS_TIME IS NOT
NULL AND STAMP >= :1 ORDER BY RECID







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