{"id":182,"date":"2018-04-23T19:08:41","date_gmt":"2018-04-23T22:08:41","guid":{"rendered":"http:\/\/rodrigosilvaesilva.com.br\/?p=182"},"modified":"2018-04-23T19:08:41","modified_gmt":"2018-04-23T22:08:41","slug":"listar-espaco-livre-tablespaces","status":"publish","type":"post","link":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/2018\/04\/23\/listar-espaco-livre-tablespaces\/","title":{"rendered":"Listar espa\u00e7o Livre Tablespaces"},"content":{"rendered":"<p>Select para listar espa\u00e7o dispon\u00edvel Tablespaces<\/p>\n<pre class=\"lang:plsql decode:true \">column dummy noprint\ncolumn pct_used format 999.9 heading \"%|Used\"\ncolumn name format a16 heading \"Tablespace Name\"\ncolumn Kbytes format 999,999,999 heading \"KBytes\"\ncolumn used format 999,999,999 heading \"Used\"\ncolumn free format 999,999,999 heading \"Free\"\ncolumn largest format 999,999,999 heading \"Largest\"\nbreak on report\ncompute sum of kbytes on report\ncompute sum of free on report\ncompute sum of used on report<\/pre>\n<pre class=\"lang:plsql decode:true\">SYS@XE &gt;\nselect nvl(b.tablespace_name,\nnvl(a.tablespace_name,'UNKOWN')) name,\nkbytes_alloc kbytes,\nkbytes_alloc-nvl(kbytes_free,0) used,\nnvl(kbytes_free,0) free,\n((kbytes_alloc-nvl(kbytes_free,0))\/\nkbytes_alloc)*100 pct_used,\nnvl(largest,0) largest\nfrom ( select sum(bytes)\/1024 Kbytes_free,\nmax(bytes)\/1024 largest,\ntablespace_name\nfrom sys.dba_free_space\ngroup by tablespace_name ) a,\n( select sum(bytes)\/1024 Kbytes_alloc,\ntablespace_name\nfrom sys.dba_data_files\ngroup by tablespace_name )b\nwhere a.tablespace_name (+) = b.tablespace_name\norder by &amp;1\n\/ \n<\/pre>\n<pre class=\"lang:plsql decode:true \">Enter value for 1: 1\nold  19: order by &amp;1\nnew  19: order by 1\n\n                                                             %\nTablespace Name        KBytes         Used         Free   Used      Largest\n---------------- ------------ ------------ ------------ ------ ------------\nPROD01_DATA         4,706,304    4,337,664      368,640   92.2      368,640\nPROD01_INDX         5,242,880        4,096    5,238,784     .1    2,096,128\nSYSAUX                675,840      638,784       37,056   94.5       36,864\nSYSTEM                614,400      613,568          832   99.9          832\nUNDOTBS1              179,200      155,456       23,744   86.8        4,096\nUSERS                 102,400        2,624       99,776    2.6       99,776\n                 ------------ ------------ ------------\nsum                11,521,024    5,752,192    5,768,832\n\n6 rows selected.\n<\/pre>\n<pre class=\"lang:plsql decode:true \">Kbytes = espa\u00e7o alocado para o espa\u00e7o de tabela atualmente.\nUsado = espa\u00e7o alocado dentro do espa\u00e7o de tabela para espec\u00edfico\nobjetos\nLivre = espa\u00e7o ainda n\u00e3o alocado para qualquer objeto\nUsado =% do espa\u00e7o alocado para objetos no espa\u00e7o de tabela\nMaior = Maior extens\u00e3o cont\u00edgua gratuita dispon\u00edvel (NEXT_EXTENTS\nmaior ent\u00e3o isso ir\u00e1 falhar<\/pre>\n<p><a href=\"https:\/\/asktom.oracle.com\/pls\/asktom\/f?p=100:11:::::P11_QUESTION_ID:285415955510\">Fonte: Ask Tom<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Select para listar espa\u00e7o dispon\u00edvel Tablespaces column dummy noprint column pct_used format 999.9 heading &#8220;%|Used&#8221; column name format a16 heading &#8220;Tablespace Name&#8221; column Kbytes format 999,999,999 heading &#8220;KBytes&#8221; column used format 999,999,999 heading &#8220;Used&#8221; column free format 999,999,999 heading &#8220;Free&#8221; column largest format 999,999,999 heading &#8220;Largest&#8221; break on report compute sum of kbytes on report&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[180,350],"class_list":["post-182","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-listar-espaco-livre-tablespaces","tag-tablespaces"],"_links":{"self":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/182","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/comments?post=182"}],"version-history":[{"count":0,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/182\/revisions"}],"wp:attachment":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=182"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=182"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=182"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}