{"id":13100,"date":"2024-02-27T14:09:53","date_gmt":"2024-02-27T13:09:53","guid":{"rendered":"https:\/\/roglacup.com\/klaus62\/?p=13100"},"modified":"2024-02-27T15:23:35","modified_gmt":"2024-02-27T14:23:35","slug":"oracle-initialization-parameters","status":"publish","type":"post","link":"https:\/\/roglacup.com\/klaus62\/2024\/02\/27\/oracle-initialization-parameters\/","title":{"rendered":"Oracle initialization parameters"},"content":{"rendered":"\n

resource_limit=true<\/strong><\/p>\n\n\n\n

RESOURCE_LIMIT\u201d parameter is used to enable\/disable \u201cKERNEL\u201d resource type profiles. Password parameters are part of profiles but they are controlled by this parameter. This parameter is a SYSTEM level parameter so it can be changed using \u201cALTER SYSTEM\u201d and can be changed on the fly. Possible values are true\/false and the default value is false.<\/p>\n\n\n\n

Example: To set resource_limit
sys@TESTDB> alter system set resource_limit = true scope=both;<\/p>\n\n\n\n

System altered.<\/p>\n\n\n\n

Example: Creates a profile and sets one_session limit to 1 and assigned the profile to scott
scott@TESTDB> create profile one_session limit sessions_per_user 1;<\/p>\n\n\n\n

Profile created.<\/p>\n\n\n\n

Posted from: https:\/\/oraclespin.com\/2011\/05\/01\/information-on-resource_limit-parameter\/<\/a><\/p>\n\n\n\n

Posted from: https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/21\/refrn\/OPTIMIZER_MODE.html#GUID-DE448A8A-992F-4BAB-9302-A020039641E5<\/a><\/p>\n\n\n\n

audit_trail=db
Posted from:https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/21\/refrn\/AUDIT_TRAIL.html#GUID-BD86F593-B606-4367-9FB6-8DAB2E47E7FA<\/a><\/p>\n\n\n\n

audit_sys_operations=true
https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/21\/refrn\/AUDIT_SYS_OPERATIONS.html#GUID-58176267-238C-40B5-B1F2-BB8BB9518950<\/a><\/p>\n\n\n\n

open_cursors= number<\/p>\n\n\n\n

Posted from: https:\/\/blogs.oracle.com\/connect\/post\/working-with-cursors#:~:text=A%20cursor%20is%20a%20pointer,%2C%20DELETE%2C%20or%20MERGE).<\/a><\/p>\n\n\n\n

\u00a0optimizer_mode=choose<\/p>\n\n\n\n

<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Posted from: https:\/\/tipsfororacle.blogspot.com\/search?q=optimizer<\/a><\/p>\n\n\n\n

optimizer_index_cost_adj = number<\/p>\n\n\n\n

Posted from: https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/21\/refrn\/OPTIMIZER_INDEX_COST_ADJ.html#GUID-BA25DBA7-3826-48CA-849B-6D8E3326A1B4<\/a><\/p>\n\n\n\n

optimizer_index_caching=number<\/p>\n\n\n\n

Posted from: https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/21\/refrn\/OPTIMIZER_INDEX_CACHING.html#GUID-1601D366-1637-4235-98F6-57B4B7AD96D0<\/a><\/p>\n\n\n\n

OPTIMIZER_FEATURES_ENABLE<\/p>\n\n\n\n

Posted from: https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/21\/refrn\/OPTIMIZER_FEATURES_ENABLE.html#GUID-E193EC9E-B642-4C01-99EC-24E04AEA1A2C<\/a><\/p>\n\n\n\n

<\/p>\n\n\n\n

session_cached_cursors=200<\/p>\n\n\n\n

\u0160tevilo prostora v predpomnilniku<\/p>\n\n\n\n

Posted from: https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/21\/refrn\/SESSION_CACHED_CURSORS.html#GUID-E4FC0260-3C8A-4379-8143-6A4E6EE27A2F<\/a><\/p>\n\n\n\n

compatible=19.x.x.x<\/p>\n\n\n\n

Posted from: https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/21\/refrn\/COMPATIBLE.html#GUID-6C57EE11-BD06-4BB8-A0F7-D6CDDD086FA9<\/a><\/p>\n\n\n\n

max_dump_file_size=’10m’<\/p>\n\n\n\n

Posted from: https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/21\/refrn\/MAX_DUMP_FILE_SIZE.html#GUID-C58CF881-8233-4C73-B1F2-56F76BBC4469<\/a><\/p>\n\n\n\n\n\n

Posted from: https:\/\/sqljana.wordpress.com\/2017\/01\/24\/oracle-undo-a-basic-explanation\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

resource_limit=true RESOURCE_LIMIT\u201d parameter is used to enable\/disable \u201cKERNEL\u201d resource type profiles. Password parameters are part of profiles but they are controlled by this parameter. This parameter is a SYSTEM level parameter so it can be changed using \u201cALTER SYSTEM\u201d and can be changed on the fly. Possible values are true\/false and the default value is… Read More »Oracle initialization parameters<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":13105,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","footnotes":""},"categories":[1047,35,399],"tags":[],"class_list":["post-13100","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle-it-vendors","category-oracle","category-wordpress"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/posts\/13100","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/comments?post=13100"}],"version-history":[{"count":8,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/posts\/13100\/revisions"}],"predecessor-version":[{"id":13116,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/posts\/13100\/revisions\/13116"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/media\/13105"}],"wp:attachment":[{"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/media?parent=13100"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/categories?post=13100"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/tags?post=13100"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}