<SPAN
class=110101819-03102001>Lisa,
<SPAN
class=110101819-03102001>
<SPAN
class=110101819-03102001>Nice simple script! ;0
<SPAN
class=110101819-03102001>
<SPAN
class=110101819-03102001>Actually, produces a very nice, neat, concise
report.
<SPAN
class=110101819-03102001>
<SPAN
class=110101819-03102001>Very nice.
<SPAN
class=110101819-03102001>
<SPAN
class=110101819-03102001>Thanks!
Tom Mercadante <FONT face=Arial
size=2>Oracle Certified Professional
<FONT face=Tahoma
size=2>-----Original Message-----From: Koivu, Lisa
[mailto:lisa.koivu_at_efairfield.com]Sent: Wednesday, October 03, 2001
4:06 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: Localy managed TBS
in dba_tablespaces, column
extent_management
below is a script I use that has this bit
of info included
- snip <FONT color=#0000ff
face=Georgia>column ts_name format a15
select a.tablespace_name
ts_name,extent_management lmt, mb_free, mb_total, pct_used <FONT
color=#0000ff face=Courier size=2>from <FONT color=#0000ff
face=Courier size=2>( <FONT color=#0000ff face=Courier
size=2> select <FONT color=#0000ff face=Courier
size=2> tablespace_name, MB_FREE, MB_TOTAL,
round((MB_TOTAL-MB_FREE)/MB_TOTAL*1000)/10 pct_used <FONT
color=#0000ff face=Courier size=2> from <FONT color=#0000ff
face=Courier size=2> (select tablespace_name,
trunc(sum(free_bytes/1024)) MB_FREE , sum(total_bytes/1024) MB_TOTAL
from
<FONT color=#0000ff face=Courier
size=2>
( <FONT color=#0000ff face=Courier
size=2>
(select tablespace_name, sum(bytes)/1024 free_bytes, <FONT
color=#0000ff face=Courier
size=2>
00 total_bytes <FONT color=#0000ff face=Courier
size=2>
from dba_free_space <FONT color=#0000ff face=Courier
size=2>
group by tablespace_name) <FONT color=#0000ff face=Courier
size=2>
union <FONT color=#0000ff face=Courier
size=2>
(select t.tablespace_name tablespace_name,
<FONT color=#0000ff face=Courier
size=2>00 free_bytes, <FONT color=#0000ff face=Courier
size=2>
sum(d.bytes)/1024 total_bytes <FONT
color=#0000ff face=Courier
size=2>
from <FONT color=#0000ff face=Courier
size=2>
dba_tablespaces t, dba_data_files d <FONT color=#0000ff
face=Courier
size=2>
where t.tablespace_name = d.tablespace_name <FONT color=#0000ff
face=Courier
size=2>
group by T.EXTENT_MANAGEMENT, t.tablespace_name) <FONT
color=#0000ff face=Courier
size=2>
) group
by tablespace_name) ) a, <FONT color=#0000ff face=Courier
size=2>dba_tablespaces t <FONT color=#0000ff face=Courier
size=2>where t.tablespace_name = a.tablespace_name <FONT
color=#0000ff face=Courier size=2>order by 1,2 <FONT color=#0000ff
face=Courier size=2>/
Lisa Koivu Oracle Database
Administrator Fairfield Resorts, Inc.
954-935-4117
-----Original Message----- <FONT
face=Arial size=1>From: Hamid
Alavi [SMTP:hamid.alavi_at_quovadx.com] <FONT face=Arial
size=1>Sent: Wednesday,
October 03, 2001 3:40 PM <FONT face=Arial
size=1>To: <FONT face=Arial
size=1>Multiple recipients of list ORACLE-L <FONT face=Arial
size=1>Subject: <FONT
face=Arial size=1>Localy managed TBS
List, How can
I find out which Tablespace managed localy or by Dictionary?
Any hint appreciate.
Hamid Alavi <FONT face=Arial
size=2>Office 818 737-0526 <FONT face=Arial
size=2>Cell 818 402-1987
The information contained in this message and any
attachments is intended only for the use
of the individual or entity to which it is addressed, and <FONT
face=Arial size=2>may contain information that is PRIVILEGED, CONFIDENTIAL
and exempt from disclosure under
applicable law. If you have received this message in error, <FONT
face=Arial size=2>you are prohibited from copying, distributing, or using
the information. Please contact the
sender immediately by return e-mail and delete the <FONT
face=Arial size=2>original message from your system. <FONT
face=Arial size=2>-- Please see the
official ORACLE-L FAQ: <A href="
http://www.orafaq.com"
target=_blank>
http://www.orafaq.com <FONT face=Arial
size=2>-- Author: Hamid Alavi
INET: hamid.alavi_at_quovadx.com
Fat City Network Services --
(858) 538-5051 FAX: (858) 538-5051 <FONT face=Arial
size=2>San Diego, California --
Public Internet access / Mailing Lists <FONT face=Arial
size=2>--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send
an E-Mail message to:
ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing:
UNSUB ORACLE-L (or the name of mailing
list you want to be removed from). You may <FONT face=Arial
size=2>also send the HELP command for other information (like
subscribing).
Received on Wed Oct 03 2001 - 14:09:36 CDT
