{"id":7327,"date":"2021-06-23T14:38:27","date_gmt":"2021-06-23T14:38:27","guid":{"rendered":"https:\/\/www.gologica.com\/elearning\/?p=7327"},"modified":"2025-04-07T10:26:47","modified_gmt":"2025-04-07T10:26:47","slug":"how-oracle-locally-managed-tablespace","status":"publish","type":"post","link":"https:\/\/www.gologica.com\/elearning\/how-oracle-locally-managed-tablespace\/","title":{"rendered":"How Oracle Locally Managed Tablespace ?"},"content":{"rendered":"

Oracle Locally Managed Tablespace:<\/strong><\/p>\n

It is a locally managed tablespace that tracks all extant data in the tablespace itself by using bitmaps, resulting in the following benefits.<\/p>\n

\n
\"ORACLE<\/a><\/figure>\n<\/div>\n

Key Benefits:<\/strong><\/p>\n

\u2022It has Fast, concurrent space operations. Space allocations and deallocations modify locally managed resources (bitmaps stored in header files).<\/p>\n

\u2022This was a developed performance.<\/p>\n

\u2022Readable standby databases are enabled because locally managed temporary tablespaces do not generate any undo or redo.<\/p>\n

\u2022 Its space allocation is simplified because when the auto-allocate clause is specified, the database automatically selects the appropriate extent size.<\/p>\n

\u2022The user reliance on the data dictionary decreased because the required data is stored in file headers and bitmap blocks.<\/p>\n

\u2022Here, Coalescing free extents is not required for locally managed tablespaces.<\/p>\n

All types of tablespaces, including the system tablespace, can be locally managed. The dbms_space_admin package offers maintenance procedures for locally managed tablespaces.<\/p>\n

\n
\"ORACLE<\/a><\/figure>\n<\/div>\n

How to Create a Locally Managed TableSpace:<\/strong><\/p>\n

To Create a Locally Managed TableSpace by specifying local in the extent management clause of the create tablespace statement. You can have the database manage extents for you automatically with the auto allocate clause (the default), or you can specify that the tablespace is managed with uniform extents of a specific size (uniform). Auto allocation is also one of the best choices if you don’t have to have a lot of control over space allocation and deallocation because it simplifies tablespace management. Some of the space may be wasted with this setting, but the benefit of having an Oracle database manage your space most likely outweighs this drawback.<\/p>\n

When you do not explicitly specify the type of extent management, the Oracle database determines extent management as below:<\/p>\n

\u2022If the create tablespace statement omits the default storage clause, then the database creates a locally managed auto-allocate tablespace.<\/p>\n

\u2022If the create tablespace statement includes a default storage clause, then the database considers this: If you specified the minimum extent clause, the database evaluates whether the values of minimum extent, initial, and next are equal and the value of pct increase is 0. If so, the database creates a locally managed uniform tablespace with extent size = initial. If the minimum extent, initial, and next parameters are not equal, or if the pct increase is not 0, the database refuses any extent storage parameters you may specify and creates a locally managed, auto-allocated tablespace.<\/p>\n

\u2022If you did not specify the minimum extent clause, the database evaluates only whether the storage values of initial and next are equal and the pct increase is 0. If so, the tablespace is locally managed and uniform. Otherwise, the tablespace is locally managed and auto-allocated.<\/p>\n

The below statement creates a locally managed tablespace named lmtbsb and specifies auto allocate:<\/p>\n

Sql> create tablespace lmtbsb datafile \u2018\/u02\/oracle\/data\/lmtbsb01.dbf\u2019 size 50m<\/p>\n

Extent management local auto allocate;<\/p>\n

This Autoallocate causes the tablespace to be system-managed with a minimum extent size of 64k.<\/p>\n<\/p>\n

\n\n\n\n
Learn more information from GoLogica “ORACLE DBA 11g\/12c TRAINING<\/a>“<\/em><\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n

The alternative to autoallocate is uniform. Then it specifies that the tablespace is managed with extents of uniform size. With this, you can specify that size in the size clause of the uniform. If you leave size, then the default size is 1m.<\/p>\n

Sql> create tablespace lmtbsb datafile \u2018\/u02\/oracle\/data\/lmtbsb01.dbf\u2019 size 50m<\/p>\n

Extent management local uniform size 128k;<\/p>\n

With the help of this, you cannot specify the default storage clause, minimum extent, or temporary when you explicitly specify the extent of management locally. If you want to create a temporary locally managed tablespace, use the create temporary tablespace statement.<\/p>\n

Specifying segment space management in locally managed tablespaces:<\/strong><\/p>\n

In a locally managed tablespace, there are two processes that an Oracle database can use to manage segment space: automatic and manual. Manual segment space management uses linked lists said to be \u201cfree lists\u201d to manage free space in the segment, while automatic segment space management uses bitmaps. This space management is the more efficient process and is the default for all new permanent, locally managed tablespaces.<\/p>\n

Automatic segment space management delivers better space utilization than manual segment space management. It is also self-tuning, in that it scales with an increasing number of clients or examples. In addition, for many standard workloads, application performance with automatic segment space management is better than the performance of a well-tuned app using manual segment space management.<\/p>\n

The below statement creates tablespace lmtbsb with automatic segment space management:<\/p>\n

Sql> create tablespace lmtbsb datafile \u2018\/u02\/oracle\/data\/lmtbsb01.dbf\u2019 size 50m<\/p>\n

Extent management local<\/p>\n

Segment space management auto;<\/p>\n

This segment space management manual clause disables automatic segment space management.<\/p>\n

The segment space management that you specify at tablespace creation time applies to all segments subsequently created in the tablespace. With this, you cannot change the segment space management mode of a tablespace.<\/p>\n

\u2022If you set extent management to local uniform, then you must ensure that each extent contains at least 5 database blocks.<\/p>\n

\u2022If you set extent management to local auto allocate, and if the database block size is 16k or greater, then Oracle manages segment space by creating extents with a minimum size of 5 blocks rounded up to 64k.<\/p>\n

Conclusion:<\/strong><\/p>\n

GoLogica Offers an Oracle DBA Online Training<\/a> Course expected to give you inside and out comprehension of the Oracle Database Administration. You will find out about the Oracle DBA<\/a> Architecture, different ideas, database structures, memory and process engineering, security, composition objects, information reinforcement, and recuperation.<\/p>\n<\/p>\n

Related Courses<\/strong><\/p>\n

\n\n\n\n\n\n\n\n\n
Course Name<\/th>\nEnroll Now<\/th>\n<\/tr>\n
ORACLE DBA 11g\/12c TRAINING<\/td>\nEnroll Now<\/a><\/td>\n<\/tr>\n
Oracle B2B Training<\/td>\nEnroll Now<\/a><\/td>\n<\/tr>\n
Oracle BI Publisher Training<\/td>\nEnroll Now<\/a><\/td>\n<\/tr>\n
Oracle Fusion SCM Training<\/td>\nEnroll Now<\/a><\/td>\n<\/tr>\n
ORACLE SOA TRAINING<\/td>\nEnroll Now<\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n","protected":false},"excerpt":{"rendered":"

Oracle Locally Managed Tablespace: It is a locally managed tablespace that tracks all extant data in the tablespace itself by …<\/p>\n","protected":false},"author":67,"featured_media":7330,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"pmpro_default_level":"","footnotes":""},"categories":[12],"tags":[421,713],"coauthors":[349],"class_list":["post-7327","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle_intervew_questions","tag-oracle-dba","tag-oracle-dba-online-training","pmpro-has-access","user-has-not-earned"],"yoast_head":"\nLearn about how Oracle Locally Managed Tablespace?<\/title>\n<meta name=\"description\" content=\"GoLogica Offers Oracle Core DBA 11g\/12c Training Course expects to give you inside and out comprehension of the Oracle Database Administration.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.gologica.com\/elearning\/how-oracle-locally-managed-tablespace\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Learn about how Oracle Locally Managed Tablespace?\" \/>\n<meta property=\"og:description\" content=\"GoLogica Offers Oracle Core DBA 11g\/12c Training Course expects to give you inside and out comprehension of the Oracle Database Administration.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.gologica.com\/elearning\/how-oracle-locally-managed-tablespace\/\" \/>\n<meta property=\"og:site_name\" content=\"GoLogica\" \/>\n<meta property=\"article:published_time\" content=\"2021-06-23T14:38:27+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-07T10:26:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.gologica.com\/elearning\/wp-content\/uploads\/2021\/06\/Oracle-DBA-3.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"300\" \/>\n\t<meta property=\"og:image:height\" content=\"175\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"priyanka dasari\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"priyanka dasari\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.gologica.com\/elearning\/how-oracle-locally-managed-tablespace\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.gologica.com\/elearning\/how-oracle-locally-managed-tablespace\/\"},\"author\":{\"name\":\"priyanka dasari\",\"@id\":\"https:\/\/www.gologica.com\/elearning\/#\/schema\/person\/18e1f2ad880623daf280f2943dc4a445\"},\"headline\":\"How Oracle Locally Managed Tablespace ?\",\"datePublished\":\"2021-06-23T14:38:27+00:00\",\"dateModified\":\"2025-04-07T10:26:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.gologica.com\/elearning\/how-oracle-locally-managed-tablespace\/\"},\"wordCount\":945,\"image\":{\"@id\":\"https:\/\/www.gologica.com\/elearning\/how-oracle-locally-managed-tablespace\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.gologica.com\/elearning\/wp-content\/uploads\/2021\/06\/Oracle-DBA-3.jpg\",\"keywords\":[\"ORACLE DBA\",\"ORACLE DBA ONLINE TRAINING\"],\"articleSection\":[\"Oracle\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.gologica.com\/elearning\/how-oracle-locally-managed-tablespace\/\",\"url\":\"https:\/\/www.gologica.com\/elearning\/how-oracle-locally-managed-tablespace\/\",\"name\":\"Learn about how Oracle Locally Managed Tablespace?\",\"isPartOf\":{\"@id\":\"https:\/\/www.gologica.com\/elearning\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.gologica.com\/elearning\/how-oracle-locally-managed-tablespace\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.gologica.com\/elearning\/how-oracle-locally-managed-tablespace\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.gologica.com\/elearning\/wp-content\/uploads\/2021\/06\/Oracle-DBA-3.jpg\",\"datePublished\":\"2021-06-23T14:38:27+00:00\",\"dateModified\":\"2025-04-07T10:26:47+00:00\",\"author\":{\"@id\":\"https:\/\/www.gologica.com\/elearning\/#\/schema\/person\/18e1f2ad880623daf280f2943dc4a445\"},\"description\":\"GoLogica Offers Oracle Core DBA 11g\/12c Training Course expects to give you inside and out comprehension of the Oracle Database Administration.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.gologica.com\/elearning\/how-oracle-locally-managed-tablespace\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.gologica.com\/elearning\/how-oracle-locally-managed-tablespace\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.gologica.com\/elearning\/how-oracle-locally-managed-tablespace\/#primaryimage\",\"url\":\"https:\/\/www.gologica.com\/elearning\/wp-content\/uploads\/2021\/06\/Oracle-DBA-3.jpg\",\"contentUrl\":\"https:\/\/www.gologica.com\/elearning\/wp-content\/uploads\/2021\/06\/Oracle-DBA-3.jpg\",\"width\":300,\"height\":175,\"caption\":\"Oracle DBA\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.gologica.com\/elearning\/how-oracle-locally-managed-tablespace\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.gologica.com\/elearning\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How Oracle Locally Managed Tablespace ?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.gologica.com\/elearning\/#website\",\"url\":\"https:\/\/www.gologica.com\/elearning\/\",\"name\":\"GoLogica\",\"description\":\"E-Learning Portal\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.gologica.com\/elearning\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.gologica.com\/elearning\/#\/schema\/person\/18e1f2ad880623daf280f2943dc4a445\",\"name\":\"priyanka dasari\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.gologica.com\/elearning\/#\/schema\/person\/image\/13985a9230fba6291922117b11059695\",\"url\":\"https:\/\/www.gologica.com\/elearning\/wp-content\/uploads\/avatars\/67\/5e71eca5810c3-bpthumb.png\",\"contentUrl\":\"https:\/\/www.gologica.com\/elearning\/wp-content\/uploads\/avatars\/67\/5e71eca5810c3-bpthumb.png\",\"caption\":\"priyanka dasari\"},\"url\":\"https:\/\/www.gologica.com\/elearning\/author\/priyanka\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Learn about how Oracle Locally Managed Tablespace?","description":"GoLogica Offers Oracle Core DBA 11g\/12c Training Course expects to give you inside and out comprehension of the Oracle Database Administration.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.gologica.com\/elearning\/how-oracle-locally-managed-tablespace\/","og_locale":"en_US","og_type":"article","og_title":"Learn about how Oracle Locally Managed Tablespace?","og_description":"GoLogica Offers Oracle Core DBA 11g\/12c Training Course expects to give you inside and out comprehension of the Oracle Database Administration.","og_url":"https:\/\/www.gologica.com\/elearning\/how-oracle-locally-managed-tablespace\/","og_site_name":"GoLogica","article_published_time":"2021-06-23T14:38:27+00:00","article_modified_time":"2025-04-07T10:26:47+00:00","og_image":[{"width":300,"height":175,"url":"https:\/\/www.gologica.com\/elearning\/wp-content\/uploads\/2021\/06\/Oracle-DBA-3.jpg","type":"image\/jpeg"}],"author":"priyanka dasari","twitter_card":"summary_large_image","twitter_misc":{"Written by":"priyanka dasari","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.gologica.com\/elearning\/how-oracle-locally-managed-tablespace\/#article","isPartOf":{"@id":"https:\/\/www.gologica.com\/elearning\/how-oracle-locally-managed-tablespace\/"},"author":{"name":"priyanka dasari","@id":"https:\/\/www.gologica.com\/elearning\/#\/schema\/person\/18e1f2ad880623daf280f2943dc4a445"},"headline":"How Oracle Locally Managed Tablespace ?","datePublished":"2021-06-23T14:38:27+00:00","dateModified":"2025-04-07T10:26:47+00:00","mainEntityOfPage":{"@id":"https:\/\/www.gologica.com\/elearning\/how-oracle-locally-managed-tablespace\/"},"wordCount":945,"image":{"@id":"https:\/\/www.gologica.com\/elearning\/how-oracle-locally-managed-tablespace\/#primaryimage"},"thumbnailUrl":"https:\/\/www.gologica.com\/elearning\/wp-content\/uploads\/2021\/06\/Oracle-DBA-3.jpg","keywords":["ORACLE DBA","ORACLE DBA ONLINE TRAINING"],"articleSection":["Oracle"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.gologica.com\/elearning\/how-oracle-locally-managed-tablespace\/","url":"https:\/\/www.gologica.com\/elearning\/how-oracle-locally-managed-tablespace\/","name":"Learn about how Oracle Locally Managed Tablespace?","isPartOf":{"@id":"https:\/\/www.gologica.com\/elearning\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.gologica.com\/elearning\/how-oracle-locally-managed-tablespace\/#primaryimage"},"image":{"@id":"https:\/\/www.gologica.com\/elearning\/how-oracle-locally-managed-tablespace\/#primaryimage"},"thumbnailUrl":"https:\/\/www.gologica.com\/elearning\/wp-content\/uploads\/2021\/06\/Oracle-DBA-3.jpg","datePublished":"2021-06-23T14:38:27+00:00","dateModified":"2025-04-07T10:26:47+00:00","author":{"@id":"https:\/\/www.gologica.com\/elearning\/#\/schema\/person\/18e1f2ad880623daf280f2943dc4a445"},"description":"GoLogica Offers Oracle Core DBA 11g\/12c Training Course expects to give you inside and out comprehension of the Oracle Database Administration.","breadcrumb":{"@id":"https:\/\/www.gologica.com\/elearning\/how-oracle-locally-managed-tablespace\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.gologica.com\/elearning\/how-oracle-locally-managed-tablespace\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.gologica.com\/elearning\/how-oracle-locally-managed-tablespace\/#primaryimage","url":"https:\/\/www.gologica.com\/elearning\/wp-content\/uploads\/2021\/06\/Oracle-DBA-3.jpg","contentUrl":"https:\/\/www.gologica.com\/elearning\/wp-content\/uploads\/2021\/06\/Oracle-DBA-3.jpg","width":300,"height":175,"caption":"Oracle DBA"},{"@type":"BreadcrumbList","@id":"https:\/\/www.gologica.com\/elearning\/how-oracle-locally-managed-tablespace\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.gologica.com\/elearning\/"},{"@type":"ListItem","position":2,"name":"How Oracle Locally Managed Tablespace ?"}]},{"@type":"WebSite","@id":"https:\/\/www.gologica.com\/elearning\/#website","url":"https:\/\/www.gologica.com\/elearning\/","name":"GoLogica","description":"E-Learning Portal","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.gologica.com\/elearning\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.gologica.com\/elearning\/#\/schema\/person\/18e1f2ad880623daf280f2943dc4a445","name":"priyanka dasari","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.gologica.com\/elearning\/#\/schema\/person\/image\/13985a9230fba6291922117b11059695","url":"https:\/\/www.gologica.com\/elearning\/wp-content\/uploads\/avatars\/67\/5e71eca5810c3-bpthumb.png","contentUrl":"https:\/\/www.gologica.com\/elearning\/wp-content\/uploads\/avatars\/67\/5e71eca5810c3-bpthumb.png","caption":"priyanka dasari"},"url":"https:\/\/www.gologica.com\/elearning\/author\/priyanka\/"}]}},"_links":{"self":[{"href":"https:\/\/www.gologica.com\/elearning\/wp-json\/wp\/v2\/posts\/7327","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.gologica.com\/elearning\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gologica.com\/elearning\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gologica.com\/elearning\/wp-json\/wp\/v2\/users\/67"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gologica.com\/elearning\/wp-json\/wp\/v2\/comments?post=7327"}],"version-history":[{"count":3,"href":"https:\/\/www.gologica.com\/elearning\/wp-json\/wp\/v2\/posts\/7327\/revisions"}],"predecessor-version":[{"id":65474,"href":"https:\/\/www.gologica.com\/elearning\/wp-json\/wp\/v2\/posts\/7327\/revisions\/65474"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.gologica.com\/elearning\/wp-json\/wp\/v2\/media\/7330"}],"wp:attachment":[{"href":"https:\/\/www.gologica.com\/elearning\/wp-json\/wp\/v2\/media?parent=7327"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gologica.com\/elearning\/wp-json\/wp\/v2\/categories?post=7327"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gologica.com\/elearning\/wp-json\/wp\/v2\/tags?post=7327"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.gologica.com\/elearning\/wp-json\/wp\/v2\/coauthors?post=7327"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}