debug related sql

2022-08-09,,

 

In alert log , we can see:
-------------------------------
...
PDB2(5):Dynamic CPU count change - Current effective cpu count = 8
PDB2(5):Recovery scanning directory /oraclebase/oradata/CDB/A96C665A2DE313D5E0531236D60AAB32/datafile/ for any matching files
PDB2(5):Markfordebug : kcvadc1 : 74, 0, 5642877, 0, 0, 1
PDB2(5):Flashback recovery: Added file #74 to control file as OFFLINE and 'UNNAMED00074'
...
------------------------------



SQL>  select FENUM, FECRC_SCN, CON_ID from x$kccfe where fenum=74;

     FENUM FECRC_SCN                CON_ID
---------- -------------------- ----------
        74 5642919                       5

 

 

 

 

 

本文地址:https://blog.csdn.net/mygodhome/article/details/107153039

《debug related sql.doc》

下载本文的Word格式文档,以方便收藏与打印。