| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: resize in 7.3.4 urgent
Yep. That's the one. First book on my Oracle bookshelf.
"Rachel
Carmichael" To: Multiple recipients of list ORACLE-L
<carmichr_at_hot <ORACLE-L_at_fatcity.com>
mail.com> cc:
Sent by: Subject: RE: resize in 7.3.4 urgent
root_at_fatcity.
com
07/18/2001
12:17 PM
Please
respond to
ORACLE-L
DBA Handbook is by Kevin Loney. as is Oracle8 DBA Handbook and Oracle8i DBA Handbook (this last with Marlene Theriault as co-author). and the to-be-published (no, I don't have a date, they have just started working on it!) Oracle9i DBA Handbook
>From: tday6_at_csc.com
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: resize in 7.3.4 urgent
>Date: Wed, 18 Jul 2001 07:01:36 -0800
>
>If you want to see a more visual representation of what's in a tablespace
>(including free space) use the mapper.sql from the old DBA Handbook (don't
>have it right here in front of me so I don't know the author's name).
This
>is for Oracle 7.3.4.
>
>--------------------------------------------------------------------------
>rem
>rem file: mapper.sql
>rem parameters: the tablespace name being mapped
>rem
>rem Sample invocation:
>rem @mapper SYSTEM
>rem
>rem This script generates a mapping of the space usage
>rem (free space vs used) in a tablespace. It graphically
>rem shows segment and free space fragmentation.
>rem
>set pagesize 66 linesize 132 verify off
>ttitle 'Map of Tablespace ' &&1 right datevar skip 1
>column substr(file_id,1,4) heading "File|Id"
>column bytes format 999,999,999,999
>column today noprint new_value datevar
>
>SELECT
>to_char(sysdate, 'MM/DD/YY') today,
>'free space' owner, /*"owner" of free space*/
>' ' object, /*blank object name*/
>substr(file_id,1,4), /*file ID for the extent header*/
>block_id, /*block ID for the extent header*/
>blocks, /*lengthof the extent in blocks*/
>bytes /*length of the extent in bytes*/
>FROM sys.dba_free_space
>WHERE tablespace_name = upper('&&1')
>UNION
>SELECT
>to_char(sysdate, 'MM/DD/YY') today,
>substr(owner,1,10), /*owner name (first 20 chars)*/
>substr(segment_name,1,27), /*segment name (first 26 chars)*/
>substr(file_id,1,4), /*file ID for extent header*/
>block_id, /*block ID for block header*/
>blocks, /*length of the extent in blocks*/
>bytes /*length of the extent in bytes*/
>FROM sys.dba_extents
>WHERE tablespace_name = upper('&&1')
>ORDER BY 4,5
>
>/
>undefine 1
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author:
> INET: tday6_at_csc.com
>
>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).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: carmichr_at_hotmail.com 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: tday6_at_csc.com 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 Wed Jul 18 2001 - 11:33:23 CDT
 |
 |