Shared pool "knlu_mt_insert_btree - 10"

From: Biju Thomas <biju.thomas_at_gmail.com>
Date: Tue, 18 Nov 2014 12:57:59 -0600
Message-ID: <CAF9tyKp6E0HQSsWyiLj2OKvaT527fRqrW6KFRAoOtWLPkGP71g_at_mail.gmail.com>

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

--

http://www.freelists.org/webpage/oracle-l Received on Tue Nov 18 2014 - 19:57:59 CET