RE: DB Size

2002-05-06 Thread Simon Waibale
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

Re: DB Size script

2002-05-06 Thread Mohammad Rafiq
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 *

RE: DB Size script

2002-05-06 Thread Abdul Aleem
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

Fwd: Re: DB Size

2002-05-04 Thread Jan Pruner
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:

Re: DB Size

2002-05-03 Thread Rachel_Carmichael
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

RE: DB Size

2002-05-03 Thread Smith, Ron L.
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

Re: DB Size

2002-05-03 Thread Simon . Anderson
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

Re: DB Size

2002-05-03 Thread Thomas Day
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

Re: DB Size

2002-05-03 Thread Jan Pruner
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:

Re: DB Size

2002-05-03 Thread Tim Gorman
I like to use this SQL*Plus script: -- Begin script -- /** * File: spc.sql * Type: SQL*Plus script * Author: Tim Gorman (Evergreen Database Technologies, Inc.) *

RE: DB Size

2002-05-03 Thread Scott . Shafer
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,

RE: DB SIZE ?

2001-12-12 Thread Jack C. Applewhite
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

Re: DB SIZE ?

2001-12-12 Thread Scott Shafer
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