|
-
Here is what I see
The major wait is free buffer waits in the RMAN catalog database. I see it running this for a long time:
DELETE FROM ckp
WHERE dbinc_key = :b3
AND ckp_key NOT IN (:b2, :b1)
AND ckp_key NOT IN (
SELECT NVL (MAX (ckp_key), 0)
FROM ckp
WHERE dbinc_key = :b3
UNION
SELECT start_ckp_key
FROM tsatt
WHERE dbinc_key = :b3
UNION
SELECT NVL (end_ckp_key, 0)
FROM tsatt
WHERE dbinc_key = :b3
UNION
SELECT start_ckp_key
FROM dfatt
WHERE dbinc_key = :b3
UNION
SELECT NVL (end_ckp_key, 0)
FROM dfatt
WHERE dbinc_key = :b3)
In the target database I see waits on SQL Net Message from Client. I think it is waiting on the RMAN catalog.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|