Trace file /home/oracle/admin/diag/rdbms/prod18/prod18/trace/prod18_ora_21939.trc Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options ORACLE_HOME = /home/oracle/product/112 System name: Linux Node name: fourcore Release: 2.6.18-164.el5PAE Version: #1 SMP Thu Sep 3 02:28:20 EDT 2009 Machine: i686 Instance name: prod18 Redo thread mounted by this instance: 1 Oracle process number: 21 Unix process pid: 21939, image: oracle@fourcore (TNS V1-V3) *** 2011-01-19 09:17:49.816 *** SESSION ID:(1510.17) 2011-01-19 09:17:49.816 *** CLIENT ID:() 2011-01-19 09:17:49.816 *** SERVICE NAME:(SYS$USERS) 2011-01-19 09:17:49.816 *** MODULE NAME:(SQL*Plus) 2011-01-19 09:17:49.816 *** ACTION NAME:() 2011-01-19 09:17:49.816 Library Cache Dump SGA:386ea5b8 Flags=2c7 DebugContext: DebugNameSpace=0 DebugType=0 DebugLevel=0x0 LIBRARY CACHE HASH TABLE: size=131072 count=4168 Buckets with more than 20 objects: NONE Hash Chain Size Number of Buckets --------------- ----------------- 0 126965 1 4047 2 59 3 1 4 0 5 0 6 0 7 0 8 0 9 0 10 0 11 0 12 0 13 0 14 0 15 0 16 0 17 0 18 0 19 0 20 0 >20 0 --------------------------------------------------------------------------------------------------------------------------------------------- LibraryHandle: Address=30310e20 Hash=ebf439ba LockMode=0 PinMode=0 LoadLockMode=0 Status=VALD ObjectName: Name=select * from findme FullHashValue=57c14570e98dc8b98fe8a5a2ebf439ba Namespace=SQL AREA(00) Type=CURSOR(00) Identifier=3958651322 OwnerIdn=5 ... ChildTable: size='16' Child: id='0' Table=30310d58 Reference=303103e4 Handle=3030fb9c <---- Ref's FROM table SYSTEM.FINDME Child: id='1' Table=30310d58 Reference=303105b4 Handle=30303c24 <---- Ref's FROM table SYSTEM.FINDME ... --------------------------------------------------------------------------------------------------------------------------------------------- LibraryHandle: Address=302fe650 Hash=879fff26 LockMode=0 PinMode=0 LoadLockMode=0 Status=VALD ObjectName: Name=BEGIN findme_prc; END; FullHashValue=5154d81dcbdf40d7939b3ef5879fff26 Namespace=SQL AREA(00) Type=CURSOR(00) Identifier=2275409702 OwnerIdn=5 ... ChildTable: size='16' Child: id='0' Table=302fe588 Reference=302fdc14 Handle=302fd3cc <--- Ref's TO system.findme_prc NamespaceDump: Parent Cursor: sql_id=976tyyq3tzzt6 parent=0x302fd690 maxchild=1 plk=n ppn=n --------------------------------------------------------------------------------------------------------------------------------------------- LibraryHandle: Address=302f4dd8 Hash=6e74c5d2 LockMode=N PinMode=0 LoadLockMode=0 Status=VALD ObjectName: Name=SELECT COUNT(*) FROM FINDME FullHashValue=353d4e385aaae89b809e8ddf6e74c5d2 Namespace=SQL AREA(00) Type=CURSOR(00) Identifier=1853146578 OwnerIdn=5 ... ChildTable: size='16' Child: id='0' Table=302f4d10 Reference=302f439c Handle=302f3b54 <---- Ref's FROM table SYSTEM.FINDME NamespaceDump: Parent Cursor: sql_id=817ndvxr79jfk parent=0x302f3e18 maxchild=1 plk=y ppn=n --------------------------------------------------------------------------------------------------------------------------------------------- LibraryHandle: Address=302fa1e0 Hash=22a6cfbd LockMode=N PinMode=0 LoadLockMode=0 Status=VALD <---- Ref's from table SYSTEM.FINDME ObjectName: Name=SYSTEM.FINDME_PRC FullHashValue=7054bbdfcbae29102d2ad2c622a6cfbd Namespace=TABLE/PROCEDURE(01) Type=PROCEDURE(07) Identifier=96354 OwnerIdn=5 ... HandleReference: Address=302fa2f8 Handle=3160c070 Flags=OWN[200] ReferenceList: Reference: Address=302fc988 Handle=302fd3cc Flags=DEP[01] <---- Ref's TO "BEGIN findme_prc; END; Timestamp=01-19-2011 08:05:13 InvalidatedFrom=0 LibraryObject: Address=302f8f80 HeapMask=0000-0015-0015 Flags=EXS/LOC[0004] Flags2=[0000] PublicFlags=NST[0001] Dependencies: count='3' size='16' Dependency: num='0' Table=302f9f0c Reference=302f9114 Handle=315a6e6c Position=0 Flags=DEP[0001] Dependency: num='1' Table=302f9f0c Reference=302f913c Handle=3030d9f4 Position=0 Flags=DEP[0001] <--- Handle Refs TO SYSTEM.FINDME table's address Dependency: num='2' Table=302f9f0c Reference=302f9180 Handle=3111f4b4 Position=0 Flags=DEP[0001] ReadOnlyDependencies: count='1' size='16' ReadDependency: num='0' Table=302f9e74 Reference=302f92c4 Handle=302f4dd8 Flags=/ROD[20] Accesses: count='1' size='16' Dependency: num='1' Type=0009 ... --------------------------------------------------------------------------------------------------------------------------------------------- LibraryHandle: Address=303093b4 Hash=a29bc802 LockMode=N PinMode=0 LoadLockMode=0 Status=VALD ObjectName: Name=SELECT /* OPT_DYN_SAMP */ /*+ ALL_ROWS IGNORE_WHERE_CLAUSE NO_PARALLEL(SAMPLESUB) opt_param('parallel_execution_enabled', 'false') NO_PARALLEL_INDEX(SAMPLESUB) NO_SQL_TUNE */ NVL(SUM(C1),:"SYS_B_0"), NVL(SUM(C2),:"SYS_B_1") FROM (SELECT /*+ NO_PARALLEL("FINDME") FULL("FINDME") NO_PARALLEL_INDEX("FINDME") */ :"SYS_B_2" AS C1, :"SYS_B_3" AS C2 FROM "FINDME" "FINDME") SAMPLESUB FullHashValue=87819c9c2d2660e639748e7fa29bc802 Namespace=SQL AREA(00) Type=CURSOR(00) Identifier=2728118274 OwnerIdn=5 ... ChildTable: size='16' Child: id='0' Table=303092ec Reference=30308978 Handle=30308130 <--- link to SYSTEM.FINDME Reference list NamespaceDump: Parent Cursor: sql_id=3kx4fgyj9rk02 parent=0x303083f4 maxchild=1 plk=y ppn=n --------------------------------------------------------------------------------------------------------------------------------------------- LibraryHandle: Address=30301a7c Hash=93850874 LockMode=0 PinMode=0 LoadLockMode=0 Status=VALD ObjectName: Name=select dummy from findme FullHashValue=70b1c44268eb8c9d2860b06f93850874 Namespace=SQL AREA(00) Type=CURSOR(00) Identifier=2474969204 OwnerIdn=5 ... ChildTable: size='16' Child: id='0' Table=303019b4 Reference=30301040 Handle=303007f8 <--- link from SYSTEM.FINDME Reference list NamespaceDump: Parent Cursor: sql_id=2hs5hdy9sa23n parent=0x30300abc maxchild=1 plk=n ppn=n --------------------------------------------------------------------------------------------------------------------------------------------- LibraryHandle: Address=3030d9f4 Hash=6c124127 LockMode=0 PinMode=0 LoadLockMode=0 Status=VALD ObjectName: Name=SYSTEM.FINDME FullHashValue=21e921c2b77ab8ca1734546d6c124127 Namespace=TABLE/PROCEDURE(01) Type=TABLE(02) Identifier=96355 OwnerIdn=5 ... HandleReference: Address=3030db08 Handle=3160c070 Flags=OWN[200] ReferenceList: Reference: Address=302f30bc Handle=302f3b54 Flags=DEP[01] <-- ref to cursor: SELECT COUNT(*) FROM FINDME Timestamp=01-19-2011 08:05:13 InvalidatedFrom=0 Reference: Address=302f913c Handle=302fa1e0 Flags=DEP[01] <-- ref to procedure: SYSTEM.FINDME_PRC Timestamp=01-19-2011 08:05:13 InvalidatedFrom=0 Reference: Address=302ffdb4 Handle=303007f8 Flags=DEP[01] <-- ref to cursor: select dummy from findme Timestamp=01-19-2011 08:05:13 InvalidatedFrom=0 Reference: Address=303031e0 Handle=30303c24 Flags=DEP[01] <-- ref to cursor: select * from findme Timestamp=01-19-2011 08:05:13 InvalidatedFrom=0 Reference: Address=303077a0 Handle=30308130 Flags=DEP[01] <-- ref to cursor: SELECT /* OPT..... Timestamp=01-19-2011 08:05:13 InvalidatedFrom=0 Reference: Address=3030f158 Handle=3030fb9c Flags=DEP[01] <-- ref to cursor: select * from findme Timestamp=01-19-2011 08:05:13 InvalidatedFrom=0 ...