/ora/admin/NOLDB507/udump/noldb507_ora_12806.trc Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production With the Partitioning, OLAP and Data Mining options ORACLE_HOME = /opt/oracle/product/10.2.0/db_1 System name: Linux Node name: noldev507 Release: 2.6.9-34.ELsmp Version: #1 SMP Fri Feb 24 16:54:53 EST 2006 Machine: i686 Instance name: NOLDB507 Redo thread mounted by this instance: 1 Oracle process number: 26 Unix process pid: 12806, image: oracle@noldev507 (TNS V1-V3) *** 2007-02-26 16:40:38.912 *** SERVICE NAME:(SYS$USERS) 2007-02-26 16:40:38.824 *** SESSION ID:(134.55175) 2007-02-26 16:40:38.824 ****************************************************** HEAP DUMP heap name="pga heap" desc=0xcd3a320 extent sz=0x206c alt=92 het=32767 rec=0 flg=2 opc=2 parent=(nil) owner=(nil) nex=(nil) xsz=0xfff8 EXTENT 0 addr=0xb72b0008 Chunk b72b0010 sz= 55200 free " " Chunk b72bd7b0 sz= 2096 freeable "PLS non-lib hp " ds=0xcd95a6c Chunk b72bdfe0 sz= 8224 freeable "PLS non-lib hp " ds=0xcd95a6c EXTENT 1 addr=0xb7280008 Chunk b7280010 sz= 12928 perm "perm " alo=8732 Chunk b7283290 sz= 208 free " " Chunk b7283360 sz= 2096 freeable "PLS non-lib hp " ds=0xcd95a6c Chunk b7283b90 sz= 2096 freeable "PLS non-lib hp " ds=0xcd95a6c Chunk b72843c0 sz= 8240 recreate "PLS non-lib hp " latch=(nil) ds cd95a6c sz= 22752 ct= 5 b72bd7b0 sz= 2096 b7283360 sz= 2096 b72bdfe0 sz= 8224 b7283b90 sz= 2096 Chunk b72863f0 sz= 4164 freeable "Alloc environm " ds=0xcd720f4 Chunk b7287434 sz= 20616 freeable "Fixed Uga " Chunk b728c4bc sz= 176 freeable "ldm context " Chunk b728c56c sz= 176 freeable "ldm context " Chunk b728c61c sz= 176 freeable "ldm context " Chunk b728c6cc sz= 176 freeable "ldm context " Chunk b728c77c sz= 176 freeable "ldm context " Chunk b728c82c sz= 176 freeable "ldm context " Chunk b728c8dc sz= 280 freeable "ldm context " Chunk b728c9f4 sz= 664 freeable "ldm context " Chunk b728cc8c sz= 8216 freeable "ldm context " Chunk b728eca4 sz= 1636 freeable "ldm context " Chunk b728f308 sz= 584 freeable "ldm context " Chunk b728f550 sz= 212 freeable "ldm context " Chunk b728f624 sz= 552 freeable "kopolal dvoid " Chunk b728f84c sz= 300 freeable "kopolal dvoid " Chunk b728f978 sz= 220 freeable "kopolal dvoid " Chunk b728fa54 sz= 552 freeable "kopolal dvoid " Chunk b728fc7c sz= 900 freeable "kopolal dvoid " EXTENT 2 addr=0xcda35d8 Chunk cda35e0 sz= 6584 perm "perm " alo=6584 Chunk cda4f98 sz= 156 free " " Chunk cda5034 sz= 1292 freeable "kews sqlstat st" Chunk cda5540 sz= 260 freeable "KFK PGA " EXTENT 3 addr=0xcda1560 Chunk cda1568 sz= 4148 freeable "qmtmInit " ds=0xcda0804 Chunk cda259c sz= 4144 freeable "qmtmInit " ds=0xcda0804 EXTENT 4 addr=0xcd9f460 Chunk cd9f468 sz= 5108 perm "perm " alo=5108 Chunk cda085c sz= 3184 freeable "qmtmInit " ds=0xcda0804 EXTENT 5 addr=0xcd9d3e8 Chunk cd9d3f0 sz= 6808 perm "perm " alo=6808 Chunk cd9ee88 sz= 1484 recreate "qmtmInit " latch=(nil) ds cda0804 sz= 12960 ct= 4 cda1568 sz= 4148 cda259c sz= 4144 cda085c sz= 3184 EXTENT 6 addr=0xcd983c0 Chunk cd983c8 sz= 20496 perm "perm " alo=20496 EXTENT 7 addr=0xcd96348 Chunk cd96350 sz= 7224 perm "perm " alo=7224 Chunk cd97f88 sz= 440 perm "perm " alo=440 Chunk cd98140 sz= 332 recreate "joxp heap " latch=(nil) ds cd98298 sz= 332 ct= 1 Chunk cd9828c sz= 296 freeable "joxp heap " EXTENT 8 addr=0xcd942d0 Chunk cd942d8 sz= 3224 perm "perm " alo=3224 Chunk cd94f70 sz= 2556 perm "perm " alo=2556 Chunk cd9596c sz= 68 perm "perm " alo=68 Chunk cd959b0 sz= 40 free " " Chunk cd959d8 sz= 28 freeable "ldm context " Chunk cd959f4 sz= 72 freeable "KFIO PGA struct" Chunk cd95a3c sz= 36 freeable "koh-kghu call h" Chunk cd95a60 sz= 200 freeable "PLS cca hp desc" Chunk cd95b28 sz= 2068 freeable "kjztprq struct " EXTENT 9 addr=0xcd8eaa8 Chunk cd8eab0 sz= 22544 perm "perm " alo=22544 EXTENT 10 addr=0xcd8ca30 Chunk cd8ca38 sz= 4552 perm "perm " alo=4552 Chunk cd8dc00 sz= 3648 recreate "KSFQ heap " latch=(nil) ds cd8ea4c sz= 3648 ct= 1 Chunk cd8ea40 sz= 92 freeable "KSFQ heap descr" EXTENT 11 addr=0xcd87c00 Chunk cd87c08 sz= 17012 freeable "kgh stack " EXTENT 12 addr=0xcd70140 Chunk cd70148 sz= 1340 perm "perm " alo=1340 Chunk cd70684 sz= 1048 perm "perm " alo=1048 Chunk cd70a9c sz= 124 perm "perm " alo=108 Chunk cd70b18 sz= 60 freeable "KJZT context " Chunk cd70b54 sz= 20 freeable "external name " Chunk cd70b68 sz= 20 freeable "kzsna:login nam" Chunk cd70b7c sz= 4144 recreate "Alloc environm " latch=(nil) ds cd720f4 sz= 8308 ct= 2 b72863f0 sz= 4164 Chunk cd71bac sz= 1520 freeable "kpuinit env han" Total heap size = 257412 FREE LISTS: Bucket 0 size=44 Chunk cd959b0 sz= 40 free " " Bucket 1 size=76 Bucket 2 size=96 Bucket 3 size=140 Chunk b7283290 sz= 208 free " " Chunk cda4f98 sz= 156 free " " Bucket 4 size=236 Bucket 5 size=268 Bucket 6 size=524 Bucket 7 size=1036 Bucket 8 size=2060 Bucket 9 size=4108 Bucket 10 size=8204 Bucket 11 size=16396 Bucket 12 size=32780 Chunk b72b0010 sz= 55200 free " " Bucket 13 size=65548 Bucket 14 size=131084 Bucket 15 size=262156 Bucket 16 size=524300 Bucket 17 size=2097164 Total free space = 55604 UNPINNED RECREATABLE CHUNKS (lru first): PERMANENT CHUNKS: Chunk b7280010 sz= 12928 perm "perm " alo=8732 Chunk cda35e0 sz= 6584 perm "perm " alo=6584 Chunk cd9596c sz= 68 perm "perm " alo=68 Chunk cd9f468 sz= 5108 perm "perm " alo=5108 Chunk cd9d3f0 sz= 6808 perm "perm " alo=6808 Chunk cd94f70 sz= 2556 perm "perm " alo=2556 Chunk cd97f88 sz= 440 perm "perm " alo=440 Chunk cd70a9c sz= 124 perm "perm " alo=108 Chunk cd983c8 sz= 20496 perm "perm " alo=20496 Chunk cd96350 sz= 7224 perm "perm " alo=7224 Chunk cd942d8 sz= 3224 perm "perm " alo=3224 Chunk cd70684 sz= 1048 perm "perm " alo=1048 Chunk cd8eab0 sz= 22544 perm "perm " alo=22544 Chunk cd8ca38 sz= 4552 perm "perm " alo=4552 Chunk cd70148 sz= 1340 perm "perm " alo=1340 Permanent space = 95044 ****************************************************** ****************************************************** HEAP DUMP heap name="top call heap" desc=0xcd3cb20 extent sz=0x206c alt=100 het=32767 rec=0 flg=2 opc=2 parent=(nil) owner=(nil) nex=(nil) xsz=0xfffc EXTENT 0 addr=0xb7270004 Chunk b727000c sz= 32780 perm "perm " alo=304 Chunk b7278018 sz= 31672 free " " Chunk b727fbd0 sz= 1072 recreate "callheap " latch=(nil) ds cd3c220 sz= 1072 ct= 1 Total heap size = 65524 FREE LISTS: Bucket 0 size=44 Bucket 1 size=76 Bucket 2 size=96 Bucket 3 size=140 Bucket 4 size=236 Bucket 5 size=268 Bucket 6 size=524 Bucket 7 size=1036 Bucket 8 size=2060 Bucket 9 size=4108 Bucket 10 size=8204 Bucket 11 size=16396 Chunk b7278018 sz= 31672 free " " Bucket 12 size=32780 Bucket 13 size=65548 Bucket 14 size=131084 Bucket 15 size=262156 Bucket 16 size=524300 Bucket 17 size=2097164 Total free space = 31672 UNPINNED RECREATABLE CHUNKS (lru first): PERMANENT CHUNKS: Chunk b727000c sz= 32780 perm "perm " alo=304 Permanent space = 32780 ****************************************************** ****************************************************** HEAP DUMP heap name="top uga heap" desc=0xcd3cc40 extent sz=0xffdc alt=100 het=32767 rec=0 flg=3 opc=2 parent=(nil) owner=(nil) nex=(nil) xsz=0xfffc EXTENT 0 addr=0xb72a0004 Chunk b72a000c sz= 48 free " " Chunk b72a003c sz= 65476 freeable "session heap " ds=0xb7287448 EXTENT 1 addr=0xb7290004 Chunk b729000c sz= 48 free " " Chunk b729003c sz= 65476 recreate "session heap " latch=(nil) ds b7287448 sz= 130952 ct= 2 b72a003c sz= 65476 Total heap size = 131048 FREE LISTS: Bucket 0 size=44 Chunk b72a000c sz= 48 free " " Chunk b729000c sz= 48 free " " Bucket 1 size=76 Bucket 2 size=96 Bucket 3 size=140 Bucket 4 size=236 Bucket 5 size=268 Bucket 6 size=524 Bucket 7 size=1036 Bucket 8 size=2060 Bucket 9 size=4108 Bucket 10 size=8204 Bucket 11 size=16396 Bucket 12 size=32780 Bucket 13 size=65548 Bucket 14 size=131084 Bucket 15 size=262156 Bucket 16 size=524300 Bucket 17 size=2097164 Total free space = 96 UNPINNED RECREATABLE CHUNKS (lru first): PERMANENT CHUNKS: Permanent space = 0 ******************************************************