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.

原文地址：https://blog.csdn.net/jnrjian/article/details/142694517

免责声明：本站文章内容转载自网络资源，如本站内容侵犯了原著者的合法权益，可联系本站删除。更多内容请关注自学内容网（zxcms.com）！