| 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 | SELECT F.TABLESPACE_NAME ,TO_CHAR ((T.TOTAL_SPACE - F.FREE_SPACE),'999,999') "USEDMB" ,TO_CHAR (F.FREE_SPACE, '999,999') "FREEMB" ,TO_CHAR (T.TOTAL_SPACE, '999,999') "TOTALMB" ,TO_CHAR ((ROUND ((F.FREE_SPACE/T.TOTAL_SPACE)*100)),'999')||' %' FREE FROM ( SELECT TABLESPACE_NAME ,ROUND (SUM (BLOCKS*(SELECT VALUE/1024 FROM V$PARAMETER WHERE NAME = 'db_block_size')/1024) ) FREE_SPACE FROM DBA_FREE_SPACE GROUP BY TABLESPACE_NAME ) F ,( SELECT TABLESPACE_NAME ,ROUND (SUM (BYTES/1048576)) TOTAL_SPACE FROM DBA_DATA_FILES GROUP BY TABLESPACE_NAME ) T WHERE F.TABLESPACE_NAME = T.TABLESPACE_NAME; |
quinta-feira, 26 de agosto de 2010
Verificar espaço nas tablespaces
Verificando autoextensible em tablespaces
| 1 | select tablespace_name,AUTOEXTENSIBLE from dba_data_files |
Verificar autoextensible em tablespaces
Received: from exccorp.Intelig23 ([10.1.9.33]) by exccorp.Intelig23
([10.1.9.33]) with mapi; Thu, 26 Aug 2010 10:53:52 -0300
From: "Sergio Queiroz (Atos Origin)" <sergio.queiroz@intelig.com.br>
To: "sergiolnqueiroz1.verolme@blogger.com"
<sergiolnqueiroz1.verolme@blogger.com>
Date: Thu, 26 Aug 2010 10:53:25 -0300
Subject: Verificar autoextensible em tablespaces
Thread-Topic: Verificar autoextensible em tablespaces
Thread-Index: ActEs27h7rjQHpn2SaSZGb3EfZ6AvAAccvcQ
Message-ID: <15B3F09132EB8C4D87881CBEB693BBC01979E80CD9@exccorp.Intelig23>
Accept-Language: en-US
Content-Language: en-US
X-MS-Has-Attach:
X-MS-TNEF-Correlator:
acceptlanguage: en-US
Content-Type: multipart/alternative;
boundary="_000_15B3F09132EB8C4D87881CBEB693BBC01979E80CD9exccorpInteli_"
MIME-Version: 1.0
--_000_15B3F09132EB8C4D87881CBEB693BBC01979E80CD9exccorpInteli_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
1
select tablespace_name,AUTOEXTENSIBLE from dba_data_files
--_000_15B3F09132EB8C4D87881CBEB693BBC01979E80CD9exccorpInteli_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:x=3D"urn:schemas-microsoft-com:office:excel" xmlns=3D"http://www.w3.o=
rg/TR/REC-html40">
<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; charset=3Dus-ascii"=
>
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Lucida Console";
panose-1:2 11 6 9 4 5 4 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal;
font-family:Arial;
color:windowtext;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=3DEN-US link=3Dblue vlink=3Dpurple>
<div class=3DSection1>
<table class=3DMsoTableGrid border=3D1 cellspacing=3D0 cellpadding=3D0
style=3D'border-collapse:collapse;border:none'>
<tr height=3D23 style=3D'height:17.5pt'>
<td width=3D21 height=3D23 bgcolor=3Dsilver style=3D'width:16.05pt;border=
:solid #999999 1.0pt;
border-right:solid windowtext 1.0pt;background:silver;padding:0cm 5.4pt 0=
cm 5.4pt;
height:17.5pt'>
<p class=3DMsoNormal><font size=3D1 color=3Dteal face=3D"Lucida Console">=
<span
style=3D'font-size:9.0pt;font-family:"Lucida Console";color:teal;backgrou=
nd:
silver'>1</span></font><font size=3D1 color=3Dteal face=3D"Lucida Console=
"><span
style=3D'font-size:9.0pt;font-family:"Lucida Console";color:teal;backgrou=
nd:
white'><o:p></o:p></span></font></p>
</td>
<td width=3D434 height=3D23 style=3D'width:325.55pt;border:solid #999999 =
1.0pt;
border-left:none;padding:0cm 5.4pt 0cm 5.4pt;height:17.5pt'>
<p class=3DMsoNormal><font size=3D1 color=3Dteal face=3D"Lucida Console">=
<span
style=3D'font-size:9.0pt;font-family:"Lucida Console";color:teal;backgrou=
nd:
white'>select</span></font><font size=3D1 color=3Dnavy face=3D"Lucida Con=
sole"><span
style=3D'font-size:9.0pt;font-family:"Lucida Console";color:navy;backgrou=
nd:
white'> tablespace_name,AUTOEXTENSIBLE </span></font><font size=3D1 color=
=3Dteal
face=3D"Lucida Console"><span style=3D'font-size:9.0pt;font-family:"Lucid=
a Console";
color:teal;background:white'>from</span></font><font size=3D1 color=3Dnav=
y
face=3D"Lucida Console"><span style=3D'font-size:9.0pt;font-family:"Lucid=
a Console";
color:navy;background:white'> dba_data_files</span></font><font size=3D1
color=3Dteal face=3D"Lucida Console"><span style=3D'font-size:9.0pt;font-=
family:
"Lucida Console";color:teal;background:white'><o:p></o:p></span></font></=
p>
</td>
</tr>
</table>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span style=3D=
'font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
</body>
</html>
--_000_15B3F09132EB8C4D87881CBEB693BBC01979E80CD9exccorpInteli_--
Esta mensagem, incluindo seus anexos, tem caráter confidencial e seu conteúdo é restrito ao destinatário da mensagem. Caso você tenha
recebido esta mensagem por engano, queira por favor retorná-la ao remetente e apagá-la de seus arquivos. Qualquer uso não
autorizado, replicação ou disseminação desta mensagem ou parte dela é expressamente proibido.
Postagens
