Oracle datafile 数目限制是多少
DBMS_PDB.DESCRIBE with large number of datafiile say 37183 datafiles hit ORA-600 [kpdbPrepareXMLFromCtrlFile:tsindx] (Doc ID 2781789.1)
3万多都没问题
Applies to:
Oracle Database - Enterprise Edition - Version 18.13.0.0.0 and later
Information in this document applies to any platform.
Symptoms
Generating PDB XML file , DBMS_PDB.DESCRIBE with large number of datafiles, in this case 37183 datafiles hit ORA-600 [kpdbPrepareXMLFromCtrlFile:tsindx]
Changes
Initially was hitting ORA-4030 for same operation and after applying fix for unpublished bug 32195815 now the error changed to the following.
ORA-600 [kpdbPrepareXMLFromCtrlFile:tsindx], [65609], [65608]
Cause
The cause of this issue is due to the following unpublished bug:
Bug 32872839 - DBMS_PDB.DESCRIBE 37183 DATAFILES HIT ORA-600 [KPDBPREPAREXMLFROMCTRLFILE:TSINDX
Please also reference the following:
Document 32872839.8 - Bug 32872839 - DBMS_PDB.DESCRIBE() Command May Fail With ORA-600: [kpdbPrepareXMLFromCtrlFile:tsindx]
Solution
Please apply patch 32872839 if available for your platform and database version. If no patch is available please open an SR with support to request one.