select sysdate,b.name useg, b.inst# instid, b.status$ status, a.ktuxeusn
xid_usn, a.ktuxeslt xid_slot, a.ktuxesqn xid_seq, a.ktuxesiz undoblocks
from x$ktuxe a, undo$ b
where a.ktuxesta = 'ACTIVE' and a.ktuxecfl like '%DEAD%'
and a.ktuxeusn = b.us#;
Testing DB_FLASHBACK_LOG_DEST in 23ai
-
Pre-23ai, Database Flashback Logs always were created in the
DB_RECOVERY_FILE_DEST location (i.e.. the well-known "Fast Recovery Area"
also known as "FR...
Acum 2 zile
Niciun comentariu:
Trimiteți un comentariu