RE: Localy managed TBS

From: Christopher Spence <cspence_at_FuelSpot.com>
Date: Thu, 04 Oct 2001 11:46:29 -0700
Message-ID: <F001.003A233B.20011004111522@fatcity.com>

I updated my script on my site to include LMT column, it is similar to Lisa's, but with an extra column.

<a
href="http://www.vampired.net/scripts/php/tablespace.php">http://www.vampired.net/scripts/php/tablespace.php

The only real different between Lisa's script is I have object count, other than that, it is the same, just we used different approaches.

"Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence
<span

style='font-size:10.0pt;font-family:"Comic Sans MS";color:navy;mso-no-proof: yes'>Oracle DBA
<span

style='font-size:10.0pt;font-family:"Comic Sans MS";color:navy;mso-no-proof: yes'>Phone: (978) 322-5744
<span

style='font-size:10.0pt;font-family:"Comic Sans MS";color:navy;mso-no-proof: yes'>Fax: (707) 885-2275

Fuelspot
<span

style='font-size:10.0pt;font-family:"Comic Sans MS";color:navy;mso-no-proof: yes'>73 Princeton Street
<span

style='font-size:10.0pt;font-family:"Comic Sans MS";color:navy;mso-no-proof: yes'>North, Chelmsford 01863

<span

style='font-size:10.0pt;font-family:Tahoma'>-----Original Message----- From: Mercadante,
Thomas F [mailto:NDATFM_at_labor.state.ny.us] Sent: Wednesday, October 03, 2001
4:20 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Localy managed TBS

<span

style='font-size:12.0pt'>

<span

style='font-size:10.0pt;font-family:Arial;color:blue'>Lisa,

<span

style='font-size:12.0pt'>

<span

style='font-size:10.0pt;font-family:Arial;color:blue'>Nice simple script! ;0

<span

style='font-size:12.0pt'>

<span

style='font-size:10.0pt;font-family:Arial;color:blue'>Actually, produces a very nice, neat, concise report.

<span

style='font-size:12.0pt'>

<span

style='font-size:10.0pt;font-family:Arial;color:blue'>Very nice.

<span

style='font-size:12.0pt'>

<span

style='font-size:10.0pt;font-family:Arial;color:blue'>Thanks!

Tom Mercadante Oracle
Certified Professional

-----Original Message----- From: Koivu, Lisa
[mailto:lisa.koivu_at_efairfield.com]
Sent: Wednesday, October 03, 2001
4:06 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Localy managed TBS

<span

style='font-size:12.0pt;font-family:Georgia;color:blue'>in dba_tablespaces, column extent_management

<span

style='font-size:12.0pt;font-family:Georgia;color:blue'>below is a script I use that has this bit of info included

<span

style='font-size:12.0pt;font-family:Georgia;color:blue'>-- snip column
ts_name format a15

<span

style='font-size:10.0pt;font-family:Courier;color:blue'>select a.tablespace_name ts_name,extent_management lmt, mb_free, mb_total, pct_used

from
(
 select
 tablespace_name, MB_FREE, MB_TOTAL, round((MB_TOTAL-MB_FREE)/MB_TOTAL*1000)/10 pct_used
 from
 (select tablespace_name, trunc(sum(free_bytes/1024)) MB_FREE , sum(total_bytes/1024) MB_TOTAL

 from

(
<span style='font-size:10.0pt;font-family:

Courier;color:blue'>

(select tablespace_name, sum(bytes)/1024 free_bytes,
<span style='font-size:10.0pt;font-family:

Courier;color:blue'>

00 total_bytes
<span style='font-size:10.0pt;font-family:

Courier;color:blue'>

from dba_free_space
<span style='font-size:10.0pt;font-family:

Courier;color:blue'>

group by tablespace_name)

union

(select t.tablespace_name tablespace_name,

       
       
        <font size=2 color=blue

face=Courier>00
free_bytes,
<span style='font-size:10.0pt;font-family:

Courier;color:blue'>

sum(d.bytes)/1024 total_bytes

from

dba_tablespaces t, dba_data_files d

where t.tablespace_name = d.tablespace_name

group by T.EXTENT_MANAGEMENT, t.tablespace_name)

)
 group by tablespace_name) ) a,

dba_tablespaces t
where t.tablespace_name = a.tablespace_name
order by 1,2
/

Lisa Koivu
Oracle Database
Administrator
Fairfield Resorts, Inc.

954-935-4117

<span

style='font-size:12.0pt'>

-----Original Message-----
From: Hamid Alavi [SMTP:hamid.alavi_at_quovadx.com]
Sent: Wednesday, October 03, 2001 3:40 PM

To: Multiple recipients
of list ORACLE-L
Subject:
Localy
managed TBS

List,
How
can I find out which Tablespace managed localy or by Dictionary? Any
hint appreciate.

Hamid Alavi
Office
818 737-0526
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

may
contain information that is PRIVILEGED, CONFIDENTIAL and exempt from

disclosure
under applicable law. If you have received this message in error,

you
are prohibited from copying, distributing, or using the information.

Please
contact the sender immediately by return e-mail and delete the original
message from your system.

-- 
Please
see the official ORACLE-L FAQ: http://www.orafaq.com

-- 
Author:
Hamid Alavi 
 
INET: hamid.alavi_at_quovadx.com 



<span style='font-size:

10.0pt;font-family:Arial'>Fat City Network Services    -- (858)
538-5051  FAX: (858) 538-5051 
San
Diego, California        -- Public Internet
access / Mailing Lists 
--------------------------------------------------------------------

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

also
send the HELP command for other information (like subscribing).

Received on Thu Oct 04 2001 - 13:46:29 CDT