Trace file /appl1/home/oracle/diag/rdbms/abcxyz/abcxyz/trace/abcxyz_ora_16171.trc Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options ORACLE_HOME = /appl1/home/oracle/product/11.2.0/dbhome_1 System name: SunOS Node name: xserver Release: 5.10 Version: Generic_138888-07 Machine: sun4u Instance name: portal Redo thread mounted by this instance: 0 Oracle process number: 0 Unix process pid: 16171, image: oracle@xserver *** 2012-05-07 09:35:48.284 kewmnfy_1: gid=0, mxrwm=5, tsize=2960 kewmtotalchbsize_1(gid=0): mxent=1118,maxbuc=3,total_1=0 GetCHBSize: gid=0, dtype=0, mxbuc=3, mxrwm=3, mxent=1118, size=40248, kewmtotalchbsize_2(gid=0): (0, 40248) GetCHBSize: gid=0, dtype=1, mxbuc=3, mxrwm=2, mxent=1118, size=53664, kewmtotalchbsize_2(gid=0): (1, 93912) kewmtotalchbsize_3(gid=0): ESQBufsize=0, Total=93912 kewmtotalchbsize_4(gid=0): TBufsize=12, Final_total=93936 kewmnfy_2: gid=0, tsize=96896 kewmnfy_3: gid=0, mxrwm=5, RRMSize=16, tsize=96976 kewmnfy_4: gid=0, mxdrm=5, DRMSize=16, tsize=97056 kewmnfy_5: gid=0, mxTMStat=0, TMsiz=4, tsize=97056 kewmnfy_1: gid=1, mxrwm=5, tsize=97056 kewmtotalchbsize_1(gid=1): mxent=13,maxbuc=62,total_1=0 GetCHBSize: gid=1, dtype=0, mxbuc=62, mxrwm=2, mxent=13, size=6448, kewmtotalchbsize_2(gid=1): (0, 6448) GetCHBSize: gid=1, dtype=1, mxbuc=62, mxrwm=3, mxent=13, size=19344, kewmtotalchbsize_2(gid=1): (1, 25792) kewmtotalchbsize_3(gid=1): ESQBufsize=0, Total=25792 kewmtotalchbsize_4(gid=1): TBufsize=248, Final_total=26288 kewmnfy_2: gid=1, tsize=123344 kewmnfy_3: gid=1, mxrwm=5, RRMSize=16, tsize=123424 kewmnfy_4: gid=1, mxdrm=6, DRMSize=16, tsize=123520 kewmnfy_5: gid=1, mxTMStat=2, TMsiz=4, tsize=123528 kewmnfy_1: gid=11, mxrwm=10, tsize=123528 kewmtotalchbsize_1(gid=11): mxent=14,maxbuc=62,total_1=0 GetCHBSize: gid=11, dtype=0, mxbuc=62, mxrwm=0, mxent=14, size=0, kewmtotalchbsize_2(gid=11): (0, 0) GetCHBSize: gid=11, dtype=1, mxbuc=62, mxrwm=10, mxent=14, size=69440, kewmtotalchbsize_2(gid=11): (1, 69440) kewmtotalchbsize_3(gid=11): ESQBufsize=0, Total=69440 kewmtotalchbsize_4(gid=11): TBufsize=248, Final_total=69936 kewmnfy_2: gid=11, tsize=193464 kewmnfy_3: gid=11, mxrwm=10, RRMSize=16, tsize=193624 kewmnfy_4: gid=11, mxdrm=10, DRMSize=16, tsize=193784 kewmnfy_5: gid=11, mxTMStat=0, TMsiz=4, tsize=193784 kewmnfy_1: gid=2, mxrwm=110, tsize=193784 kewmtotalchbsize_1(gid=2): mxent=1,maxbuc=62,total_1=0 GetCHBSize: gid=2, dtype=0, mxbuc=62, mxrwm=89, mxent=1, size=22072, kewmtotalchbsize_2(gid=2): (0, 22072) GetCHBSize: gid=2, dtype=1, mxbuc=62, mxrwm=21, mxent=1, size=10416, kewmtotalchbsize_2(gid=2): (1, 32488) kewmtotalchbsize_3(gid=2): ESQBufsize=0, Total=32488 kewmtotalchbsize_4(gid=2): TBufsize=248, Final_total=32984 kewmnfy_2: gid=2, tsize=226768 kewmnfy_3: gid=2, mxrwm=110, RRMSize=16, tsize=228528 kewmnfy_4: gid=2, mxdrm=160, DRMSize=16, tsize=231088 kewmnfy_5: gid=2, mxTMStat=4, TMsiz=4, tsize=231104 kewmnfy_1: gid=3, mxrwm=110, tsize=231104 kewmtotalchbsize_1(gid=3): mxent=1,maxbuc=14,total_1=0 GetCHBSize: gid=3, dtype=0, mxbuc=14, mxrwm=89, mxent=1, size=4984, kewmtotalchbsize_2(gid=3): (0, 4984) GetCHBSize: gid=3, dtype=1, mxbuc=14, mxrwm=21, mxent=1, size=2352, kewmtotalchbsize_2(gid=3): (1, 7336) kewmtotalchbsize_3(gid=3): ESQBufsize=0, Total=7336 kewmtotalchbsize_4(gid=3): TBufsize=56, Final_total=7448 kewmnfy_2: gid=3, tsize=238552 kewmnfy_3: gid=3, mxrwm=110, RRMSize=16, tsize=240312 kewmnfy_4: gid=3, mxdrm=160, DRMSize=16, tsize=242872 kewmnfy_5: gid=3, mxTMStat=0, TMsiz=4, tsize=242872 kewmnfy_1: gid=4, mxrwm=1, tsize=242872 kewmtotalchbsize_1(gid=4): mxent=1536,maxbuc=62,total_1=0 GetCHBSize: gid=4, dtype=0, mxbuc=62, mxrwm=1, mxent=1536, size=380928, kewmtotalchbsize_2(gid=4): (0, 380928) GetCHBSize: gid=4, dtype=1, mxbuc=62, mxrwm=0, mxent=1536, size=0, kewmtotalchbsize_2(gid=4): (1, 380928) kewmtotalchbsize_3(gid=4): ESQBufsize=380928, Total=761856 kewmtotalchbsize_4(gid=4): TBufsize=248, Final_total=762352 kewmnfy_2: gid=4, tsize=1005224 kewmnfy_3: gid=4, mxrwm=1, RRMSize=16, tsize=1005240 kewmnfy_4: gid=4, mxdrm=1, DRMSize=16, tsize=1005256 kewmnfy_5: gid=4, mxTMStat=0, TMsiz=4, tsize=1005256 kewmnfy_1: gid=5, mxrwm=10, tsize=1005256 kewmtotalchbsize_1(gid=5): mxent=1536,maxbuc=3,total_1=0 GetCHBSize: gid=5, dtype=0, mxbuc=3, mxrwm=9, mxent=1536, size=165888, kewmtotalchbsize_2(gid=5): (0, 165888) GetCHBSize: gid=5, dtype=1, mxbuc=3, mxrwm=1, mxent=1536, size=36864, kewmtotalchbsize_2(gid=5): (1, 202752) kewmtotalchbsize_3(gid=5): ESQBufsize=18432, Total=221184 kewmtotalchbsize_4(gid=5): TBufsize=12, Final_total=221208 kewmnfy_2: gid=5, tsize=1226464 kewmnfy_3: gid=5, mxrwm=10, RRMSize=16, tsize=1226624 kewmnfy_4: gid=5, mxdrm=10, DRMSize=16, tsize=1226784 kewmnfy_5: gid=5, mxTMStat=2, TMsiz=4, tsize=1226792 kewmnfy_1: gid=6, mxrwm=3, tsize=1226792 kewmtotalchbsize_1(gid=6): mxent=118,maxbuc=62,total_1=0 GetCHBSize: gid=6, dtype=0, mxbuc=62, mxrwm=1, mxent=118, size=29264, kewmtotalchbsize_2(gid=6): (0, 29264) GetCHBSize: gid=6, dtype=1, mxbuc=62, mxrwm=2, mxent=118, size=117056, kewmtotalchbsize_2(gid=6): (1, 146320) kewmtotalchbsize_3(gid=6): ESQBufsize=29264, Total=175584 kewmtotalchbsize_4(gid=6): TBufsize=248, Final_total=176080 kewmnfy_2: gid=6, tsize=1402872 kewmnfy_3: gid=6, mxrwm=3, RRMSize=16, tsize=1402920 kewmnfy_4: gid=6, mxdrm=5, DRMSize=16, tsize=1403000 kewmnfy_5: gid=6, mxTMStat=4, TMsiz=4, tsize=1403016 kewmnfy_1: gid=7, mxrwm=6, tsize=1403016 kewmtotalchbsize_1(gid=7): mxent=200,maxbuc=8,total_1=0 GetCHBSize: gid=7, dtype=0, mxbuc=8, mxrwm=4, mxent=200, size=25600, kewmtotalchbsize_2(gid=7): (0, 25600) GetCHBSize: gid=7, dtype=1, mxbuc=8, mxrwm=2, mxent=200, size=25600, kewmtotalchbsize_2(gid=7): (1, 51200) kewmtotalchbsize_3(gid=7): ESQBufsize=6400, Total=57600 kewmtotalchbsize_4(gid=7): TBufsize=32, Final_total=57664 kewmnfy_2: gid=7, tsize=1460680 kewmnfy_3: gid=7, mxrwm=6, RRMSize=16, tsize=1460776 kewmnfy_4: gid=7, mxdrm=6, DRMSize=16, tsize=1460872 kewmnfy_5: gid=7, mxTMStat=0, TMsiz=4, tsize=1460872 kewmnfy_1: gid=9, mxrwm=0, tsize=1460872 kewmnfy_2: gid=9, tsize=1460872 kewmnfy_3: gid=9, mxrwm=0, RRMSize=16, tsize=1460872 kewmnfy_4: gid=9, mxdrm=2, DRMSize=16, tsize=1460904 kewmnfy_5: gid=9, mxTMStat=0, TMsiz=4, tsize=1460904 kewmnfy_1: gid=10, mxrwm=3, tsize=1460904 kewmtotalchbsize_1(gid=10): mxent=118,maxbuc=26,total_1=0 GetCHBSize: gid=10, dtype=0, mxbuc=26, mxrwm=1, mxent=118, size=12272, kewmtotalchbsize_2(gid=10): (0, 12272) GetCHBSize: gid=10, dtype=1, mxbuc=26, mxrwm=2, mxent=118, size=49088, kewmtotalchbsize_2(gid=10): (1, 61360) kewmtotalchbsize_3(gid=10): ESQBufsize=12272, Total=73632 kewmtotalchbsize_4(gid=10): TBufsize=104, Final_total=73840 kewmnfy_2: gid=10, tsize=1534744 kewmnfy_3: gid=10, mxrwm=3, RRMSize=16, tsize=1534792 kewmnfy_4: gid=10, mxdrm=5, DRMSize=16, tsize=1534872 kewmnfy_5: gid=10, mxTMStat=4, TMsiz=4, tsize=1534888 kewmnfy_1: gid=12, mxrwm=9, tsize=1534888 kewmtotalchbsize_1(gid=12): mxent=32,maxbuc=62,total_1=0 GetCHBSize: gid=12, dtype=0, mxbuc=62, mxrwm=0, mxent=32, size=0, kewmtotalchbsize_2(gid=12): (0, 0) GetCHBSize: gid=12, dtype=1, mxbuc=62, mxrwm=9, mxent=32, size=142848, kewmtotalchbsize_2(gid=12): (1, 142848) kewmtotalchbsize_3(gid=12): ESQBufsize=7936, Total=150784 kewmtotalchbsize_4(gid=12): TBufsize=248, Final_total=151280 kewmnfy_2: gid=12, tsize=1686168 kewmnfy_3: gid=12, mxrwm=9, RRMSize=16, tsize=1686312 kewmnfy_4: gid=12, mxdrm=9, DRMSize=16, tsize=1686456 kewmnfy_5: gid=12, mxTMStat=0, TMsiz=4, tsize=1686456 kewmnfy_1: gid=13, mxrwm=3, tsize=1686456 kewmtotalchbsize_1(gid=13): mxent=60,maxbuc=62,total_1=0 GetCHBSize: gid=13, dtype=0, mxbuc=62, mxrwm=3, mxent=60, size=44640, kewmtotalchbsize_2(gid=13): (0, 44640) GetCHBSize: gid=13, dtype=1, mxbuc=62, mxrwm=0, mxent=60, size=0, kewmtotalchbsize_2(gid=13): (1, 44640) kewmtotalchbsize_3(gid=13): ESQBufsize=14880, Total=59520 kewmtotalchbsize_4(gid=13): TBufsize=248, Final_total=60016 kewmnfy_2: gid=13, tsize=1746472 kewmnfy_3: gid=13, mxrwm=3, RRMSize=16, tsize=1746520 kewmnfy_4: gid=13, mxdrm=3, DRMSize=16, tsize=1746568 kewmnfy_5: gid=13, mxTMStat=0, TMsiz=4, tsize=1746568 kewmnfy_1: gid=14, mxrwm=11, tsize=1746568 kewmtotalchbsize_1(gid=14): mxent=50,maxbuc=26,total_1=0 GetCHBSize: gid=14, dtype=0, mxbuc=26, mxrwm=1, mxent=50, size=5200, kewmtotalchbsize_2(gid=14): (0, 5200) GetCHBSize: gid=14, dtype=1, mxbuc=26, mxrwm=10, mxent=50, size=104000, kewmtotalchbsize_2(gid=14): (1, 109200) kewmtotalchbsize_3(gid=14): ESQBufsize=5200, Total=114400 kewmtotalchbsize_4(gid=14): TBufsize=104, Final_total=114608 kewmnfy_2: gid=14, tsize=1861176 kewmnfy_3: gid=14, mxrwm=11, RRMSize=16, tsize=1861352 kewmnfy_4: gid=14, mxdrm=11, DRMSize=16, tsize=1861528 kewmnfy_5: gid=14, mxTMStat=11, TMsiz=4, tsize=1861572 kewmnfy_5a: mxent=1536, BSesBufSize=6144, tsize=1867716 kewmnfy_6: TOTAL=1867716