适用范围 数据库-Oracle Database 19.12 操作系统-Cent OS 7.9 问题概述 Oracle 19c RAC 节点1在应用跑批时，trace目录不断增大，同时导致/u01目录使用率接近100%，影响数据库的正常使用。 问题原因 应用跑批package调用的对象不存在，SQL语句解析时产生大量trace。 解决方案 1、应用确认调用的对象，并重建不存在的对象。 2、应用重新跑批后。 分析过程 1、检查目录使用率
[oracle@XFPDB1 ~]$ df -h Filesystem Size Used Avail Use% Mounted on devtmpfs 126G 0 126G 0% /dev tmpfs s 126G 12G 114G 10% /dev/shm tmpfs 126G 4.1G 122G 4% /run tmpfs 126G 0 126G 0% /sys/fs/cgroup /dev/sdb5 188G 119G 70G 64% / /dev/sdb2 4.0G 137M 3.9G 4% /boot /dev/sdb1 4.0G 12M 4.0G 1% /boot/efi /dev/sdb3 220G 218G 2G 99% /u01 tmpfs 26G 0 26G 0% /run/user/1002 tmpfs 26G 0 26G 0% /run/user/1008 tmpfs 26G 0 26G 0% /run/user/1009 tmpfs 26G 0 26G 0% /run/user/0
检查发现/u01目录使用率已达到99%并在持续增长。 2、检查trace文件 找到最大的trace文件是xfpdb1_ora_23630.trc 查看trace内容
[oracle@XFPDB1 trace]$ more xfpdb1_ora_23630.trc Trace file /u01/app/oracle/19C/diag/rdbms/xfpdb/xfpdb1/trace/xfpdb1_ora_23630.trc Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.12.1.0.0 Build label: RDBMS_19.12.0.0.0DBRUR_LINUX.X64_211012 ORACLE_HOME: /u01/app/oracle/19.0.0 System name: Linux Node name: XFPDB1 Release: 3.10.0-1160.el7.x86_64 Version: #1 SMP Mon Oct 19 16:18:59 UTC 2020 Machine: x86_64 Instance name: xfpdb1 Redo thread mounted by this instance: 1 Oracle process number: 784 Unix process pid: 23630, image: oracle@XFPDB1 *** 2025-04-24T16:19:38.271795+08:00 *** SESSION ID:(1275.34219) 2025-04-24T16:19:38.271823+08:00 *** CLIENT ID:() 2025-04-24T16:19:38.271828+08:00 *** SERVICE NAME:(XFPDB) 2025-04-24T16:19:38.271833+08:00 *** MODULE NAME:(PL/SQL Developer) 2025-04-24T16:19:38.271838+08:00 *** ACTION NAME:(script HFXF.ETL_CNT@/XFPDB) 2025-04-24T16:19:38.271843+08:00 *** CLIENT DRIVER:() 2025-04-24T16:19:38.271848+08:00 KGI Error-3 = 9 Could not acquire mutex...Returning without dumping handle 0x39e333a08 KGI Error-3 = 9 Could not acquire mutex...Returning without dumping handle 0x39e333a08 KGI Error-3 = 9 LibraryHandle: Address=0x39e333a08 Hash=48e92e5e LockMode=N PinMode=S LoadLockMode=0 Status=VALD Subpool=1 ObjectName: Name=HFXF.PKG_XF_RS FullHashValue=d42ae7cee549c4efb90f041348e92e5e Namespace=TABLE/PROCEDURE(01) Type=PACKAGE(09) ContainerId=0 ContainerUid=0 Identifier=2667149 OwnerI dn=329 Statistics: InvalidationCount=0 ExecutionCount=0 LoadCount=1 ActiveLocks=2 TotalLockCount=3 TotalPinCount=3 Counters: BrokenCount=1 RevocablePointer=1 KeepDependency=0 Version=0 BucketInUse=0 HandleInUse=0 HandleReferenceCount=0 Concurrency: DependencyMutex=0x39e333ab8(0, 15779415, 0, 0) Mutex=0x39e333b58(1275, 15779518, 92, 6) Flags=PIN/TIM/[00002801] Flags2=[0000] WaitersLists: Lock=0x39e333a98[0x39e333a98,0x39e333a98] Pin=0x39e333a78[0x39e333a78,0x39e333a78] LoadLock=0x39e333af0[0x39e333af0,0x39e333af0] Timestamp: Current=05-15-2018 07:00:05 HandleReference: Address=0x39e333c00 Handle=0x8afd36fa0 Flags=OWN[200] LockInstance: id='LBd42ae7cee549c4ef' GlobalEnqueue=(nil) ReleaseCount=0 PinInstance: id='NBd42ae7cee549c4ef' GlobalEnqueue=(nil) ReferenceList: Reference: Address=0x1f733f930 Handle=0x1f9587a00 Flags=DEP[01] Timestamp=05-15-2018 07:00:05 InvalidatedFrom=0 LibraryObject: Address=0x76c9e5fd0 HeapMask=0000-0011-0011-0000 Flags=EXS/LOC[0004] Flags2=/CSC[4000000] Flags3=[0000] PublicFlags=NST[0001] Dependencies: count='2' size='16' table='0x76c9e6e60' Dependency: num='0' Reference=0x76c9e6288 Position=0 Flags=DEP[0001] Handle=0x8b6a89c28 Type=SYNONYM(05) Parent=HFXF.EMP Dependency: num='1' Reference=0x76c9e6320 Position=0 Flags=DEP[0001] Handle=0x8b6d0e190 Type=PACKAGE(09) Parent=SYS.STANDARD Accesses: count='1' size='16' Dependency: num='0' Type=0011 DataBlocks: Block: #='0' name=KGLH0^48e92e5e pins=0 Change=NONE Heap=0x39f836d98 Pointer=0x76c9e6110 Extent=0x76c9e5f10 Flags=I/-/P/A/-/-/- FreedLocation=0 Alloc=1.468750 Size=3.937500 LoadTime=02-12-2025 02:28:06 Block: #='4' name=PLMCD^48e92e5e pins=2 Change=NONE Heap=0x76c9e63c8 Pointer=0xccd3a67f8 Extent=0xccd3a6738 Flags=I/-/P/A/-/-/- FreedLocation=0 Alloc=1.195312 Size=3.937500 LoadTime=02-12-2025 02:28:06 KGI Error-3 = 9 LibraryHandle: Address=0x39e333a08 Hash=48e92e5e LockMode=N PinMode=S LoadLockMode=0 Status=VALD Subpool=1 ObjectName: Name=HFXF.PKG_XF_RS FullHashValue=d42ae7cee549c4efb90f041348e92e5e Namespace=TABLE/PROCEDURE(01) Type=PACKAGE(09) ContainerId=0 ContainerUid=0 Identifier=2667149 OwnerI dn=329 Statistics: InvalidationCount=0 ExecutionCount=0 LoadCount=1 ActiveLocks=2 TotalLockCount=3 TotalPinCount=3 Counters: BrokenCount=1 RevocablePointer=1 KeepDependency=0 Version=0 BucketInUse=0 HandleInUse=0 HandleReferenceCount=0 Concurrency: DependencyMutex=0x39e333ab8(0, 15779417, 0, 0) Mutex=0x39e333b58(1275, 15779520, 92, 6) Flags=PIN/TIM/[00002801] Flags2=[0000] WaitersLists: Lock=0x39e333a98[0x39e333a98,0x39e333a98] Pin=0x39e333a78[0x39e333a78,0x39e333a78] LoadLock=0x39e333af0[0x39e333af0,0x39e333af0] Timestamp: Current=05-15-2018 07:00:05 HandleReference: Address=0x39e333c00 Handle=0x8afd36fa0 Flags=OWN[200] LockInstance: id='LBd42ae7cee549c4ef' GlobalEnqueue=(nil) ReleaseCount=0 PinInstance: id='NBd42ae7cee549c4ef' GlobalEnqueue=(nil) ReferenceList: Reference: Address=0x1f733f930 Handle=0x1f9587a00 Flags=DEP[01] Timestamp=05-15-2018 07:00:05 InvalidatedFrom=0 LibraryObject: Address=0x76c9e5fd0 HeapMask=0000-0011-0011-0000 Flags=EXS/LOC[0004] Flags2=/CSC[4000000] Flags3=[0000] PublicFlags=NST[0001] Dependencies: count='2' size='16' table='0x76c9e6e60' Dependency: num='0' Reference=0x76c9e6288 Position=0 Flags=DEP[0001] Handle=0x8b6a89c28 Type=SYNONYM(05) Parent=HFXF.EMP Dependency: num='1' Reference=0x76c9e6320 Position=0 Flags=DEP[0001] Handle=0x8b6d0e190 Type=PACKAGE(09) Parent=SYS.STANDARD Accesses: count='1' size='16' Dependency: num='0' Type=0011 DataBlocks: Block: #='0' name=KGLH0^48e92e5e pins=0 Change=NONE Heap=0x39f836d98 Pointer=0x76c9e6110 Extent=0x76c9e5f10 Flags=I/-/P/A/-/-/- FreedLocation=0 Alloc=1.468750 Size=3.937500 LoadTime=02-12-2025 02:28:06 Block: #='4' name=PLMCD^48e92e5e pins=2 Change=NONE Heap=0x76c9e63c8 Pointer=0xccd3a67f8 Extent=0xccd3a6738 Flags=I/-/P/A/-/-/- FreedLocation=0 Alloc=1.195312 Size=3.937500 LoadTime=02-12-2025 02:28:06 KGI Error-3 = 9 LibraryHandle: Address=0x39e333a08 Hash=48e92e5e LockMode=N PinMode=S LoadLockMode=0 Status=VALD Subpool=1 ObjectName: Name=HFXF.PKG_XF_RS FullHashValue=d42ae7cee549c4efb90f041348e92e5e Namespace=TABLE/PROCEDURE(01) Type=PACKAGE(09) ContainerId=0 ContainerUid=0 Identifier=2667149 OwnerI dn=329 Statistics: InvalidationCount=0 ExecutionCount=0 LoadCount=1 ActiveLocks=2 TotalLockCount=3 TotalPinCount=3 Counters: BrokenCount=1 RevocablePointer=1 KeepDependency=0 Version=0 BucketInUse=0 HandleInUse=0 HandleReferenceCount=0 Concurrency: DependencyMutex=0x39e333ab8(0, 15779419, 0, 0) Mutex=0x39e333b58(1275, 15779522, 92, 6) Flags=PIN/TIM/[00002801] Flags2=[0000] WaitersLists: Lock=0x39e333a98[0x39e333a98,0x39e333a98] Pin=0x39e333a78[0x39e333a78,0x39e333a78] LoadLock=0x39e333af0[0x39e333af0,0x39e333af0] Timestamp: Current=05-15-2018 07:00:05 HandleReference: Address=0x39e333c00 Handle=0x8afd36fa0 Flags=OWN[200] LockInstance: id='LBd42ae7cee549c4ef' GlobalEnqueue=(nil) ReleaseCount=0 PinInstance: id='NBd42ae7cee549c4ef' GlobalEnqueue=(nil) ReferenceList: Reference: Address=0x1f733f930 Handle=0x1f9587a00 Flags=DEP[01] Timestamp=05-15-2018 07:00:05 InvalidatedFrom=0 LibraryObject: Address=0x76c9e5fd0 HeapMask=0000-0011-0011-0000 Flags=EXS/LOC[0004] Flags2=/CSC[4000000] Flags3=[0000] PublicFlags=NST[0001] Dependencies: count='2' size='16' table='0x76c9e6e60' Dependency: num='0' Reference=0x76c9e6288 Position=0 Flags=DEP[0001] Handle=0x8b6a89c28 Type=SYNONYM(05) Parent=HFXF.EMP Dependency: num='1' Reference=0x76c9e6320 Position=0 Flags=DEP[0001] Handle=0x8b6d0e190 Type=PACKAGE(09) Parent=SYS.STANDARD Accesses: count='1' size='16' Dependency: num='0' Type=0011 DataBlocks: Block: #='0' name=KGLH0^48e92e5e pins=0 Change=NONE Heap=0x39f836d98 Pointer=0x76c9e6110 Extent=0x76c9e5f10 Flags=I/-/P/A/-/-/- FreedLocation=0 Alloc=1.468750 Size=3.937500 LoadTime=02-12-2025 02:28:06 Block: #='4' name=PLMCD^48e92e5e pins=2 Change=NONE Heap=0x76c9e63c8 Pointer=0xccd3a67f8 Extent=0xccd3a6738 Flags=I/-/P/A/-/-/- FreedLocation=0 Alloc=1.195312 Size=3.937500 LoadTime=02-12-2025 02:28:06 KGI Error-3 = 9 LibraryHandle: Address=0x39e333a08 Hash=48e92e5e LockMode=N PinMode=S LoadLockMode=0 Status=VALD Subpool=1 ObjectName: Name=HFXF.PKG_XF_RS FullHashValue=d42ae7cee549c4efb90f041348e92e5e Namespace=TABLE/PROCEDURE(01) Type=PACKAGE(09) ContainerId=0 ContainerUid=0 Identifier=2667149 OwnerI dn=329 Statistics: InvalidationCount=0 ExecutionCount=0 LoadCount=1 ActiveLocks=2 TotalLockCount=3 TotalPinCount=3 Counters: BrokenCount=1 RevocablePointer=1 KeepDependency=0 Version=0 BucketInUse=0 HandleInUse=0 HandleReferenceCount=0 Concurrency: DependencyMutex=0x39e333ab8(0, 15779421, 0, 0) Mutex=0x39e333b58(1275, 15779524, 92, 6) Flags=PIN/TIM/[00002801] Flags2=[0000] WaitersLists: Lock=0x39e333a98[0x39e333a98,0x39e333a98] Pin=0x39e333a78[0x39e333a78,0x39e333a78] LoadLock=0x39e333af0[0x39e333af0,0x39e333af0] Timestamp: Current=05-15-2018 07:00:05 HandleReference: Address=0x39e333c00 Handle=0x8afd36fa0 Flags=OWN[200] LockInstance: id='LBd42ae7cee549c4ef' GlobalEnqueue=(nil) ReleaseCount=0 PinInstance: id='NBd42ae7cee549c4ef' GlobalEnqueue=(nil) ReferenceList: Reference: Address=0x1f733f930 Handle=0x1f9587a00 Flags=DEP[01] Timestamp=05-15-2018 07:00:05 InvalidatedFrom=0 LibraryObject: Address=0x76c9e5fd0 HeapMask=0000-0011-0011-0000 Flags=EXS/LOC[0004] Flags2=/CSC[4000000] Flags3=[0000] PublicFlags=NST[0001] Dependencies: count='2' size='16' table='0x76c9e6e60' Dependency: num='0' Reference=0x76c9e6288 Position=0 Flags=DEP[0001] Handle=0x8b6a89c28 Type=SYNONYM(05) Parent=HFXF.EMP Dependency: num='1' Reference=0x76c9e6320 Position=0 Flags=DEP[0001] Handle=0x8b6d0e190 Type=PACKAGE(09) Parent=SYS.STANDARD Accesses: count='1' size='16' Dependency: num='0' Type=0011 DataBlocks: Block: #='0' name=KGLH0^48e92e5e pins=0 Change=NONE Heap=0x39f836d98 Pointer=0x76c9e6110 Extent=0x76c9e5f10 Flags=I/-/P/A/-/-/- FreedLocation=0 Alloc=1.468750 Size=3.937500 LoadTime=02-12-2025 02:28:06 Block: #='4' name=PLMCD^48e92e5e pins=2 Change=NONE Heap=0x76c9e63c8 Pointer=0xccd3a67f8 Extent=0xccd3a6738 Flags=I/-/P/A/-/-/- FreedLocation=0 Alloc=1.195312 Size=3.937500 LoadTime=02-12-2025 02:28:06 KGI Error-3 = 9 LibraryHandle: Address=0x39e333a08 Hash=48e92e5e LockMode=N PinMode=S LoadLockMode=0 Status=VALD Subpool=1 ObjectName: Name=HFXF.PKG_XF_RS FullHashValue=d42ae7cee549c4efb90f041348e92e5e Namespace=TABLE/PROCEDURE(01) Type=PACKAGE(09) ContainerId=0 ContainerUid=0 Identifier=2667149 OwnerI dn=329 Statistics: InvalidationCount=0 ExecutionCount=0 LoadCount=1 ActiveLocks=2 TotalLockCount=3 TotalPinCount=3 Counters: BrokenCount=1 RevocablePointer=1 KeepDependency=0 Version=0 BucketInUse=0 HandleInUse=0 HandleReferenceCount=0 Concurrency: DependencyMutex=0x39e333ab8(0, 15779424, 0, 0) Mutex=0x39e333b58(1275, 15779527, 92, 6) Flags=PIN/TIM/[00002801] Flags2=[0000] WaitersLists: Lock=0x39e333a98[0x39e333a98,0x39e333a98] Pin=0x39e333a78[0x39e333a78,0x39e333a78] LoadLock=0x39e333af0[0x39e333af0,0x39e333af0] Timestamp: Current=05-15-2018 07:00:05 HandleReference: Address=0x39e333c00 Handle=0x8afd36fa0 Flags=OWN[200] LockInstance: id='LBd42ae7cee549c4ef' GlobalEnqueue=(nil) ReleaseCount=0 PinInstance: id='NBd42ae7cee549c4ef' GlobalEnqueue=(nil) ReferenceList: Reference: Address=0x1f733f930 Handle=0x1f9587a00 Flags=DEP[01] Timestamp=05-15-2018 07:00:05 InvalidatedFrom=0 LibraryObject: Address=0x76c9e5fd0 HeapMask=0000-0011-0011-0000 Flags=EXS/LOC[0004] Flags2=/CSC[4000000] Flags3=[0000] PublicFlags=NST[0001] Dependencies: count='2' size='16' table='0x76c9e6e60' Dependency: num='0' Reference=0x76c9e6288 Position=0 Flags=DEP[0001] Handle=0x8b6a89c28 Type=SYNONYM(05) Parent=HFXF.EMP Dependency: num='1' Reference=0x76c9e6320 Position=0 Flags=DEP[0001] Handle=0x8b6d0e190 Type=PACKAGE(09) Parent=SYS.STANDARD Accesses: count='1' size='16' Dependency: num='0' Type=0011 DataBlocks: Block: #='0' name=KGLH0^48e92e5e pins=0 Change=NONE Heap=0x39f836d98 Pointer=0x76c9e6110 Extent=0x76c9e5f10 Flags=I/-/P/A/-/-/- FreedLocation=0 Alloc=1.468750 Size=3.937500 LoadTime=02-12-2025 02:28:06 Block: #='4' name=PLMCD^48e92e5e pins=2 Change=NONE Heap=0x76c9e63c8 Pointer=0xccd3a67f8 Extent=0xccd3a6738 Flags=I/-/P/A/-/-/- FreedLocation=0 Alloc=1.195312 Size=3.937500 LoadTime=02-12-2025 02:28:06 KGI Error-3 = 9 Could not acquire mutex...Returning without dumping handle 0x39e333a08 KGI Error-3 = 9 LibraryHandle: Address=0x39e333a08 Hash=48e92e5e LockMode=N PinMode=S LoadLockMode=0 Status=VALD Subpool=1 ObjectName: Name=HFXF.PKG_XF_RS FullHashValue=d42ae7cee549c4efb90f041348e92e5e Namespace=TABLE/PROCEDURE(01) Type=PACKAGE(09) ContainerId=0 ContainerUid=0 Identifier=2667149 OwnerI dn=329 Statistics: InvalidationCount=0 ExecutionCount=0 LoadCount=1 ActiveLocks=2 TotalLockCount=3 TotalPinCount=3 Counters: BrokenCount=1 RevocablePointer=1 KeepDependency=0 Version=0 BucketInUse=0 HandleInUse=0 HandleReferenceCount=0 Concurrency: DependencyMutex=0x39e333ab8(0, 15779427, 0, 0) Mutex=0x39e333b58(1275, 15779530, 92, 6) Flags=PIN/TIM/[00002801] Flags2=[0000] WaitersLists: Lock=0x39e333a98[0x39e333a98,0x39e333a98] Pin=0x39e333a78[0x39e333a78,0x39e333a78] LoadLock=0x39e333af0[0x39e333af0,0x39e333af0] Timestamp: Current=05-15-2018 07:00:05 HandleReference: Address=0x39e333c00 Handle=0x8afd36fa0 Flags=OWN[200] LockInstance: id='LBd42ae7cee549c4ef' GlobalEnqueue=(nil) ReleaseCount=0 PinInstance: id='NBd42ae7cee549c4ef' GlobalEnqueue=(nil) ReferenceList: Reference: Address=0x1f733f930 Handle=0x1f9587a00 Flags=DEP[01] Timestamp=05-15-2018 07:00:05 InvalidatedFrom=0 LibraryObject: Address=0x76c9e5fd0 HeapMask=0000-0011-0011-0000 Flags=EXS/LOC[0004] Flags2=/CSC[4000000] Flags3=[0000] PublicFlags=NST[0001] Dependencies: count='2' size='16' table='0x76c9e6e60' Dependency: num='0' Reference=0x76c9e6288 Position=0 Flags=DEP[0001] Handle=0x8b6a89c28 Type=SYNONYM(05) Parent=HFXF.EMP Dependency: num='1' Reference=0x76c9e6320 Position=0 Flags=DEP[0001] Handle=0x8b6d0e190 Type=PACKAGE(09) Parent=SYS.STANDARD Accesses: count='1' size='16' Dependency: num='0' Type=0011 DataBlocks: Block: #='0' name=KGLH0^48e92e5e pins=0 Change=NONE Heap=0x39f836d98 Pointer=0x76c9e6110 Extent=0x76c9e5f10 Flags=I/-/P/A/-/-/- FreedLocation=0 Alloc=1.468750 Size=3.937500 LoadTime=02-12-2025 02:28:06 Block: #='4' name=PLMCD^48e92e5e pins=2 Change=NONE Heap=0x76c9e63c8 Pointer=0xccd3a67f8 Extent=0xccd3a6738 Flags=I/-/P/A/-/-/- FreedLocation=0 Alloc=1.195312 Size=3.937500 LoadTime=02-12-2025 02:28:06 KGI Error-3 = 9 Could not acquire mutex...Returning without dumping handle 0x39e333a08 KGI Error-3 = 9 LibraryHandle: Address=0x39e333a08 Hash=48e92e5e LockMode=N PinMode=S LoadLockMode=0 Status=VALD Subpool=1 ObjectName: Name=HFXF.PKG_XF_RS FullHashValue=d42ae7cee549c4efb90f041348e92e5e Namespace=TABLE/PROCEDURE(01) Type=PACKAGE(09) ContainerId=0 ContainerUid=0 Identifier=2667149 OwnerI dn=329 Statistics: InvalidationCount=0 ExecutionCount=0 LoadCount=1 ActiveLocks=2 TotalLockCount=3 TotalPinCount=3 Counters: BrokenCount=1 RevocablePointer=1 KeepDependency=0 Version=0 BucketInUse=0 HandleInUse=0 HandleReferenceCount=0 Concurrency: DependencyMutex=0x39e333ab8(0, 15779431, 0, 0) Mutex=0x39e333b58(1275, 15779534, 92, 6) Flags=PIN/TIM/[00002801] Flags2=[0000] WaitersLists: Lock=0x39e333a98[0x39e333a98,0x39e333a98] Pin=0x39e333a78[0x39e333a78,0x39e333a78] LoadLock=0x39e333af0[0x39e333af0,0x39e333af0] Timestamp: Current=05-15-2018 07:00:05 HandleReference: Address=0x39e333c00 Handle=0x8afd36fa0 Flags=OWN[200] LockInstance: id='LBd42ae7cee549c4ef' GlobalEnqueue=(nil) ReleaseCount=0 PinInstance: id='NBd42ae7cee549c4ef' GlobalEnqueue=(nil) ReferenceList: Reference: Address=0x1f733f930 Handle=0x1f9587a00 Flags=DEP[01] Timestamp=05-15-2018 07:00:05 InvalidatedFrom=0 LibraryObject: Address=0x76c9e5fd0 HeapMask=0000-0011-0011-0000 Flags=EXS/LOC[0004] Flags2=/CSC[4000000] Flags3=[0000] PublicFlags=NST[0001] Dependencies: count='2' size='16' table='0x76c9e6e60' Dependency: num='0' Reference=0x76c9e6288 Position=0 Flags=DEP[0001] Handle=0x8b6a89c28 Type=SYNONYM(05) Parent=HFXF.EMP Dependency: num='1' Reference=0x76c9e6320 Position=0 Flags=DEP[0001] Handle=0x8b6d0e190 Type=PACKAGE(09) Parent=SYS.STANDARD Accesses: count='1' size='16' Dependency: num='0' Type=0011 DataBlocks: Block: #='0' name=KGLH0^48e92e5e pins=0 Change=NONE Heap=0x39f836d98 Pointer=0x76c9e6110 Extent=0x76c9e5f10 Flags=I/-/P/A/-/-/- FreedLocation=0 Alloc=1.468750 Size=3.937500 LoadTime=02-12-2025 02:28:06 Block: #='4' name=PLMCD^48e92e5e pins=2 Change=NONE Heap=0x76c9e63c8 Pointer=0xccd3a67f8 Extent=0xccd3a6738 Flags=I/-/P/A/-/-/- FreedLocation=0 Alloc=1.195312 Size=3.937500 LoadTime=02-12-2025 02:28:06 KGI Error-3 = 9 Could not acquire mutex...Returning without dumping handle 0x39e333a08 KGI Error-3 = 9 Could not acquire mutex...Returning without dumping handle 0x39e333a08 KGI Error-3 = 9 Could not acquire mutex...Returning without dumping handle 0x39e333a08 KGI Error-3 = 9 LibraryHandle: Address=0x39e333a08 Hash=48e92e5e LockMode=N PinMode=S LoadLockMode=0 Status=VALD Subpool=1 ObjectName: Name=HFXF.PKG_XF_RS FullHashValue=d42ae7cee549c4efb90f041348e92e5e Namespace=TABLE/PROCEDURE(01) Type=PACKAGE(09) ContainerId=0 ContainerUid=0 Identifier=2667149 OwnerI dn=329 Statistics: InvalidationCount=0 ExecutionCount=0 LoadCount=1 ActiveLocks=2 TotalLockCount=3 TotalPinCount=3 Counters: BrokenCount=1 RevocablePointer=1 KeepDependency=0 Version=0 BucketInUse=0 HandleInUse=0 HandleReferenceCount=0 Concurrency: DependencyMutex=0x39e333ab8(0, 15779436, 0, 0) Mutex=0x39e333b58(1275, 15779539, 92, 6) Flags=PIN/TIM/[00002801] Flags2=[0000] WaitersLists: Lock=0x39e333a98[0x39e333a98,0x39e333a98] Pin=0x39e333a78[0x39e333a78,0x39e333a78] LoadLock=0x39e333af0[0x39e333af0,0x39e333af0] Timestamp: Current=05-15-2018 07:00:05 HandleReference: Address=0x39e333c00 Handle=0x8afd36fa0 Flags=OWN[200] LockInstance: id='LBd42ae7cee549c4ef' GlobalEnqueue=(nil) ReleaseCount=0 PinInstance: id='NBd42ae7cee549c4ef' GlobalEnqueue=(nil) ReferenceList: Reference: Address=0x1f733f930 Handle=0x1f9587a00 Flags=DEP[01] Timestamp=05-15-2018 07:00:05 InvalidatedFrom=0 LibraryObject: Address=0x76c9e5fd0 HeapMask=0000-0011-0011-0000 Flags=EXS/LOC[0004] Flags2=/CSC[4000000] Flags3=[0000] PublicFlags=NST[0001] Dependencies: count='2' size='16' table='0x76c9e6e60' Dependency: num='0' Reference=0x76c9e6288 Position=0 Flags=DEP[0001] Handle=0x8b6a89c28 Type=SYNONYM(05) Parent=HFXF.EMP Dependency: num='1' Reference=0x76c9e6320 Position=0 Flags=DEP[0001] Handle=0x8b6d0e190 Type=PACKAGE(09) Parent=SYS.STANDARD Accesses: count='1' size='16' Dependency: num='0' Type=0011 DataBlocks: Block: #='0' name=KGLH0^48e92e5e pins=0 Change=NONE Heap=0x39f836d98 Pointer=0x76c9e6110 Extent=0x76c9e5f10 Flags=I/-/P/A/-/-/- FreedLocation=0 Alloc=1.468750 Size=3.937500 LoadTime=02-12-2025 02:28:06 Block: #='4' name=PLMCD^48e92e5e pins=2 Change=NONE Heap=0x76c9e63c8 Pointer=0xccd3a67f8 Extent=0xccd3a6738 Flags=I/-/P/A/-/-/- FreedLocation=0 Alloc=1.195312 Size=3.937500 LoadTime=02-12-2025 02:28:06 KGI Error-3 = 9 LibraryHandle: Address=0x39e333a08 Hash=48e92e5e LockMode=N PinMode=S LoadLockMode=0 Status=VALD Subpool=1 ObjectName: Name=HFXF.PKG_XF_RS FullHashValue=d42ae7cee549c4efb90f041348e92e5e Namespace=TABLE/PROCEDURE(01) Type=PACKAGE(09) ContainerId=0 ContainerUid=0 Identifier=2667149 OwnerI dn=329 Statistics: InvalidationCount=0 ExecutionCount=0 LoadCount=1 ActiveLocks=2 TotalLockCount=3 TotalPinCount=3 Counters: BrokenCount=1 RevocablePointer=1 KeepDependency=0 Version=0 BucketInUse=0 HandleInUse=0 HandleReferenceCount=0 Concurrency: DependencyMutex=0x39e333ab8(0, 15779438, 0, 0) Mutex=0x39e333b58(1275, 15779541, 92, 6) Flags=PIN/TIM/[00002801] Flags2=[0000] WaitersLists: Lock=0x39e333a98[0x39e333a98,0x39e333a98] Pin=0x39e333a78[0x39e333a78,0x39e333a78] LoadLock=0x39e333af0[0x39e333af0,0x39e333af0] Timestamp: Current=05-15-2018 07:00:05 HandleReference: Address=0x39e333c00 Handle=0x8afd36fa0 Flags=OWN[200] LockInstance: id='LBd42ae7cee549c4ef' GlobalEnqueue=(nil) ReleaseCount=0 PinInstance: id='NBd42ae7cee549c4ef' GlobalEnqueue=(nil) ReferenceList: Reference: Address=0x1f733f930 Handle=0x1f9587a00 Flags=DEP[01] Timestamp=05-15-2018 07:00:05 InvalidatedFrom=0 LibraryObject: Address=0x76c9e5fd0 HeapMask=0000-0011-0011-0000 Flags=EXS/LOC[0004] Flags2=/CSC[4000000] Flags3=[0000] PublicFlags=NST[0001] Dependencies: count='2' size='16' table='0x76c9e6e60' Dependency: num='0' Reference=0x76c9e6288 Position=0 Flags=DEP[0001] Handle=0x8b6a89c28 Type=SYNONYM(05) Parent=HFXF.EMP Dependency: num='1' Reference=0x76c9e6320 Position=0 Flags=DEP[0001] Handle=0x8b6d0e190 Type=PACKAGE(09) Parent=SYS.STANDARD Accesses: count='1' size='16' Dependency: num='0' Type=0011 DataBlocks:
从trace中可以看到报错信息，KGI Error-3 = 9 Could not acquire mutex…Returning without dumping handle 0x39e333a08，handle 0x39e333a08是调用package HFXF.PKG_XF_RS 。 3、检查数据库对象
SQL>select object_name,owner,object_type,status from dba_objects where object_name='PKG_XF_RS'; OBJECT_NAME OWNER OBJECT_TYPE STATUS ------------------------------------------------------- PKG_XF_RS HFXF PACKAGE VALID SQL>select object_name,owner,object_type,status from dba_objects where object_name='F_GET_DATE'; no rows selected
HFXF用户下PACKAGE-PKG_XF_RS状态正常，PKG_XF_RS中调用的函数F_GET_DATE不存在。
![欢迎加入[数据库技术交流群]，一起打怪升级！](https://www.herecours.com/d/file/efpub/2026/03-03/20260303181143854475.jpg "欢迎加入[数据库技术交流群]，一起打怪升级！")
