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.