{"id":386,"date":"2016-07-07T09:55:35","date_gmt":"2016-07-07T07:55:35","guid":{"rendered":"http:\/\/jal-bs.de\/blog\/?p=386"},"modified":"2016-11-03T13:41:42","modified_gmt":"2016-11-03T12:41:42","slug":"big-tables-12-1-0-2-db_big_table_cache_percent_target","status":"publish","type":"post","link":"https:\/\/jal-bs.de\/blog\/?p=386","title":{"rendered":"Big Tables (12.1.0.2): DB_BIG_TABLE_CACHE_PERCENT_TARGET"},"content":{"rendered":"<p>Dieser in 12.1.0.2 neue dynamische Parameter reserviert einen gewissen Teil des &#8222;Buffer Caches&#8220; f\u00fcr die Speicherung gro\u00dfer Objekte (oder Teile davon).<\/p>\n<p>Beispiel:<\/p>\n<p>ALTER SYSTEM SET db_big_table_cache_percent_target=40;<\/p>\n<p>Mit der View v$bt_scan_cache lassen sich Informationen zur Verwendung und Konfiguration auslesen.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Dieser in 12.1.0.2 neue dynamische Parameter reserviert einen gewissen Teil des &#8222;Buffer Caches&#8220; f\u00fcr die Speicherung gro\u00dfer Objekte (oder Teile davon). Beispiel: ALTER SYSTEM SET db_big_table_cache_percent_target=40; Mit der View v$bt_scan_cache lassen sich Informationen zur Verwendung und Konfiguration auslesen.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[33,18],"_links":{"self":[{"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=\/wp\/v2\/posts\/386"}],"collection":[{"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=386"}],"version-history":[{"count":4,"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=\/wp\/v2\/posts\/386\/revisions"}],"predecessor-version":[{"id":391,"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=\/wp\/v2\/posts\/386\/revisions\/391"}],"wp:attachment":[{"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=386"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=386"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=386"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}