帮忙看看这个ORA-04031
最近客户的数据库连续两个月出现ORA-04031错误,以前一直是运行正常,数据库版本 9.2.0.6十一实施了数据迁移,由于是给ORACLE公司做实验,在数据同步上抛弃了以前的物化视图技术而选用了ODI
加装了JVM组件,并设置JAVA_POOL=300M
两次报错都是在业务高峰期结束后才发生,很郁闷
我们的系统在设计的时候存在问题,并没有使用绑定变量,所以开启了cursor_sharing = SIMILAR 参数
以下是ALTER文件
----------10月份报错----------
Fri Oct 19 01:07:31 2007
Completed checkpoint up to RBA [0x1d92.2.10], SCN: 0x07b9.09f47d1e
Fri Oct 19 01:37:34 2007
Completed checkpoint up to RBA [0x1d93.2.10], SCN: 0x07b9.09f4cf7c
Fri Oct 19 08:24:46 2007
Restarting dead background process QMN0
QMN0 started with pid=623
Fri Oct 19 08:28:31 2007
Errors in file /oracle/app/admin/ctais2/bdump/ctais2_smon_397538.trc:
ORA-00604: error occurred at recursive SQL level 2
ORA-04031: unable to allocate 4160 bytes of shared memory ("shared pool","SMON_SCN_TIME","sga heap(2,0)","kglsim heap")
Fri Oct 19 08:30:22 2007
Restarting dead background process QMN0
QMN0 started with pid=33
Fri Oct 19 08:36:00 2007
Restarting dead background process QMN0
QMN0 started with pid=630
Fri Oct 19 08:41:04 2007
Restarting dead background process QMN0
QMN0 started with pid=33
Fri Oct 19 08:46:35 2007
Restarting dead background process QMN0
QMN0 started with pid=50
------------11月报错---------------
Completed checkpoint up to RBA [0x1f91.2.10], SCN: 0x07b9.7265eb60
Thu Nov 15 08:23:58 2007
Restarting dead background process QMN0
QMN0 started with pid=258
Thu Nov 15 08:29:14 2007
Restarting dead background process QMN0
QMN0 started with pid=391
Thu Nov 15 08:31:22 2007
Errors in file /oracle/app/admin/ctais2/bdump/ctais2_smon_483762.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 4160 bytes of shared memory ("shared pool","unknown object","sga heap(2,0)","kglsim heap")
Thu Nov 15 08:31:23 2007
Errors in file /oracle/app/admin/ctais2/bdump/ctais2_smon_483762.trc:
ORA-04031: unable to allocate 4160 bytes of shared memory ("shared pool","COL_USAGE$SYS","sga heap(2,0)","kglsim heap")
Thu Nov 15 08:31:24 2007
Errors in file /oracle/app/admin/ctais2/bdump/ctais2_smon_483762.trc:
ORA-04031: unable to allocate 4160 bytes of shared memory ("shared pool","COL_USAGE$SYS","sga heap(2,0)","kglsim heap")
Thu Nov 15 08:31:25 2007
Errors in file /oracle/app/admin/ctais2/bdump/ctais2_smon_483762.trc:
ORA-04031: unable to allocate 4160 bytes of shared memory ("shared pool","COL_USAGE$SYS","sga heap(2,0)","kglsim heap")
Thu Nov 15 08:31:26 2007
Errors in file /oracle/app/admin/ctais2/bdump/ctais2_smon_483762.trc:
ORA-04031: unable to allocate 4160 bytes of shared memory ("shared pool","COL_USAGE$SYS","sga heap(2,0)","kglsim heap")
Thu Nov 15 08:31:37 2007
Errors in file /oracle/app/admin/ctais2/bdump/ctais2_smon_483762.trc:
ORA-04031: unable to allocate 4160 bytes of shared memory ("shared pool","COL_USAGE$SYS","sga heap(2,0)","kglsim heap")
Thu Nov 15 08:31:47 2007
Errors in file /oracle/app/admin/ctais2/bdump/ctais2_smon_483762.trc:
ORA-04031: unable to allocate 4160 bytes of shared memory ("shared pool","COL_USAGE$SYS","sga heap(2,0)","kglsim heap")
Thu Nov 15 08:31:56 2007
Errors in file /oracle/app/admin/ctais2/bdump/ctais2_smon_483762.trc:
ORA-04031: unable to allocate 4160 bytes of shared memory ("shared pool","COL_USAGE$SYS","sga heap(2,0)","kglsim heap")
Thu Nov 15 08:32:07 2007
Errors in file /oracle/app/admin/ctais2/bdump/ctais2_smon_483762.trc:
ORA-04031: unable to allocate 4160 bytes of shared memory ("shared pool","COL_USAGE$SYS","sga heap(2,0)","kglsim heap")
Thu Nov 15 08:32:17 2007
Errors in file /oracle/app/admin/ctais2/bdump/ctais2_smon_483762.trc:
ORA-04031: unable to allocate 4160 bytes of shared memory ("shared pool","COL_USAGE$SYS","sga heap(2,0)","kglsim heap")
Thu Nov 15 08:32:27 2007
Errors in file /oracle/app/admin/ctais2/bdump/ctais2_smon_483762.trc:
ORA-04031: unable to allocate 4160 bytes of shared memory ("shared pool","COL_USAGE$SYS","sga heap(2,0)","kglsim heap")
Thu Nov 15 08:32:37 2007
Errors in file /oracle/app/admin/ctais2/bdump/ctais2_smon_483762.trc:
ORA-04031: unable to allocate 4160 bytes of shared memory ("shared pool","COL_USAGE$SYS","sga heap(2,0)","kglsim heap")
Thu Nov 15 08:32:47 2007
Errors in file /oracle/app/admin/ctais2/bdump/ctais2_smon_483762.trc:
ORA-04031: unable to allocate 4160 bytes of shared memory ("shared pool","COL_USAGE$SYS","sga heap(2,0)","kglsim heap")
Thu Nov 15 08:32:57 2007
Errors in file /oracle/app/admin/ctais2/bdump/ctais2_smon_483762.trc:
ORA-04031: unable to allocate 4160 bytes of shared memory ("shared pool","COL_USAGE$SYS","sga heap(2,0)","kglsim heap")
Thu Nov 15 08:33:07 2007
Errors in file /oracle/app/admin/ctais2/bdump/ctais2_smon_483762.trc:
ORA-04031: unable to allocate 4160 bytes of shared memory ("shared pool","COL_USAGE$SYS","sga heap(2,0)","kglsim heap")
Thu Nov 15 08:33:17 2007
Errors in file /oracle/app/admin/ctais2/bdump/ctais2_smon_483762.trc:
ORA-04031: unable to allocate 4160 bytes of shared memory ("shared pool","COL_USAGE$SYS","sga heap(2,0)","kglsim heap")
Thu Nov 15 08:34:42 2007
Restarting dead background process QMN0
QMN0 started with pid=36
Thu Nov 15 08:37:04 2007
Errors in file /oracle/app/admin/ctais2/bdump/ctais2_j000_1741126.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 4160 bytes of shared memory ("shared pool","unknown object","sga heap(2,0)","kglsim heap")
Thu Nov 15 08:37:07 2007
Errors in file /oracle/app/admin/ctais2/bdump/ctais2_smon_483762.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 4160 bytes of shared memory ("shared pool","unknown object","sga heap(2,0)","kglsim heap")
Thu Nov 15 08:37:07 2007
Errors in file /oracle/app/admin/ctais2/udump/ctais2_ora_716908.trc:
ORA-00600: internal error code, arguments: [729], [2240], [space leak], [], [], [], [], []
Thu Nov 15 08:37:08 2007
Errors in file /oracle/app/admin/ctais2/udump/ctais2_ora_913798.trc:
ORA-00600: internal error code, arguments: [729], [1720], [space leak], [], [], [], [], []
Thu Nov 15 08:37:09 2007
Errors in file /oracle/app/admin/ctais2/udump/ctais2_ora_1036730.trc:
ORA-00600: internal error code, arguments: [729], [4032], [space leak], [], [], [], [], []
Thu Nov 15 08:37:15 2007
Errors in file /oracle/app/admin/ctais2/udump/ctais2_ora_1900590.trc:
ORA-00600: internal error code, arguments: [729], [3632], [space leak], [], [], [], [], []
Thu Nov 15 08:37:16 2007
Errors in file /oracle/app/admin/ctais2/udump/ctais2_ora_1458578.trc:
ORA-00600: internal error code, arguments: [729], [392], [space leak], [], [], [], [], []
Thu Nov 15 08:37:16 2007
Errors in file /oracle/app/admin/ctais2/udump/ctais2_ora_1601998.trc:
ORA-00600: internal error code, arguments: [729], [392], [space leak], [], [], [], [], []
Thu Nov 15 08:37:17 2007
Errors in file /oracle/app/admin/ctais2/udump/ctais2_ora_1556920.trc:
ORA-00600: internal error code, arguments: [729], [1952], [space leak], [], [], [], [], []
Thu Nov 15 08:37:18 2007
Errors in file /oracle/app/admin/ctais2/udump/ctais2_ora_1740806.trc:
ORA-00600: internal error code, arguments: [729], [2224], [space leak], [], [], [], [], []
Thu Nov 15 08:37:22 2007
Errors in file /oracle/app/admin/ctais2/udump/ctais2_ora_1090004.trc:
ORA-00600: internal error code, arguments: [729], [584], [space leak], [], [], [], [], []
Thu Nov 15 08:37:23 2007
Errors in file /oracle/app/admin/ctais2/udump/ctais2_ora_1282354.trc:
ORA-00600: internal error code, arguments: [729], [10640], [space leak], [], [], [], [], []
Thu Nov 15 08:37:24 2007
Errors in file /oracle/app/admin/ctais2/udump/ctais2_ora_1896492.trc:
ORA-00600: internal error code, arguments: [729], [4024], [space leak], [], [], [], [], []
Thu Nov 15 08:40:21 2007
Restarting dead background process QMN0
QMN0 started with pid=38
Thu Nov 15 09:46:36 2007
Beginning log switch checkpoint up to RBA [0x1f92.2.10], SCN: 0x07b9.7299acf5
Thread 1 advanced to log sequence 8082
Current log# 1 seq# 8082 mem# 0: /oracle/app/oradata/ctais2/redo01a.log
Current log# 1 seq# 8082 mem# 1: /oracle/app/oradata/ctais2/redo01b.log
Thu Nov 15 09:46:36 2007
ARC0: Evaluating archive log 3 thread 1 sequence 8081
ARC0: Beginning to archive log 3 thread 1 sequence 8081
Creating archive destination LOG_ARCHIVE_DEST_1: '/oralog/1_8081.dbf'
Thu Nov 15 09:46:50 2007
ARC0: Completed archiving log 3 thread 1 sequence 8081
Thu Nov 15 10:15:33 2007
Completed checkpoint up to RBA [0x1f92.2.10], SCN: 0x07b9.7299acf5
--------------------------------------------------------
感觉每次出错的时候都是在不停的去重启动QMN0,看了DUMP出来的SGA,也没看出来问题,个人比较菜
所以想把aq_tm_processes从1调整到10看看(我没有在现场,只能看日志文件给客户那边意见)
SHARED_POOL绝对够大,ORACLE公司当时建库的时候定的2G,也没调整过 初始化参数
--------------------------------------------
processes = 2000
timed_statistics = TRUE
shared_pool_size = 2013265920
sga_max_size = 21480881448
shared_pool_reserved_size= 528482304
large_pool_size = 536870912
java_pool_size = 318767104
lock_sga = TRUE
db_block_size = 8192
db_writer_processes = 15
db_cache_size = 16106127360
compatible = 9.2.0.0.0
log_archive_start = TRUE
log_archive_dest =
log_archive_dest_1 = location=/oralog
log_archive_dest_2 =
log_archive_dest_state_2 = ENABLE
log_archive_max_processes= 4
log_buffer = 5000192
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
log_checkpoints_to_alert = TRUE
control_file_record_keep_time= 14
dml_locks = 15000
transactions = 10000
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 7200
remote_login_passwordfile= EXCLUSIVE
cursor_space_for_time = FALSE
session_cached_cursors = 300
job_queue_processes = 10
cursor_sharing = SIMILAR
hash_join_enabled = TRUE
sort_area_size = 524288
open_cursors = 5000
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
query_rewrite_integrity = STALE_TOLERATED
pga_aggregate_target = 4294967296
aq_tm_processes = 1
-------------------------------------------- 数据库拓机时的DUMP
-----------------------
*** 2007-10-19 08:28:31.689
=================================
Begin 4031 Diagnostic Information
=================================
The following information assists Oracle in diagnosing
causes of ORA-4031 errors. This trace may be disabled
by setting the init.ora parameter _4031_dump_bitvec = 0
======================================
Allocation Request Summary Information
======================================
Current information setting: 00654fff
Dump Interval=300 seconds SGA Heap Dump Interval=3600 seconds
Last Dump Time=10/19/2007 08:28:31
Allocation request for: kglsim heap
Heap: 70000000003cee8, size: 4160
******************************************************
HEAP DUMP heap name="sga heap(2,0)" desc=70000000003cee8
extent sz=0xfe0 alt=200 het=32767 rec=9 flg=-126 opc=0
parent=0 owner=0 nex=0 xsz=0x1
====================
Process State Object
====================
----------------------------------------
SO: 70000047f7d9460, type: 2, owner: 0, flag: INIT/-/-/0x00
(process) Oracle pid=20, calls cur/top: 7000004d9763338/7000004818c7a50, flag: (16) SYSTEM
int error: 0, call error: 0, sess error: 0, txn error 0
(post info) last post received: 0 0 30
last post received-location: ksrpublish
last process to post me: 70000047f804e38 1 0
last post sent: 263 0 16
last post sent-location: ksasnd
last process posted by me: 70000047f7d8a30 1 6
(latch info) wait_event=0 bits=20
holding 7000004887c9bb8 Child library cache level=5 child#=20
Location from where latch is held: kglobpn: child:: latch
Context saved from call: 9
state=busy
Process Group: DEFAULT, pseudo proc: 7000004837e2ee0
O/S info: user: oracle, term: UNKNOWN, ospid: 397538
OSD pid info: Unix process pid: 397538, image: oracle@ctaisp1 (SMON)
=========================
User Session State Object
=========================
----------------------------------------
SO: 7000004807d28f0, type: 4, owner: 70000047f7d9460, flag: INIT/-/-/0x00
(session) trans: 0, creator: 70000047f7d9460, flag: (100051) USR/- BSY/-/-/-/-/-
DID: 0001-0014-00000002, short-term DID: 0000-0000-00000000
txn branch: 0
oct: 0, prv: 0, sql: 7000004cf85eab8, psql: 7000004cf85eab8, user: 0/SYS
last wait for 'smon timer' blocking sess=0x0 seq=44851 wait_time=48748561
sleep time=12c, failed=0, =0
temporary object counter: 0
============================
Current Session State Object
============================
----------------------------------------
SO: 7000004808168e0, type: 4, owner: 7000004818c7a50, flag: INIT/-/-/0x00
(session) trans: 70000048875ec68, creator: 0, flag: (2) -/REC -/-/-/-/-/-
DID: 0000-0000-00000000, short-term DID: 0000-0000-00000000
txn branch: 0
oct: 0, prv: 0, sql: 7000004dba55bc0, psql: 7000004dba55bc0, user: 0/SYS
temporary object counter: 0
==================
Current KGL Object
==================
LIBRARY OBJECT HANDLE: handle=7000004e8f3ef40
name=SYS.SMON_SCN_TIME
hash=62c964c3 timestamp=07-05-2005 11:38:41
namespace=TABL/PRCD/TYPE flags=KGHP/TIM/SML/[02000000]
kkkk-dddd-llll=0000-0501-0501 lock=S pin=S latch#=19
lwt=7000004e8f3ef70[7000004e8f3ef70,7000004e8f3ef70] ltm=7000004e8f3ef80[7000004e8f3ef80,7000004e8f3ef80]
pwt=7000004e8f3efa0[7000004e8f3efa0,7000004e8f3efa0] ptm=7000004e8f3f030[7000004e8f3f030,7000004e8f3f030]
ref=7000004e8f3ef50[7000004e8f3ef50, 7000004e8f3ef50] lnd=7000004e8f3f048[700000480d6c250,7000004e2642dd8]
LIBRARY OBJECT: object=7000004b8424a50
type=TABL flags=EXS/LOC[0005] pflags= [00] status=VALD load=X
===========================
Current Instatiation Object
===========================
-------------------------------------
INSTANTIATION OBJECT: object=1103130b8
type="cursor"[2] lock=7000004d5cbb198 handle=7000004eda6cfe0 body=0 level=0
flags=FST[60] executions=0
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksm_4031_dump+065c bl ksedst 102D08084 ?
ksmasg+0084 bl ksm_4031_dump FFFFFFFFFFEEB30 ? 000000000 ?
10252DF78 ? 7000004B5B1D8F0 ?
110005868 ? FFFFFFFFFFEF140 ?
kghnospc+0168 bl _ptrgl
kghalo+00f0 bl kghnospc 000000010 ? 000000006 ?
000000001 ? 000000000 ?
000000000 ?
kglsim_chk_heaplist bl kghalo 7000004C3AED5A8 ? 0000000F8 ?
+0128 100ABA484 ? 0FFFFFFFC ?
000000001 ? 07FFFFFFC ?
0FFFFFFF8 ? 080000000 ?
kglsim_upd_newhp+04 bl kglsim_chk_heaplist 7000004EDA6CFE0 ? 110005868 ?
3c
kglobpn+05a0 bl kglsim_upd_newhp 000000000 ? 000000000 ?
000000000 ? 000000000 ?
000000000 ?
kglpim+0184 bl kglobpn 000000002 ? 000000001 ?
000000001 ? 000000000 ?
kglpin+0a04 bl kglpim 110005868 ? FFFFFFFFFFEFBB0 ?
7000004AD8A1E10 ?
kkspsc0+0598 bl kglpin 110005868 ? FFFFFFFFFFEFBB0 ?
7000004D5CBB198 ?
7000004EDA6CFE0 ? 301148974 ?
00000000B ? FFFFFFFFFFEFAD8 ?
opiosq0+0614 bl kkspsc0 1102B0630 ? 1025FB66C ?
000000098 ? 300000003 ?
000000000 ? 000000000 ?
000000000 ? 000000000 ?
opiosq+0018 bl opiosq0 7000004808168E0 ? 000000000 ?
000000008 ? 000000000 ?
opiodr+08e8 bl _ptrgl
rpidrus+008c bl opiodr 4AFFFF24C0 ? F10002358 ?
FFFFFFFFFFF24D0 ? 300000000 ?
skgmstack+00d0 bl _ptrgl
rpidru+0090 bl skgmstack 1100053D8 ? FFFFFFFFFFF1A70 ?
FFFFFFFFFFF19A0 ? 00000F618 ?
10042E90C ?
rpiswu2+0358 bl _ptrgl
rpidrv+07f4 bl rpiswu2 7000004808168E0 ? 000000000 ?
000000000 ? 000000000 ?
000000040 ? 000000000 ?
000000040 ? 000000000 ?
rpisplu+02a0 bl rpidrv 30094F8DC ? 4AFAEDD3C0 ?
FFFFFFFFFFF24D0 ? 000000000 ?
rpispl+002c bl rpisplu 300000003 ? 000000000 ?
000000000 ? 1025FB66C ?
000000097 ? 000000000 ?
000000000 ? 000000003 ?
kqdgtc+03f4 bl rpispl 300000003 ? 110247318 ?
110247348 ? 000000001 ?
110247378 ? 000000000 ?
kqldaur+004c bl kqdgtc 5400000054 ?
FFFFFFFFFFF2A34 ? 000000000 ?
7000004B8424B48 ? 000000000 ?
000000000 ? 000000020 ?
000000003 ?
kglslod+01f4 bl _ptrgl
kqlslod+001c bl kglslod 000000000 ? 000000000 ?
000000000 ?
kqlsublod+0070 bl kqlslod 000000000 ? 000000000 ?
kqllod+0f14 bl _ptrgl
kglobld+03c0 bl _ptrgl
kglobpn+06ec bl kglobld 110005868 ? 7000004B8424A50 ?
FFFFFFFFFFF4B68 ?
7000004E4FCC830 ? 000000001 ?
kglpim+0184 bl kglobpn 7000004B8424A68 ? 110005868 ?
000000001 ? 000000001 ?
kglpin+0a04 bl kglpim 110005868 ? FFFFFFFFFFF4B68 ?
7000004E4FCC830 ?
kglgob+0178 bl kglpin 110005868 ? FFFFFFFFFFF4B68 ?
7000004FA71AF88 ?
7000004E8F3EF40 ? 2102AD0B0 ?
1003D2AF8 ? FFFFFFFFFFF4448 ?
kkdcacr+02ac bl kglgob 110005868 ? FFFFFFFFFFF4B68 ?
200000020 ? 200000001 ?
200000000 ? 200000000 ?
FFFFFFFFFFF4B08 ?
FFFFFFFFFFF4B00 ?
kkdcacc+0184 bl kkdcacr FFFFFFFFFFF4E60 ? 1100059A8 ?
FFFFFFFFFFF5140 ?
28222848C9D40DB0 ?
kkmacr+014c bl kkdcacc 10221DBD0 ? 110314918 ?
7000004ABC3E564 ?
opiprsdml+00e8 bl kkmacr 7000004ABC3E4F0 ?
opiSem+1ab8 bl opiprsdml 1102AD0D0 ?
opiprs+013c bl opiSem FFFFFFFFFFF7D78 ? 102771380 ?
000000081 ? 000000000 ?
kksald+03c4 bl opiprs 000000006 ? 000000000 ?
7000004E9CF6128 ? 1102472E8 ?
1100059A8 ? 000000000 ?
000000000 ?
rpiswu2+0358 bl _ptrgl
kkslod+0f80 bl rpiswu2 7000004808168E0 ?
FFFFFFFFFFF8740 ?
70000008C9F4014 ? 1101C69A8 ?
FFFFFFFFFFF7D90 ? 01000593C ?
100CC1B30 ? 000000000 ?
kglobld+03c0 bl _ptrgl
kglobpn+06ec bl kglobld 110005868 ? 7000004F9996C40 ?
FFFFFFFFFFF8FC0 ?
7000004EFF1E588 ? 10008C7A0 ?
kglpim+0184 bl kglobpn 000000098 ? 7000004887CA758 ?
7000004808D08A8 ? 000000000 ?
kglpin+0a04 bl kglpim 110005868 ? FFFFFFFFFFF8FC0 ?
7000004EFF1E588 ?
kksfbc+2514 bl kglpin 110005868 ? FFFFFFFFFFF8FC0 ?
70000049FB4D1A8 ?
7000004F9E5A6B0 ? 302D05DA0 ?
F9E5A6B000000000 ?
1103149C0 ?
kkspsc0+06bc bl kksfbc 110314918 ? 300000003 ?
10800000108 ? 102771380 ?
000000081 ? 7000004B9E062D0 ?
000000000 ? 000000000 ?
opiosq0+0614 bl kkspsc0 1102B0590 ? 102771380 ?
000000081 ? 300000003 ?
000000000 ?
2000000000000020 ?
000000000 ? 000000000 ?
opiall0+0328 bl opiosq0 70000048C6B96D8 ?
70000048C6B96B8 ?
7000004E07F9138 ?
70000048BF47910 ?
opikpr+02b4 bl opiall0 65101B5600 ? 22FFFFA960 ?
FFFFFFFFFFFA998 ? 000000000 ?
000000000 ? FFFFFFFFFFFA91C ?
800094EED4 ? 20000000000002 ?
opiodr+08e8 bl _ptrgl
rpidrus+008c bl opiodr 65025F57B4 ? 1400000003 ?
1102AEA90 ? 08F998CD8 ?
skgmstack+00d0 bl _ptrgl
rpidru+0090 bl skgmstack 000000000 ? 000000001 ?
FFFFFFFFFFFC450 ? 000000000 ?
000000000 ?
rpiswu2+0358 bl _ptrgl
kprball+05c8 bl rpiswu2 7000004808168E0 ?
FFFFFFFFFFFF9E8 ? 100E33734 ?
1101C69A8 ? 000000000 ?
0101C69A8 ? FFFFFFFFFFFCAA0 ?
000000000 ?
ktf_scn_time+0a6c bl kprball 1102AEA90 ? 14000000000 ?
ktmmon+1cec bl ktf_scn_time
ksbrdp+02a4 bl _ptrgl
opirip+02a8 bl ksbrdp
opidrv+0300 bl opirip 900000000054230 ? 0101C69A8 ?
000000000 ?
sou2o+0028 bl opidrv 32002E3250 ? 0A00595B8 ?
000000000 ?
main+01a4 bl 01FD2EC8
__start+0090 bl main 000000000 ? 000000000 ?
----- End of Call Stack Trace -----
UID191960 帖子15 精华1 积分25 流通积分25 点 金钱0 O元 阅读权限20 在线时间18 小时 注册时间2006-9-25 最后登录2008-7-7 查看详细资料
引用 使用道具 报告 回复 TOP ===============================
Memory Utilization of Subpool 1
===============================
Allocation Name Size
_________________________ __________
"free memory " 167654664
"miscellaneous " 2862544
"db_block_hash_buckets " 1573056
"Checkpoint queue " 1283200
"partitioning i " 0
"trigger defini " 0
"transaction " 641040
"KQR S SO " 7472
"kglsim hash table bkts " 700416
"parameters " 15504
"MTTR advisory " 170912
"KQR M PO " 31288
"sim memory hea " 2652208
"sim trace entries " 737280
"enqueue " 3629864
"session param values " 2498496
"table definiti " 336
"partitioning d " 163072
"DML lock " 2912872
"channel handle " 520536
"joxs heap init " 4240
"trigger source " 0
"dictionary cache " 14336
"transaction co " 0
"errors " 2904
"kglsim object batch " 7439040
"temporary tabl " 129592
"library cache " 142405864
"PL/SQL PPCODE " 47288
"sql area " 18613072
"sessions " 992368
"PL/SQL MPCODE " 180584
"event statistics per sess" 4162816
"kglsim heap " 5611840
"joxlod: in ehe " 79968
"fixed allocation callback" 304
"KGLS heap " 1317768
"PL/SQL DIANA " 42008
===============================
Memory Utilization of Subpool 2
===============================
Allocation Name Size
_________________________ __________
"free memory " 150505824
"miscellaneous " 11730384
"db_block_hash_buckets " 20328880
"PL/SQL SOURCE " 0
"Checkpoint queue " 1283200
"obj htab chunk " 655872
"PL/SQL MPCODE " 37304
"partitioning i " 0
"trace buffer " 1933312
"PL/SQL DIANA " 0
"trigger inform " 0
"UNDO INFO SEGMENTED ARRAY" 433312
"transaction co " 0
"PL/SQL PPCODE " 0
"temporary tabl " 192232
"kglsim heap " 7213440
"message pool freequeue " 323896
"errors " 0
"table definiti " 0
"partitioning d " 0
"KQR M PO " 165920
"parameters " 0
"dictionary cache " 1057280
"trigger defini " 0
"enqueue resources " 1981488
"joxlod: in ehe " 70984
"transaction " 641040
"library cache " 161081032
"dummy " 179176
"sql area " 10744
"sessions " 992368
"sim memory hea " 2659704
"kglsim hash table bkts " 700416
"event statistics per sess" 4151504
"fixed allocation callback" 312
"FileIdentificatonBlock " 224960
"KGLS heap " 26584
"MTTR advisory " 517584
===============================
Memory Utilization of Subpool 3
===============================
Allocation Name Size
_________________________ __________
"free memory " 155652760
"miscellaneous " 1344520
"partitioning d " 98128
"PL/SQL MPCODE " 116928
"trigger defini " 15160
"PL/SQL PPCODE " 52664
"transaction " 641040
"joxlod: in ehe " 67472
"sim memory hea " 2656472
"KQR M PO " 696456
"partitioning i " 0
"session param values " 2278848
"errors " 0
"PL/SQL DIANA " 56352
"trigger source " 0
"transaction co " 0
"db_block_hash_buckets " 1572768
"temporary tabl " 145040
"kglsim hash table bkts " 700416
"Temporary Tables State Ob" 517080
"KGK heap " 552
"trace buffer " 1654784
"dictionary cache " 1065472
"Checkpoint queue " 1283200
"kglsim heap " 5482880
"parameters " 3192
"table definiti " 9064
"library cache " 164619192
"kglsim object batch " 6999552
"sql area " 14165672
"sessions " 995072
"PLS non-lib hp " 2088
"event statistics per sess" 4151504
"KGLS heap " 1327712
"fixed allocation callback" 280
"joxlod: in phe " 0
"KQR X PO " 10304
"KQR L PO " 716128
===============================
Memory Utilization of Subpool 4
===============================
Allocation Name Size
_________________________ __________
"free memory " 148664544
"miscellaneous " 22353744
"db_block_hash_buckets " 20325168
"parameters " 2608
"trigger source " 0
"KQR M PO " 1651936
"trigger defini " 0
"joxlod: in phe " 0
"transaction co " 0
"KQR L SO " 880400
"table definiti " 1512
"PL/SQL PPCODE " 0
"trigger inform " 1544
"sim memory hea " 2674680
"PL/SQL MPCODE " 146640
"ktlbk state objects " 1299800
"db_handles " 2320000
"KGK heap " 6448
"branch " 788560
"KQR M SO " 993176
"PX subheap " 27504
"Checkpoint queue " 1283200
"dictionary cache " 24576
"errors " 0
"partitioning d " 55528
"PL/SQL DIANA " 16648
"joxlod: in ehe " 66248
"library cache " 144815504
"processes " 2608000
"sql area " 10394440
"sessions " 995072
"partitioning i " 0
"KGLS heap " 1379504
"event statistics per sess" 4151504
"temporary tabl " 135928
"fixed allocation callback" 336
"KSXR receive buffers " 1034000
"PL/SQL SOURCE " 0
===============================
Memory Utilization of Subpool 5
===============================
Allocation Name Size
_________________________ __________
"free memory " 158748520
"miscellaneous " 4190240
"trigger inform " 0
"KQR M PO " 637928
"transaction " 641040
"message pool freequeue " 193440
"ksm_file2sga region " 370496
"temporary tabl " 90920
"partitioning i " 0
"PL/SQL DIANA " 477880
"KSXR pending messages que" 853952
"db_block_hash_buckets " 1703840
"PL/SQL PPCODE " 0
"set_descriptor_array " 193920
"Checkpoint queue " 1283200
"trigger defini " 0
"partitioning d " 219536
"sim memory hea " 2652208
"kglsim object batch " 6818112
"errors " 1064
"joxlod: in ehe " 77000
"kglsim hash table bkts " 696320
"dictionary cache " 1057792
"messages " 416000
"PL/SQL MPCODE " 186912
"KGLS heap " 1857008
"session param values " 1482624
"library cache " 147297736
"transaction co " 0
"sql area " 24726872
"sessions " 995072
"table definiti " 13120
"event statistics per sess" 4162816
"trace buffer " 1294336
"kglsim heap " 5224960
"fixed allocation callback" 312
"1M buffer " 528384
"parameters " 5192
===============================
Memory Utilization of Subpool 6
===============================
Allocation Name Size
_________________________ __________
"free memory " 142262184
"miscellaneous " 12419336
"kglsim hash table bkts " 700416
"KGLS heap " 1464480
"qmps connections " 934920
"partitioning d " 158824
"trace buffer " 2064384
"KQR M PO " 32768
"trigger inform " 0
"parameters " 8616
"session param values " 1070784
"message pool freequeue " 215544
"errors " 0
"trigger defini " 2128
"FileOpenBlock " 12744008
"table definiti " 6392
"transaction " 769248
"partitioning i " 0
"transaction co " 0
"PL/SQL MPCODE " 163816
"constraints " 550048
"sim memory hea " 2652208
"dictionary cache " 10496
"Checkpoint queue " 1283200
"trigger source " 0
"joxlod: in ehe " 53920
"character set object " 106720
"library cache " 124157800
"PL/SQL DIANA " 15232
"sql area " 21247560
"sessions " 992368
"PL/SQL PPCODE " 0
"event statistics per sess" 4162816
"temporary tabl " 171160
"fixed allocation callback" 256
"KQR L PO " 1321680
"db_block_hash_buckets " 20325168
"krvxrr " 253056
LIBRARY CACHE STATISTICS:
namespace gets hit ratio pins hit ratio reloads invalids
-------------- --------- --------- --------- --------- ---------- ----------
CRSR 146406458 0.986 1480112193 0.963 11965494 234305
TABL/PRCD/TYPE 251127845 0.998 424614895 0.987 2110877 0
BODY/TYBD 192130 0.995 192491 0.991 782 0
TRGR 11109604 0.999 11110414 0.994 56213 0
INDX 43480096 0.999 31475504 0.999 95 0
CLST 135248 0.986 182778 0.979 0 0
OBJE 0 0.000 0 0.000 0 0
PIPE 0 0.000 0 0.000 0 0
LOB 0 0.000 0 0.000 0 0
DIR 0 0.000 0 0.000 0 0
QUEU 0 0.000 0 0.000 0 0
OBJG 0 0.000 0 0.000 0 0
PROP 0 0.000 0 0.000 0 0
JVSC 0 0.000 0 0.000 0 0
JVRE 0 0.000 0 0.000 0 0
ROBJ 0 0.000 0 0.000 0 0
REIP 0 0.000 0 0.000 0 0
CPOB 0 0.000 0 0.000 0 0
EVNT 45498 0.995 419522 0.994 2254 0
SUMM 0 0.000 0 0.000 0 0
DIMN 0 0.000 0 0.000 0 0
CTX 0 0.000 0 0.000 0 0
OUTL 0 0.000 0 0.000 0 0
RULS 0 0.000 0 0.000 0 0
RMGR 0 0.000 0 0.000 0 0
IFSD 0 0.000 0 0.000 0 0
PPLN 0 0.000 0 0.000 0 0
PCLS 0 0.000 0 0.000 0 0
SUBS 0 0.000 0 0.000 0 0
LOCS 0 0.000 0 0.000 0 0
RMOB 0 0.000 0 0.000 0 0
RSMD 0 0.000 0 0.000 0 0
JVSD 173 0.925 8920 0.992 26 0
ENPR 0 0.000 0 0.000 0 0
RELC 0 0.000 0 0.000 0 0
STREAM 0 0.000 0 0.000 0 0
APPLY 0 0.000 0 0.000 0 0
APPLY SOURCE 0 0.000 0 0.000 0 0
APPLY DESTN 0 0.000 0 0.000 0 0
TEST 0 0.000 0 0.000 0 0
CUMULATIVE 452497052 0.994 1948116717 0.969 14135741 234305 Permanent space allocted for Load Locks
LATCH:0 TOTAL SPACE: 8496
FREELIST CHUNK COUNT:117 OBJECT SIZE:72
Permanent space allocted for KGL pins
LATCH:0 TOTAL SPACE: 1474176
FREELIST CHUNK COUNT:306 OBJECT SIZE:128
LATCH:1 TOTAL SPACE: 1444608
FREELIST CHUNK COUNT:332 OBJECT SIZE:128
LATCH:2 TOTAL SPACE: 1220736
FREELIST CHUNK COUNT:175 OBJECT SIZE:128
LATCH:3 TOTAL SPACE: 1575552
FREELIST CHUNK COUNT:314 OBJECT SIZE:128
LATCH:4 TOTAL SPACE: 1339008
FREELIST CHUNK COUNT:278 OBJECT SIZE:128
LATCH:5 TOTAL SPACE: 1068672
FREELIST CHUNK COUNT:205 OBJECT SIZE:128
LATCH:6 TOTAL SPACE: 1364352
FREELIST CHUNK COUNT:551 OBJECT SIZE:128
LATCH:7 TOTAL SPACE: 1571328
FREELIST CHUNK COUNT:1593 OBJECT SIZE:128
LATCH TOTAL SPACE: 1748736
FREELIST CHUNK COUNT:603 OBJECT SIZE:128
LATCH:9 TOTAL SPACE: 1854336
FREELIST CHUNK COUNT:212 OBJECT SIZE:128
LATCH:10 TOTAL SPACE: 988416
FREELIST CHUNK COUNT:380 OBJECT SIZE:128
LATCH:11 TOTAL SPACE: 1512192
FREELIST CHUNK COUNT:632 OBJECT SIZE:128
LATCH:12 TOTAL SPACE: 1119360
FREELIST CHUNK COUNT:149 OBJECT SIZE:128
LATCH:13 TOTAL SPACE: 1453056
FREELIST CHUNK COUNT:753 OBJECT SIZE:128
LATCH:14 TOTAL SPACE: 1968384
FREELIST CHUNK COUNT:693 OBJECT SIZE:128
LATCH:15 TOTAL SPACE: 1165824
FREELIST CHUNK COUNT:122 OBJECT SIZE:128
LATCH:16 TOTAL SPACE: 1748736
FREELIST CHUNK COUNT:284 OBJECT SIZE:128
LATCH:17 TOTAL SPACE: 1545984
FREELIST CHUNK COUNT:761 OBJECT SIZE:128
LATCH:18 TOTAL SPACE: 1491072
FREELIST CHUNK COUNT:1102 OBJECT SIZE:128
LATCH:19 TOTAL SPACE: 1419264
FREELIST CHUNK COUNT:321 OBJECT SIZE:128
LATCH:20 TOTAL SPACE: 1634688
FREELIST CHUNK COUNT:1731 OBJECT SIZE:128
LATCH:21 TOTAL SPACE: 865920
FREELIST CHUNK COUNT:229 OBJECT SIZE:128
LATCH:22 TOTAL SPACE: 1216512
FREELIST CHUNK COUNT:408 OBJECT SIZE:128
LATCH:23 TOTAL SPACE: 1554432
FREELIST CHUNK COUNT:156 OBJECT SIZE:128
LATCH:24 TOTAL SPACE: 925056
FREELIST CHUNK COUNT:472 OBJECT SIZE:128
LATCH:25 TOTAL SPACE: 1655808
FREELIST CHUNK COUNT:381 OBJECT SIZE:128
LATCH:26 TOTAL SPACE: 1199616
FREELIST CHUNK COUNT:186 OBJECT SIZE:128
LATCH:27 TOTAL SPACE: 1398144
FREELIST CHUNK COUNT:669 OBJECT SIZE:128
LATCH:28 TOTAL SPACE: 1858560
FREELIST CHUNK COUNT:2853 OBJECT SIZE:128
Permanent space allocted for KGL locks
LATCH:0 TOTAL SPACE: 1880336
FREELIST CHUNK COUNT:430 OBJECT SIZE:136
LATCH:1 TOTAL SPACE: 1838176
FREELIST CHUNK COUNT:473 OBJECT SIZE:136
LATCH:2 TOTAL SPACE: 1555704
FREELIST CHUNK COUNT:244 OBJECT SIZE:136
LATCH:3 TOTAL SPACE: 2103784
FREELIST CHUNK COUNT:1109 OBJECT SIZE:136
LATCH:4 TOTAL SPACE: 1732776
FREELIST CHUNK COUNT:365 OBJECT SIZE:136
LATCH:5 TOTAL SPACE: 1450304
FREELIST CHUNK COUNT:309 OBJECT SIZE:136
LATCH:6 TOTAL SPACE: 1964656
FREELIST CHUNK COUNT:940 OBJECT SIZE:136
LATCH:7 TOTAL SPACE: 2234480
FREELIST CHUNK COUNT:2800 OBJECT SIZE:136
LATCH TOTAL SPACE: 2167024
FREELIST CHUNK COUNT71 OBJECT SIZE:136
LATCH:9 TOTAL SPACE: 2276640
FREELIST CHUNK COUNT:476 OBJECT SIZE:136
LATCH:10 TOTAL SPACE: 1290096
FREELIST CHUNK COUNT:492 OBJECT SIZE:136
LATCH:11 TOTAL SPACE: 2086920
FREELIST CHUNK COUNT:1504 OBJECT SIZE:136
LATCH:12 TOTAL SPACE: 1484032
FREELIST CHUNK COUNT:135 OBJECT SIZE:136
LATCH:13 TOTAL SPACE: 1964656
FREELIST CHUNK COUNT:1070 OBJECT SIZE:136
LATCH:14 TOTAL SPACE: 2626568
FREELIST CHUNK COUNT:1347 OBJECT SIZE:136
LATCH:15 TOTAL SPACE: 1429224
FREELIST CHUNK COUNT:353 OBJECT SIZE:136
LATCH:16 TOTAL SPACE: 2129080
FREELIST CHUNK COUNT:424 OBJECT SIZE:136
LATCH:17 TOTAL SPACE: 2200752
FREELIST CHUNK COUNT:1544 OBJECT SIZE:136
LATCH:18 TOTAL SPACE: 2268208
FREELIST CHUNK COUNT:1941 OBJECT SIZE:136
LATCH:19 TOTAL SPACE: 1787584
FREELIST CHUNK COUNT:376 OBJECT SIZE:136
LATCH:20 TOTAL SPACE: 2436848
FREELIST CHUNK COUNT:2741 OBJECT SIZE:136
LATCH:21 TOTAL SPACE: 1306960
FREELIST CHUNK COUNT:768 OBJECT SIZE:136
LATCH:22 TOTAL SPACE: 1581000
FREELIST CHUNK COUNT:595 OBJECT SIZE:136
LATCH:23 TOTAL SPACE: 1935144
FREELIST CHUNK COUNT:179 OBJECT SIZE:136
LATCH:24 TOTAL SPACE: 1315392
FREELIST CHUNK COUNT:725 OBJECT SIZE:136
LATCH:25 TOTAL SPACE: 2133296
FREELIST CHUNK COUNT:630 OBJECT SIZE:136
LATCH:26 TOTAL SPACE: 1585216
FREELIST CHUNK COUNT:416 OBJECT SIZE:136
LATCH:27 TOTAL SPACE: 1842392
FREELIST CHUNK COUNT:1254 OBJECT SIZE:136
LATCH:28 TOTAL SPACE: 2820504
FREELIST CHUNK COUNT:4888 OBJECT SIZE:136
Permanent space allocted for KGL S handles
LATCH:0 TOTAL SPACE: 106424
FREELIST CHUNK COUNT:133 OBJECT SIZE:424
LATCH:1 TOTAL SPACE: 71656
FREELIST CHUNK COUNT:60 OBJECT SIZE:424
LATCH:2 TOTAL SPACE: 71232
FREELIST CHUNK COUNT:51 OBJECT SIZE:424
LATCH:3 TOTAL SPACE: 63176
FREELIST CHUNK COUNT:48 OBJECT SIZE:424
LATCH:4 TOTAL SPACE: 111088
FREELIST CHUNK COUNT:132 OBJECT SIZE:424
LATCH:5 TOTAL SPACE: 72928
FREELIST CHUNK COUNT:54 OBJECT SIZE:424
LATCH:6 TOTAL SPACE: 115752
FREELIST CHUNK COUNT:153 OBJECT SIZE:424
LATCH:7 TOTAL SPACE: 64872
FREELIST CHUNK COUNT:59 OBJECT SIZE:424
LATCH:8 TOTAL SPACE: 70808
FREELIST CHUNK COUNT:48 OBJECT SIZE:424
LATCH:9 TOTAL SPACE: 67416
FREELIST CHUNK COUNT:61 OBJECT SIZE:424
LATCH:10 TOTAL SPACE: 116600
FREELIST CHUNK COUNT:135 OBJECT SIZE:424
LATCH:11 TOTAL SPACE: 67416
FREELIST CHUNK COUNT:51 OBJECT SIZE:424
LATCH:12 TOTAL SPACE: 107272
FREELIST CHUNK COUNT:146 OBJECT SIZE:424
LATCH:13 TOTAL SPACE: 61904
FREELIST CHUNK COUNT:59 OBJECT SIZE:424
LATCH:14 TOTAL SPACE: 61480
FREELIST CHUNK COUNT:51 OBJECT SIZE:424
LATCH:15 TOTAL SPACE: 66992
FREELIST CHUNK COUNT:48 OBJECT SIZE:424
LATCH:16 TOTAL SPACE: 116176
FREELIST CHUNK COUNT:140 OBJECT SIZE:424
LATCH:17 TOTAL SPACE: 80136
FREELIST CHUNK COUNT:67 OBJECT SIZE:424
LATCH:18 TOTAL SPACE: 109392
FREELIST CHUNK COUNT:138 OBJECT SIZE:424
LATCH:19 TOTAL SPACE: 71232
FREELIST CHUNK COUNT:62 OBJECT SIZE:424
LATCH:20 TOTAL SPACE: 59784
FREELIST CHUNK COUNT:57 OBJECT SIZE:424
LATCH:21 TOTAL SPACE: 66568
FREELIST CHUNK COUNT:62 OBJECT SIZE:424
LATCH:22 TOTAL SPACE: 111512
FREELIST CHUNK COUNT:142 OBJECT SIZE:424
LATCH:23 TOTAL SPACE: 72928
FREELIST CHUNK COUNT:65 OBJECT SIZE:424
LATCH:24 TOTAL SPACE: 113208
FREELIST CHUNK COUNT:152 OBJECT SIZE:424
LATCH:25 TOTAL SPACE: 72504
FREELIST CHUNK COUNT:47 OBJECT SIZE:424
LATCH:26 TOTAL SPACE: 78016
FREELIST CHUNK COUNT:52 OBJECT SIZE:424
LATCH:27 TOTAL SPACE: 66568
FREELIST CHUNK COUNT:54 OBJECT SIZE:424
LATCH:28 TOTAL SPACE: 111936
FREELIST CHUNK COUNT:143 OBJECT SIZE:424
Permanent space allocted for KGL M handles
LATCH:0 TOTAL SPACE: 136136
FREELIST CHUNK COUNT:122 OBJECT SIZE:616
LATCH:1 TOTAL SPACE: 81928
FREELIST CHUNK COUNT:49 OBJECT SIZE:616
LATCH:2 TOTAL SPACE: 78232
FREELIST CHUNK COUNT:57 OBJECT SIZE:616
LATCH:3 TOTAL SPACE: 88088
FREELIST CHUNK COUNT:48 OBJECT SIZE:616
LATCH:4 TOTAL SPACE: 203896
FREELIST CHUNK COUNT:164 OBJECT SIZE:616
LATCH:5 TOTAL SPACE: 94248
FREELIST CHUNK COUNT:61 OBJECT SIZE:616
LATCH:6 TOTAL SPACE: 132440
FREELIST CHUNK COUNT:118 OBJECT SIZE:616
LATCH:7 TOTAL SPACE: 76384
FREELIST CHUNK COUNT:43 OBJECT SIZE:616
LATCH:8 TOTAL SPACE: 94248
FREELIST CHUNK COUNT:50 OBJECT SIZE:616
LATCH:9 TOTAL SPACE: 85008
FREELIST CHUNK COUNT:63 OBJECT SIZE:616
LATCH:10 TOTAL SPACE: 191576
FREELIST CHUNK COUNT:163 OBJECT SIZE:616
LATCH:11 TOTAL SPACE: 90552
FREELIST CHUNK COUNT:54 OBJECT SIZE:616
LATCH:12 TOTAL SPACE: 134904
FREELIST CHUNK COUNT:126 OBJECT SIZE:616
LATCH:13 TOTAL SPACE: 121352
FREELIST CHUNK COUNT:62 OBJECT SIZE:616
LATCH:14 TOTAL SPACE: 86856
FREELIST CHUNK COUNT:56 OBJECT SIZE:616
LATCH:15 TOTAL SPACE: 75152
FREELIST CHUNK COUNT:59 OBJECT SIZE:616
LATCH:16 TOTAL SPACE: 189112
FREELIST CHUNK COUNT:160 OBJECT SIZE:616
LATCH:17 TOTAL SPACE: 104104
FREELIST CHUNK COUNT:52 OBJECT SIZE:616
LATCH:18 TOTAL SPACE: 147224
FREELIST CHUNK COUNT:121 OBJECT SIZE:616
LATCH:19 TOTAL SPACE: 92400
FREELIST CHUNK COUNT:55 OBJECT SIZE:616
LATCH:20 TOTAL SPACE: 110880
FREELIST CHUNK COUNT:53 OBJECT SIZE:616
LATCH:21 TOTAL SPACE: 83160
FREELIST CHUNK COUNT:55 OBJECT SIZE:616
LATCH:22 TOTAL SPACE: 194656
FREELIST CHUNK COUNT:159 OBJECT SIZE:616
LATCH:23 TOTAL SPACE: 133672
FREELIST CHUNK COUNT:57 OBJECT SIZE:616
LATCH:24 TOTAL SPACE: 185416
FREELIST CHUNK COUNT:203 OBJECT SIZE:616
LATCH:25 TOTAL SPACE: 122584
FREELIST CHUNK COUNT:58 OBJECT SIZE:616
LATCH:26 TOTAL SPACE: 93632
FREELIST CHUNK COUNT:45 OBJECT SIZE:616
LATCH:27 TOTAL SPACE: 100408
FREELIST CHUNK COUNT:51 OBJECT SIZE:616
LATCH:28 TOTAL SPACE: 202664
FREELIST CHUNK COUNT:139 OBJECT SIZE:616
Permanent space allocted for KGL L handles
LATCH:0 TOTAL SPACE: 74992
FREELIST CHUNK COUNT:56 OBJECT SIZE:872
LATCH:1 TOTAL SPACE: 61040
FREELIST CHUNK COUNT:51 OBJECT SIZE:872
LATCH:2 TOTAL SPACE: 61040
FREELIST CHUNK COUNT:57 OBJECT SIZE:872
LATCH:3 TOTAL SPACE: 76736
FREELIST CHUNK COUNT:41 OBJECT SIZE:872
LATCH:4 TOTAL SPACE: 69760
FREELIST CHUNK COUNT:46 OBJECT SIZE:872
LATCH:5 TOTAL SPACE: 64528
FREELIST CHUNK COUNT:56 OBJECT SIZE:872
LATCH:6 TOTAL SPACE: 68016
FREELIST CHUNK COUNT:50 OBJECT SIZE:872
LATCH:7 TOTAL SPACE: 58424
FREELIST CHUNK COUNT:52 OBJECT SIZE:872
LATCH:8 TOTAL SPACE: 64528
FREELIST CHUNK COUNT:42 OBJECT SIZE:872
LATCH:9 TOTAL SPACE: 72376
FREELIST CHUNK COUNT:53 OBJECT SIZE:872
LATCH:10 TOTAL SPACE: 62784
FREELIST CHUNK COUNT:42 OBJECT SIZE:872
LATCH:11 TOTAL SPACE: 71504
FREELIST CHUNK COUNT:51 OBJECT SIZE:872
LATCH:12 TOTAL SPACE: 75864
FREELIST CHUNK COUNT:45 OBJECT SIZE:872
LATCH:13 TOTAL SPACE: 58424
FREELIST CHUNK COUNT:39 OBJECT SIZE:872
LATCH:14 TOTAL SPACE: 58424
FREELIST CHUNK COUNT:51 OBJECT SIZE:872
LATCH:15 TOTAL SPACE: 56680
FREELIST CHUNK COUNT:50 OBJECT SIZE:872
LATCH:16 TOTAL SPACE: 62784
FREELIST CHUNK COUNT:45 OBJECT SIZE:872
LATCH:17 TOTAL SPACE: 64528
FREELIST CHUNK COUNT:50 OBJECT SIZE:872
LATCH:18 TOTAL SPACE: 74120
FREELIST CHUNK COUNT:58 OBJECT SIZE:872
LATCH:19 TOTAL SPACE: 58424
FREELIST CHUNK COUNT:42 OBJECT SIZE:872
LATCH:20 TOTAL SPACE: 77608
FREELIST CHUNK COUNT:47 OBJECT SIZE:872
LATCH:21 TOTAL SPACE: 63656
FREELIST CHUNK COUNT:53 OBJECT SIZE:872
LATCH:22 TOTAL SPACE: 61040
FREELIST CHUNK COUNT:51 OBJECT SIZE:872
LATCH:23 TOTAL SPACE: 70632
FREELIST CHUNK COUNT:54 OBJECT SIZE:872
LATCH:24 TOTAL SPACE: 74992
FREELIST CHUNK COUNT:47 OBJECT SIZE:872
LATCH:25 TOTAL SPACE: 63656
FREELIST CHUNK COUNT:41 OBJECT SIZE:872
LATCH:26 TOTAL SPACE: 74992
FREELIST CHUNK COUNT:56 OBJECT SIZE:872
LATCH:27 TOTAL SPACE: 65400
FREELIST CHUNK COUNT:51 OBJECT SIZE:872
LATCH:28 TOTAL SPACE: 66272
FREELIST CHUNK COUNT:48 OBJECT SIZE:872
Permanent space allocted for KGL A handles
LATCH:0 TOTAL SPACE: 9956448
FREELIST CHUNK COUNT:159 OBJECT SIZE:288
LATCH:1 TOTAL SPACE: 3648960
FREELIST CHUNK COUNT:97 OBJECT SIZE:288
LATCH:2 TOTAL SPACE: 6349824
FREELIST CHUNK COUNT:2 OBJECT SIZE:288
LATCH:3 TOTAL SPACE: 22706784
FREELIST CHUNK COUNT:21 OBJECT SIZE:288
LATCH:4 TOTAL SPACE: 11263392
FREELIST CHUNK COUNT:54 OBJECT SIZE:288
LATCH:5 TOTAL SPACE: 5281920
FREELIST CHUNK COUNT:3 OBJECT SIZE:288
LATCH:6 TOTAL SPACE: 9265824
FREELIST CHUNK COUNT:231 OBJECT SIZE:288
LATCH:7 TOTAL SPACE: 2805120
FREELIST CHUNK COUNT:32 OBJECT SIZE:288
LATCH:8 TOTAL SPACE: 9475488
FREELIST CHUNK COUNT:267 OBJECT SIZE:288
LATCH:9 TOTAL SPACE: 11640672
FREELIST CHUNK COUNT:1 OBJECT SIZE:288
LATCH:10 TOTAL SPACE: 6567840
FREELIST CHUNK COUNT:140 OBJECT SIZE:288
LATCH:11 TOTAL SPACE: 7216704
FREELIST CHUNK COUNT:0 OBJECT SIZE:288
LATCH:12 TOTAL SPACE: 7951968
FREELIST CHUNK COUNT:63 OBJECT SIZE:288
LATCH:13 TOTAL SPACE: 19990080
FREELIST CHUNK COUNT:173 OBJECT SIZE:288
LATCH:14 TOTAL SPACE: 6567552
FREELIST CHUNK COUNT:88 OBJECT SIZE:288
LATCH:15 TOTAL SPACE: 5192352
FREELIST CHUNK COUNT:2 OBJECT SIZE:288
LATCH:16 TOTAL SPACE: 8553312
FREELIST CHUNK COUNT:73 OBJECT SIZE:288
LATCH:17 TOTAL SPACE: 12140352
FREELIST CHUNK COUNT:211 OBJECT SIZE:288
LATCH:18 TOTAL SPACE: 16345728
FREELIST CHUNK COUNT:176 OBJECT SIZE:288
LATCH:19 TOTAL SPACE: 9533664
FREELIST CHUNK COUNT:3 OBJECT SIZE:288
LATCH:20 TOTAL SPACE: 22050432
FREELIST CHUNK COUNT:214 OBJECT SIZE:288
LATCH:21 TOTAL SPACE: 9041472
FREELIST CHUNK COUNT:44 OBJECT SIZE:288
LATCH:22 TOTAL SPACE: 10861920
FREELIST CHUNK COUNT:267 OBJECT SIZE:288
LATCH:23 TOTAL SPACE: 22398624
FREELIST CHUNK COUNT:78 OBJECT SIZE:288
LATCH:24 TOTAL SPACE: 10543968
FREELIST CHUNK COUNT:100 OBJECT SIZE:288
LATCH:25 TOTAL SPACE: 21098304
FREELIST CHUNK COUNT:272 OBJECT SIZE:288
LATCH:26 TOTAL SPACE: 20370240
FREELIST CHUNK COUNT:208 OBJECT SIZE:288
LATCH:27 TOTAL SPACE: 21414240
FREELIST CHUNK COUNT:3 OBJECT SIZE:288
LATCH:28 TOTAL SPACE: 15977088
FREELIST CHUNK COUNT:0 OBJECT SIZE:288
Permanent space allocted for KGL objects
LATCH:0 TOTAL SPACE: 141696
FREELIST CHUNK COUNT:383 OBJECT SIZE:144
LATCH:1 TOTAL SPACE: 65952
FREELIST CHUNK COUNT:45 OBJECT SIZE:144
LATCH:2 TOTAL SPACE: 81648
FREELIST CHUNK COUNT:54 OBJECT SIZE:144
LATCH:3 TOTAL SPACE: 92880
FREELIST CHUNK COUNT:58 OBJECT SIZE:144
LATCH:4 TOTAL SPACE: 131184
FREELIST CHUNK COUNT:431 OBJECT SIZE:144
LATCH:5 TOTAL SPACE: 77472
FREELIST CHUNK COUNT:103 OBJECT SIZE:144
LATCH:6 TOTAL SPACE: 136368
FREELIST CHUNK COUNT:379 OBJECT SIZE:144
LATCH:7 TOTAL SPACE: 64080
FREELIST CHUNK COUNT:34 OBJECT SIZE:144
LATCH:8 TOTAL SPACE: 84240
FREELIST CHUNK COUNT:45 OBJECT SIZE:144
LATCH:9 TOTAL SPACE: 61920
FREELIST CHUNK COUNT:48 OBJECT SIZE:144
LATCH:10 TOTAL SPACE: 125424
FREELIST CHUNK COUNT:363 OBJECT SIZE:144
LATCH:11 TOTAL SPACE: 101232
FREELIST CHUNK COUNT:88 OBJECT SIZE:144
LATCH:12 TOTAL SPACE: 137664
FREELIST CHUNK COUNT:363 OBJECT SIZE:144
LATCH:13 TOTAL SPACE: 100224
FREELIST CHUNK COUNT:4 OBJECT SIZE:144
LATCH:14 TOTAL SPACE: 68256
FREELIST CHUNK COUNT:39 OBJECT SIZE:144
LATCH:15 TOTAL SPACE: 47952
FREELIST CHUNK COUNT:46 OBJECT SIZE:144
LATCH:16 TOTAL SPACE: 127440
FREELIST CHUNK COUNT:402 OBJECT SIZE:144
LATCH:17 TOTAL SPACE: 102240
FREELIST CHUNK COUNT:105 OBJECT SIZE:144
LATCH:18 TOTAL SPACE: 172944
FREELIST CHUNK COUNT:356 OBJECT SIZE:144
LATCH:19 TOTAL SPACE: 70128
FREELIST CHUNK COUNT:34 OBJECT SIZE:144
LATCH:20 TOTAL SPACE: 105696
FREELIST CHUNK COUNT:42 OBJECT SIZE:144
LATCH:21 TOTAL SPACE: 61488
FREELIST CHUNK COUNT:51 OBJECT SIZE:144
LATCH:22 TOTAL SPACE: 127872
FREELIST CHUNK COUNT:430 OBJECT SIZE:144
LATCH:23 TOTAL SPACE: 142992
FREELIST CHUNK COUNT:51 OBJECT SIZE:144
LATCH:24 TOTAL SPACE: 132192
FREELIST CHUNK COUNT:412 OBJECT SIZE:144
LATCH:25 TOTAL SPACE: 106128
FREELIST CHUNK COUNT:63 OBJECT SIZE:144
LATCH:26 TOTAL SPACE: 117792
FREELIST CHUNK COUNT:2 OBJECT SIZE:144
LATCH:27 TOTAL SPACE: 72432
FREELIST CHUNK COUNT:56 OBJECT SIZE:144
LATCH:28 TOTAL SPACE: 142992
FREELIST CHUNK COUNT:163 OBJECT SIZE:144
Permanent space allocted for KGL handle dependents
LATCH:0 TOTAL SPACE: 127368
FREELIST CHUNK COUNT:89 OBJECT SIZE:696
LATCH:1 TOTAL SPACE: 99528
FREELIST CHUNK COUNT:47 OBJECT SIZE:696
LATCH:2 TOTAL SPACE: 100224
FREELIST CHUNK COUNT:49 OBJECT SIZE:696
LATCH:3 TOTAL SPACE: 104400
FREELIST CHUNK COUNT:56 OBJECT SIZE:696
LATCH:4 TOTAL SPACE: 131544
FREELIST CHUNK COUNT:94 OBJECT SIZE:696
LATCH:5 TOTAL SPACE: 106488
FREELIST CHUNK COUNT:53 OBJECT SIZE:696
LATCH:6 TOTAL SPACE: 143376
FREELIST CHUNK COUNT:97 OBJECT SIZE:696
LATCH:7 TOTAL SPACE: 100224
FREELIST CHUNK COUNT:56 OBJECT SIZE:696
LATCH:8 TOTAL SPACE: 111360
FREELIST CHUNK COUNT:52 OBJECT SIZE:696
LATCH:9 TOTAL SPACE: 107184
FREELIST CHUNK COUNT:55 OBJECT SIZE:696
LATCH:10 TOTAL SPACE: 134328
FREELIST CHUNK COUNT:94 OBJECT SIZE:696
LATCH:11 TOTAL SPACE: 94656
FREELIST CHUNK COUNT:51 OBJECT SIZE:696
LATCH:12 TOTAL SPACE: 132240
FREELIST CHUNK COUNT:100 OBJECT SIZE:696
LATCH:13 TOTAL SPACE: 86304
FREELIST CHUNK COUNT:49 OBJECT SIZE:696
LATCH:14 TOTAL SPACE: 96048
FREELIST CHUNK COUNT:49 OBJECT SIZE:696
LATCH:15 TOTAL SPACE: 105792
FREELIST CHUNK COUNT:50 OBJECT SIZE:696
LATCH:16 TOTAL SPACE: 146160
FREELIST CHUNK COUNT:107 OBJECT SIZE:696
LATCH:17 TOTAL SPACE: 104400
FREELIST CHUNK COUNT:54 OBJECT SIZE:696
LATCH:18 TOTAL SPACE: 125976
FREELIST CHUNK COUNT:90 OBJECT SIZE:696
LATCH:19 TOTAL SPACE: 102312
FREELIST CHUNK COUNT:59 OBJECT SIZE:696
LATCH:20 TOTAL SPACE: 89784
FREELIST CHUNK COUNT:50 OBJECT SIZE:696
LATCH:21 TOTAL SPACE: 96744
FREELIST CHUNK COUNT:54 OBJECT SIZE:696
LATCH:22 TOTAL SPACE: 133632
FREELIST CHUNK COUNT:106 OBJECT SIZE:696
LATCH:23 TOTAL SPACE: 114144
FREELIST CHUNK COUNT:55 OBJECT SIZE:696
LATCH:24 TOTAL SPACE: 133632
FREELIST CHUNK COUNT:104 OBJECT SIZE:696
LATCH:25 TOTAL SPACE: 119712
FREELIST CHUNK COUNT:59 OBJECT SIZE:696
LATCH:26 TOTAL SPACE: 96744
FREELIST CHUNK COUNT:48 OBJECT SIZE:696
LATCH:27 TOTAL SPACE: 103704
FREELIST CHUNK COUNT:55 OBJECT SIZE:696
LATCH:28 TOTAL SPACE: 141288
FREELIST CHUNK COUNT:101 OBJECT SIZE:696
Did Not dump SGA Heap desc=700000000000058
Current time: 10/19/2007 08:28:31
Last heap dump at 10/19/2007 08:24:03
===============================
End 4031 Diagnostic Information
===============================
=================================================
KGL Latch 9 Level 4 latch clean-up information:
=================================================
Operation = 0
kgllcpt1 = 0 kgllcpt2 = 0
kgllcpt3 = 0 kgllcpt4 = 0
kgllcub4 = 0
=================================================
KGL Latch 9 Level 3 latch clean-up information:
=================================================
Operation = 0
kgllcpt1 = 0 kgllcpt2 = 0
kgllcpt3 = 0 kgllcpt4 = 0
kgllcub4 = 0
=================================================
KGL Latch 9 Level 2 latch clean-up information:
=================================================
Operation = 0
kgllcpt1 = d5a41748 kgllcpt2 = 0
kgllcpt3 = 0 kgllcpt4 = a79a8fd8
kgllcub4 = 1
=================================================
KGL Latch 9 Level 1 latch clean-up information:
=================================================
Operation = 0
kgllcpt1 = 0 kgllcpt2 = 0
kgllcpt3 = 0 kgllcpt4 = 7e8e5790
kgllcub4 = 9
=================================================
KGL Latch 9 Level 0 latch clean-up information:
=================================================
Operation = 0
kgllcpt1 = c3aed5c8 kgllcpt2 = d54bfed8
kgllcpt3 = 0 kgllcpt4 = 0
kgllcub4 = 9
*** 2007-10-19 08:28:31.728
SMON: following errors trapped and ignored:
ORA-00604: error occurred at recursive SQL level 2
ORA-04031: unable to allocate 4160 bytes of shared memory ("shared pool","SMON_SCN_TIME","sga heap(2,0)","kglsim heap")
*** 2007-10-19 08:50:49.214
SMON offlining US=11
页:
[1]