{"id":297,"date":"2012-03-07T04:55:10","date_gmt":"2012-03-07T04:55:10","guid":{"rendered":"http:\/\/oranotes.tuktaroff.com\/?page_id=297"},"modified":"2012-03-07T04:58:54","modified_gmt":"2012-03-07T04:58:54","slug":"segment-information","status":"publish","type":"page","link":"http:\/\/oranotes.tuktaroff.com\/?page_id=297","title":{"rendered":"Segment information"},"content":{"rendered":"<p><code><br \/>\n<script type=\"text\/javascript\"> \nfunction copy(what) {\n    window.clipboardData.setData('Text',what.value);\n}\nfunction paste(what) {\n    what.value = window.clipboardData.getData('Text');\n}\n<\/script><\/p>\n<h2>\nTable segment information<br \/>\n<\/h2>\n<pre class=\"qcode\">\r\nCOLUMN segment_type                                  HEADING \"Segment Type\"\r\nCOLUMN bytes               FORMAT 9,999,999,999,999  HEADING \"Bytes\"\r\nCOLUMN extents             FORMAT 999,999,999        HEADING \"Extents\"\r\nCOLUMN initial_extent      FORMAT 999,999,999,999    HEADING \"Initial|Extent\"\r\nCOLUMN next_extent         FORMAT 999,999,999,999    HEADING \"Next|Extent\"\r\nCOLUMN min_extents         FORMAT 999                HEADING \"Min|Extents\"\r\nCOLUMN max_extents         FORMAT 9,999,999,999      HEADING \"Max|Extents\"\r\nCOLUMN pct_increase        FORMAT 999.00             HEADING \"Pct|Increase\"\r\nCOLUMN freelists                                     HEADING \"Free|Lists\"\r\nCOLUMN freelist_groups                               HEADING \"Free|List Groups\"\r\n\r\nSELECT \r\n    segment_type     segment_type\r\n  , bytes            bytes\r\n  , extents          extents\r\n  , initial_extent   initial_extent\r\n  , next_extent      next_extent\r\n  , min_extents      min_extents\r\n  , max_extents      max_extents\r\n  , pct_increase     pct_increase\r\n  , freelists        freelists\r\n  , freelist_groups  freelist_groups\r\nFROM\r\n    dba_segments\r\nWHERE\r\n      owner        = UPPER('&schema_name')\r\n  AND segment_name = UPPER('&table_name')\r\n\/\r\n<\/pre>\n<form action=\"\"><textarea name=\"data\" cols=\"50\" rows=\"10\" style=\"display:none;\"><br \/>\nCOLUMN segment_type                                  HEADING \"Segment Type\"<br \/>\nCOLUMN bytes               FORMAT 9,999,999,999,999  HEADING \"Bytes\"<br \/>\nCOLUMN extents             FORMAT 999,999,999        HEADING \"Extents\"<br \/>\nCOLUMN initial_extent      FORMAT 999,999,999,999    HEADING \"Initial|Extent\"<br \/>\nCOLUMN next_extent         FORMAT 999,999,999,999    HEADING \"Next|Extent\"<br \/>\nCOLUMN min_extents         FORMAT 999                HEADING \"Min|Extents\"<br \/>\nCOLUMN max_extents         FORMAT 9,999,999,999      HEADING \"Max|Extents\"<br \/>\nCOLUMN pct_increase        FORMAT 999.00             HEADING \"Pct|Increase\"<br \/>\nCOLUMN freelists                                     HEADING \"Free|Lists\"<br \/>\nCOLUMN freelist_groups                               HEADING \"Free|List Groups\"<\/p>\n<p>SELECT<br \/>\n    segment_type     segment_type<br \/>\n  , bytes            bytes<br \/>\n  , extents          extents<br \/>\n  , initial_extent   initial_extent<br \/>\n  , next_extent      next_extent<br \/>\n  , min_extents      min_extents<br \/>\n  , max_extents      max_extents<br \/>\n  , pct_increase     pct_increase<br \/>\n  , freelists        freelists<br \/>\n  , freelist_groups  freelist_groups<br \/>\nFROM<br \/>\n    dba_segments<br \/>\nWHERE<br \/>\n      owner        = UPPER('&schema_name')<br \/>\n  AND segment_name = UPPER('&table_name')<br \/>\n\/<br \/>\n<\/textarea><input type=\"button\" value=\"Clipboard\" onclick=\"copy(this.form.data)\"><\/form>\n<p><\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Table segment information COLUMN segment_type HEADING &#8220;Segment Type&#8221; COLUMN bytes FORMAT 9,999,999,999,999 HEADING &#8220;Bytes&#8221; COLUMN extents FORMAT 999,999,999 HEADING &#8220;Extents&#8221; COLUMN initial_extent FORMAT 999,999,999,999 HEADING &#8220;Initial|Extent&#8221; COLUMN next_extent FORMAT 999,999,999,999 HEADING &#8220;Next|Extent&#8221; COLUMN min_extents FORMAT 999 HEADING &#8220;Min|Extents&#8221; COLUMN max_extents FORMAT 9,999,999,999 HEADING &#8220;Max|Extents&#8221; COLUMN pct_increase FORMAT 999.00 HEADING &#8220;Pct|Increase&#8221; COLUMN freelists HEADING &#8220;Free|Lists&#8221; COLUMN [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":291,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-297","page","type-page","status-publish","hentry"],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/P2NVny-4N","_links":{"self":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/297","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=297"}],"version-history":[{"count":2,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/297\/revisions"}],"predecessor-version":[{"id":302,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/297\/revisions\/302"}],"up":[{"embeddable":true,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/291"}],"wp:attachment":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=297"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}