Shared pool "knlu_mt_insert_btree - 10"
- From: Biju Thomas <biju.thomas@xxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 18 Nov 2014 12:57:59 -0600
One of the production databases show steady growth of "knlu_mt_insert_btree
- 10" area in the shared pool. I could not find much information on how
this area is used or what makes it grow.
Incidentally, this growth was noticed after fixing a CDC (Streams / Change
Data Capture) issue with the following setting:
exec dbms_capture_adm.set_parameter('<Change_set>',
'message_tracking_frequency', '1')
Are these related?
Database version: 11.2.0.3
OS Version: Solaris SPARC 64-bit
Automatic Shared Memory Management used.
SQL> show parameter target
NAME TYPE VALUE
------------------------------------ -----------
------------------------------
memory_target big integer 0
pga_aggregate_target big integer 4G
sga_target big integer 64G
SQL> show parameter pool
NAME TYPE VALUE
------------------------------------ -----------
------------------------------
java_pool_size big integer 128M
large_pool_size big integer 0
olap_page_pool_size big integer 4M
shared_pool_reserved_size big integer 248302796
shared_pool_size big integer 20G
streams_pool_size big integer 2G
SQL> select * from v$sga
SQL> /
NAME VALUE
-------------------- ----------------------
Fixed Size 2176432
Variable Size 26306677328
Database Buffers 42010148864
Redo Buffers 114130944
SQL> select * from v$sgastat
2 where bytes > 104857600
3* order by pool, bytes desc
SQL> /
POOL NAME BYTES
------------ -------------------------- ----------------------
java pool free memory 888579776
large pool free memory 121167840
shared pool free memory 11206749712
shared pool SQLA 4894263664
shared pool KGLH0 2048385472
shared pool knlu_mt_insert_btree - 10 1959893368
shared pool KQR M PO 381901568
shared pool db_block_hash_buckets 373297152
shared pool KGLHD 348209208
shared pool KKSSP 150372568
shared pool KGLS 127196296
shared pool flashback generation buff 117440512
shared pool SQLP 107502792
streams pool free memory 1225127360
streams pool apply shared t 788198040
buffer_cache 42010148864
log_buffer 114130944
Database was restarted only couple of days ago. Before the database cycle,
the knlu_mt_insert_btree pool was over 7GB.
Thanks in advance...
Biju
Other related posts:
