欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  IT编程

debug related sql

程序员文章站 2022-04-19 14:15:19
In alert log , we can see:-------------------------------...PDB2(5):Dynamic CPU count change - Current effective cpu count = 8PDB2(5):Recovery scanning directory /oraclebase/oradata/CDB/A96C665A2DE313D5E0531236D60AAB32/datafile/ for any matching fi......

 

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