RE: DB Size script
You can get the size of database using DBA studio. Which gives separately
the actual space consumed by the data and the size of table spaces.
Aleem
-Original Message-
Sent: Tuesday, May 07, 2002 3:39 AM
To: Multiple recipients of list ORACLE-L
Subject:Re: DB Size script
One more script from this list with slight changes. For 8i or up.
SELECT 'The database size is '|| round( (df.sum + rd.sum + tm.sum) / ( 1024
* 1024 * 1024 ) )
|| ' GB excluding INI, password and control files'
FROM
(SELECT SUM(bytes) sum FROM sys.dba_data_files) df,
(SELECT SUM(bytes * members) sum FROM v$log) rd,
(SELECT SUM(bytes) sum FROM sys.dba_temp_files) tm
/
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Fri, 03 May 2002 08:23:24 -0800
I like to use this SQL*Plus script:
-- Begin
script --
/**
* File: spc.sql
* Type: SQL*Plus script
* Author: Tim Gorman (Evergreen Database Technologies, Inc.)
* Date: 10-Oct-97
*
* Description:
* SQL*Plus script to display database space usage.
*
* Modifications:
* TGorman 11mar02 added support for AUTOEXTENSIBLE data files
*/
col tablespace format a25
col owner format a20
col type format a19
col sort1 noprint
col mb format 999,990.00
clear breaks
clear compute
break on report on tablespace on owner on type
set echo off feedback off timing off pagesize 66 verify off trimspool on
col instance new_value V_INSTANCE noprint
select instance from v$thread;
spool spc_&&V_INSTANCE
select tablespace_name tablespace,
owner,
'a' sort1,
segment_type type,
sum(bytes)/1048576 mb
from dba_segments
group by tablespace_name, owner, segment_type
union all
select tablespace,
username owner,
'b' sort1,
segtype type,
sum(blocks)/128 mb
from v$sort_usage
group by tablespace, username, segtype
union all
select tablespace_name tablespace,
'' owner,
'c' sort1,
'---total---' type,
sum(bytes)/1048576 mb
from dba_segments
group by tablespace_name
union all
select tablespace,
'' owner,
'd' sort1,
'---total---' type,
sum(blocks)/128 mb
from v$sort_usage
group by tablespace
union all
select tablespace_name tablespace,
'' owner,
'e' sort1,
'-allocated-' type,
sum(bytes)/1048576 mb
from dba_data_files
group by tablespace_name
union all
select tablespace_name tablespace,
'' owner,
'f' sort1,
'-allocated-' type,
sum(bytes)/1048576 mb
from dba_temp_files
group by tablespace_name
union all
select tablespace_name tablespace,
'' owner,
'g' sort1,
'allocatable' type,
sum(decode(autoextensible,'YES',maxbytes,bytes))/1048576 mb
from dba_data_files
group by tablespace_name
union all
select tablespace_name tablespace,
'' owner,
'h' sort1,
'allocatable' type,
sum(decode(autoextensible,'YES',maxbytes,bytes))/1048576 mb
from dba_temp_files
group by tablespace_name
union all
select tablespace_name tablespace,
'' owner,
'i' sort1,
'' type,
to_number('') mb
from dba_tablespaces
union all
select tablespace,
owner,
sort1,
type,
sum(mb)
from (select '' tablespace,
'Total' owner,
'a' sort1,
'Used' type,
sum(bytes)/1048576 mb
from dba_segments
union all
select '' tablespace,
'Total' owner,
'a' sort1,
'Used' type,
sum(blocks)/128 mb
from v$sort_usage)
group by tablespace, owner, sort1, type
union all
select tablespace,
owner,
sort1,
type,
sum(mb)
from (select '' tablespace,
'Total' owner,
'b' sort1,
'Allocated' type,
sum(bytes)/1048576 mb
from dba_data_files
union all
select '' tablespace,
'Total' owner,
'b' sort1,
'Allocated' type,
sum(bytes)/1048576 mb
from dba_temp_files)
group by tablespace, owner, sort1, type
union all
select tablespace,
owner,
sort1,
type,
sum(mb)
from (select '' tablespace,
'Total' owner,
'c' sort1,
'Allocatable' type,
sum(decode(autoextensible,'YES',maxbytes,bytes))/1048576 mb
from dba_data_files
union all
select '' tablespace,
'Total' owner,
'c' sort1,
'Allocatable' type,
sum(decode(autoextensible,'YES',maxbytes,bytes))/1048576 mb
from dba_temp_files)
group by tablespace, owner, sort1, type
order by 1, 2, 3, 4;
sp
Re: DB Size script
One more script from this list with slight changes. For 8i or up.
SELECT 'The database size is '|| round( (df.sum + rd.sum + tm.sum) / ( 1024
* 1024 * 1024 ) )
|| ' GB excluding INI, password and control files'
FROM
(SELECT SUM(bytes) sum FROM sys.dba_data_files) df,
(SELECT SUM(bytes * members) sum FROM v$log) rd,
(SELECT SUM(bytes) sum FROM sys.dba_temp_files) tm
/
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Fri, 03 May 2002 08:23:24 -0800
I like to use this SQL*Plus script:
-- Begin
script --
/**
* File: spc.sql
* Type: SQL*Plus script
* Author: Tim Gorman (Evergreen Database Technologies, Inc.)
* Date: 10-Oct-97
*
* Description:
* SQL*Plus script to display database space usage.
*
* Modifications:
* TGorman 11mar02 added support for AUTOEXTENSIBLE data files
*/
col tablespace format a25
col owner format a20
col type format a19
col sort1 noprint
col mb format 999,990.00
clear breaks
clear compute
break on report on tablespace on owner on type
set echo off feedback off timing off pagesize 66 verify off trimspool on
col instance new_value V_INSTANCE noprint
select instance from v$thread;
spool spc_&&V_INSTANCE
select tablespace_name tablespace,
owner,
'a' sort1,
segment_type type,
sum(bytes)/1048576 mb
from dba_segments
group by tablespace_name, owner, segment_type
union all
select tablespace,
username owner,
'b' sort1,
segtype type,
sum(blocks)/128 mb
from v$sort_usage
group by tablespace, username, segtype
union all
select tablespace_name tablespace,
'' owner,
'c' sort1,
'---total---' type,
sum(bytes)/1048576 mb
from dba_segments
group by tablespace_name
union all
select tablespace,
'' owner,
'd' sort1,
'---total---' type,
sum(blocks)/128 mb
from v$sort_usage
group by tablespace
union all
select tablespace_name tablespace,
'' owner,
'e' sort1,
'-allocated-' type,
sum(bytes)/1048576 mb
from dba_data_files
group by tablespace_name
union all
select tablespace_name tablespace,
'' owner,
'f' sort1,
'-allocated-' type,
sum(bytes)/1048576 mb
from dba_temp_files
group by tablespace_name
union all
select tablespace_name tablespace,
'' owner,
'g' sort1,
'allocatable' type,
sum(decode(autoextensible,'YES',maxbytes,bytes))/1048576 mb
from dba_data_files
group by tablespace_name
union all
select tablespace_name tablespace,
'' owner,
'h' sort1,
'allocatable' type,
sum(decode(autoextensible,'YES',maxbytes,bytes))/1048576 mb
from dba_temp_files
group by tablespace_name
union all
select tablespace_name tablespace,
'' owner,
'i' sort1,
'' type,
to_number('') mb
from dba_tablespaces
union all
select tablespace,
owner,
sort1,
type,
sum(mb)
from (select '' tablespace,
'Total' owner,
'a' sort1,
'Used' type,
sum(bytes)/1048576 mb
from dba_segments
union all
select '' tablespace,
'Total' owner,
'a' sort1,
'Used' type,
sum(blocks)/128 mb
from v$sort_usage)
group by tablespace, owner, sort1, type
union all
select tablespace,
owner,
sort1,
type,
sum(mb)
from (select '' tablespace,
'Total' owner,
'b' sort1,
'Allocated' type,
sum(bytes)/1048576 mb
from dba_data_files
union all
select '' tablespace,
'Total' owner,
'b' sort1,
'Allocated' type,
sum(bytes)/1048576 mb
from dba_temp_files)
group by tablespace, owner, sort1, type
union all
select tablespace,
owner,
sort1,
type,
sum(mb)
from (select '' tablespace,
'Total' owner,
'c' sort1,
'Allocatable' type,
sum(decode(autoextensible,'YES',maxbytes,bytes))/1048576 mb
from dba_data_files
union all
select '' tablespace,
'Total' owner,
'c' sort1,
'Allocatable' type,
sum(decode(autoextensible,'YES',maxbytes,bytes))/1048576 mb
from dba_temp_files)
group by tablespace, owner, sort1, type
order by 1, 2, 3, 4;
spool off
-- End script --
If you want a version with all the formatting intact, you can download it
from www.EvDBT.com/library.htm...
Hope this helps...
-Tim
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, May 03, 2002 8:53 AM
Hi all,
How could one collect data from an Oracle Server to respond to the question:
"How big is (what is the size of your) Database ?"
Thaking you,
---
CSW
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Simon Waibale
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself fr
RE: DB Size
Physical --- CSW -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Friday, May 03, 2002 7:33 PM To: Multiple recipients of list ORACLE-L Physical size (disk) or logical size (bytes of actual data)? Scott Shafer San Antonio, TX 210-581-6217 > -Original Message- > From: Simon Waibale [SMTP:[EMAIL PROTECTED]] > Sent: Friday, May 03, 2002 9:53 AM > To: Multiple recipients of list ORACLE-L > Subject: DB Size > > Hi all, > How could one collect data from an Oracle Server to respond to the > question: > "How big is (what is the size of your) Database ?" > > Thaking you, > > --- > CSW > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Simon Waibale > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Simon Waibale INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Fwd: Re: DB Size
SELECT SUM(BYTES) FROM ( SELECT BYTES FROM sys.DBA_DATA_FILES UNION ALL SELECT BYTES FROM sys.DBA_TEMP_FILES ) ; it's in bytes not kB or MB JP On Fri 3. May 2002 16:53, you wrote: > Hi all, > How could one collect data from an Oracle Server to respond to the > question: "How big is (what is the size of your) Database ?" > > Thaking you, > > --- > CSW --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: DB Size
Physical size (disk) or logical size (bytes of actual data)? Scott Shafer San Antonio, TX 210-581-6217 > -Original Message- > From: Simon Waibale [SMTP:[EMAIL PROTECTED]] > Sent: Friday, May 03, 2002 9:53 AM > To: Multiple recipients of list ORACLE-L > Subject: DB Size > > Hi all, > How could one collect data from an Oracle Server to respond to the > question: > "How big is (what is the size of your) Database ?" > > Thaking you, > > --- > CSW > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Simon Waibale > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: DB Size
I like to use this SQL*Plus script:
-- Begin
script --
/**
* File: spc.sql
* Type: SQL*Plus script
* Author: Tim Gorman (Evergreen Database Technologies, Inc.)
* Date: 10-Oct-97
*
* Description:
* SQL*Plus script to display database space usage.
*
* Modifications:
* TGorman 11mar02 added support for AUTOEXTENSIBLE data files
*/
col tablespace format a25
col owner format a20
col type format a19
col sort1 noprint
col mb format 999,990.00
clear breaks
clear compute
break on report on tablespace on owner on type
set echo off feedback off timing off pagesize 66 verify off trimspool on
col instance new_value V_INSTANCE noprint
select instance from v$thread;
spool spc_&&V_INSTANCE
select tablespace_name tablespace,
owner,
'a' sort1,
segment_type type,
sum(bytes)/1048576 mb
from dba_segments
group by tablespace_name, owner, segment_type
union all
select tablespace,
username owner,
'b' sort1,
segtype type,
sum(blocks)/128 mb
from v$sort_usage
group by tablespace, username, segtype
union all
select tablespace_name tablespace,
'' owner,
'c' sort1,
'---total---' type,
sum(bytes)/1048576 mb
from dba_segments
group by tablespace_name
union all
select tablespace,
'' owner,
'd' sort1,
'---total---' type,
sum(blocks)/128 mb
from v$sort_usage
group by tablespace
union all
select tablespace_name tablespace,
'' owner,
'e' sort1,
'-allocated-' type,
sum(bytes)/1048576 mb
from dba_data_files
group by tablespace_name
union all
select tablespace_name tablespace,
'' owner,
'f' sort1,
'-allocated-' type,
sum(bytes)/1048576 mb
from dba_temp_files
group by tablespace_name
union all
select tablespace_name tablespace,
'' owner,
'g' sort1,
'allocatable' type,
sum(decode(autoextensible,'YES',maxbytes,bytes))/1048576 mb
from dba_data_files
group by tablespace_name
union all
select tablespace_name tablespace,
'' owner,
'h' sort1,
'allocatable' type,
sum(decode(autoextensible,'YES',maxbytes,bytes))/1048576 mb
from dba_temp_files
group by tablespace_name
union all
select tablespace_name tablespace,
'' owner,
'i' sort1,
'' type,
to_number('') mb
from dba_tablespaces
union all
select tablespace,
owner,
sort1,
type,
sum(mb)
from (select '' tablespace,
'Total' owner,
'a' sort1,
'Used' type,
sum(bytes)/1048576 mb
from dba_segments
union all
select '' tablespace,
'Total' owner,
'a' sort1,
'Used' type,
sum(blocks)/128 mb
from v$sort_usage)
group by tablespace, owner, sort1, type
union all
select tablespace,
owner,
sort1,
type,
sum(mb)
from (select '' tablespace,
'Total' owner,
'b' sort1,
'Allocated' type,
sum(bytes)/1048576 mb
from dba_data_files
union all
select '' tablespace,
'Total' owner,
'b' sort1,
'Allocated' type,
sum(bytes)/1048576 mb
from dba_temp_files)
group by tablespace, owner, sort1, type
union all
select tablespace,
owner,
sort1,
type,
sum(mb)
from (select '' tablespace,
'Total' owner,
'c' sort1,
'Allocatable' type,
sum(decode(autoextensible,'YES',maxbytes,bytes))/1048576 mb
from dba_data_files
union all
select '' tablespace,
'Total' owner,
'c' sort1,
'Allocatable' type,
sum(decode(autoextensible,'YES',maxbytes,bytes))/1048576 mb
from dba_temp_files)
group by tablespace, owner, sort1, type
order by 1, 2, 3, 4;
spool off
-- End script --
If you want a version with all the formatting intact, you can download it
from www.EvDBT.com/library.htm...
Hope this helps...
-Tim
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, May 03, 2002 8:53 AM
Hi all,
How could one collect data from an Oracle Server to respond to the question:
"How big is (what is the size of your) Database ?"
Thaking you,
---
CSW
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Simon Waibale
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: Tim Gorman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
Re: DB Size
SELECT SUM(BYTES) FROM ( SELECT BYTES FROM sys.DBA_DATA_FILES UNION ALL SELECT BYTES FROM sys.DBA_TEMP_FILES ) ; it's in bytes not kB or MB JP On Fri 3. May 2002 16:53, you wrote: > Hi all, > How could one collect data from an Oracle Server to respond to the > question: "How big is (what is the size of your) Database ?" > > Thaking you, > > --- > CSW -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: DB Size
select sum(bytes) from dba_extents; This is a quick and easy though not totally accurate. Not every row in every block will be filled. Simon Waibale <[EMAIL PROTECTED]> Sent by: rootcc: Subject: DB Size 05/03/2002 10:53 AM Please respond to ORACLE-L Hi all, How could one collect data from an Oracle Server to respond to the question: "How big is (what is the size of your) Database ?" Thaking you, --- CSW -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Simon Waibale INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Thomas Day INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: DB Size
A good question for a friday afternoon before a bank-holiday weekend... Query the data dictionary to get the names and locations of the data files: select file_name, tablespace_name, bytes from dba_data_files; That will give you the size of all the files for data, indexes, rollback segments, the temporary area, the system tablespace, etc. There are other bits it won't tell you about (Config files, online redologs, archived logs) but they're another story. This doesn't tell you how much of that space actually has data in it if that's what you meant, just how much space things are taking on the disks. What all these numbers actually mean is a much longer and more difficult question, best left 'till next week. Simon Anderson Please respond to [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc:(bcc: Simon Anderson/SSplc) Hi all, How could one collect data from an Oracle Server to respond to the question: "How big is (what is the size of your) Database ?" Thaking you, --- CSW -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Simon Waibale INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: DB Size
Try this: spool files.txt set pagesize 60 set linesize 80 col name format a55 heading "Control Files" select name from sys.v_$controlfile / col name format a22 heading "Dump / ARCH Files" col value format a55 heading "Location" select name, value from sys.v_$parameter where name like '%archive_dest%' or name like '%dump_dest%' / col group# format 99 heading Group col status format a8 heading Status col member format a55 heading "Redo Logs" col mb format heading MB select a.group#,b.status,b.archived,a.member,round(b.bytes/1024000) mb from sys.v_$logfile a, sys.v_$log b where a.group# = b.group# / set pagesize 60 set linesize 80 col statusformat a3 heading Sta col Idformat 99 heading ID col Mbyte format 99 heading MBYTE col name format a55 heading "Database Data Files" break on report compute sum of Mbyte on report select F.file_id Id, F.file_name name, F.bytes/(1024*1024) Mbyte, decode(F.status,'AVAILABLE','OK',F.status) status from sys.dba_data_files F order by Id / spool off -Original Message- Sent: Friday, May 03, 2002 9:53 AM To: Multiple recipients of list ORACLE-L Hi all, How could one collect data from an Oracle Server to respond to the question: "How big is (what is the size of your) Database ?" Thaking you, --- CSW -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Simon Waibale INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Smith, Ron L. INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: DB Size
you really might want to read the manuals -- specifically the reference manual on dba_data_files select sum(bytes) from dba_data_files will tell you the total size (in bytes) of all the datafiles in your database. There will also be space used by the control files, redo log files, archived log files and binaries etc. |+---> || | || | || [EMAIL PROTECTED]| || o.ug | || | || 05/03/2002 | || 10:53 AM | || Please | || respond to | || ORACLE-L | || | |+---> >| || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: DB Size | >| Hi all, How could one collect data from an Oracle Server to respond to the question: "How big is (what is the size of your) Database ?" Thaking you, --- CSW -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Simon Waibale INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: DB SIZE ?
delete data or drop tablespaces or resize datafiles. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, December 12, 2001 12:20 PM > > hi > Just a thought.How do we reduce Database size? > Thanks > -Seema > > > _ > Send and receive Hotmail on your mobile device: http://mobile.msn.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Seema Singh > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: DB SIZE ?
Seema, Several possible solutions - you pick. - Delete Data - Drop Tables - Drop Indexes - Drop Tablespaces That ought to get you started. ;-) Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Sent: Wednesday, December 12, 2001 12:20 PM To: Multiple recipients of list ORACLE-L hi Just a thought.How do we reduce Database size? Thanks -Seema -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
