query v$rman_backup_job_details - slow and shows MERGE JOIN CARTESIAN
Oracle DB: 10.2.0.4RAC: 5 nodes
OS: Linux 5.5
When I query v$rman_backup_job_details table - slow and shows MERGE JOIN CARTESIAN
user sysman is running the following query that taking forever... the xplan plan shows many MERGE JOIN CARTESIAN. Since we cannot change the query or stats, how could I fix it?
****** Query
SELECT end_time, status
FROM v$rman_backup_job_details
WHERE end_time = (SELECT MAX (end_time) FROM v$rman_backup_job_details)
***************Plan
SELECT STATEMENT ALL_ROWSCost: 37
109 VIEW Cost: 19 Bytes: 49,632 Cardinality: 2,256
54 HASH UNIQUE Cost: 19 Bytes: 270,720 Cardinality: 2,256
53 VIEW Cost: 18 Bytes: 270,720 Cardinality: 2,256
52 WINDOW SORT Cost: 18 Bytes: 329,376 Cardinality: 2,256
OS: Linux 5.5
When I query v$rman_backup_job_details table - slow and shows MERGE JOIN CARTESIAN
user sysman is running the following query that taking forever... the xplan plan shows many MERGE JOIN CARTESIAN. Since we cannot change the query or stats, how could I fix it?
****** Query
SELECT end_time, status
FROM v$rman_backup_job_details
WHERE end_time = (SELECT MAX (end_time) FROM v$rman_backup_job_details)
***************Plan
SELECT STATEMENT ALL_ROWSCost: 37
109 VIEW Cost: 19 Bytes: 49,632 Cardinality: 2,256
54 HASH UNIQUE Cost: 19 Bytes: 270,720 Cardinality: 2,256
53 VIEW Cost: 18 Bytes: 270,720 Cardinality: 2,256
52 WINDOW SORT Cost: 18 Bytes: 329,376 Cardinality: 2,256
0