RE: DB Size

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

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 *

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

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:

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

Re: DB Size

| || | |+--- | || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: DB Size | | Hi all, How could one collect data from an Oracle Server to respond

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

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

Re: DB Size

: Subject: DB Size 05/03/2002

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:

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.) *

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

DB SIZE INCREASE AFTER EXPORT/IMPORT?

Hi I have done export and import of one schema.After import the database size has increased and I checked the tablespace which are having LOB objects grow just twice approximately.What could be reason? Thx Seema _ Send and

DB SIZE ?

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

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

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

DB size question?

Hi If redo log files are multiplexed in database. In computation of Database size is multiplexed redo log files size would be consider or not? Thanks -Seema _ Get your FREE download of MSN Explorer at

RE: Large DB Size? Manage datafiles?

recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Large DB Size? Manage datafiles? Date: Wed, 14 Mar 2001 05:20:27 -0800 MIME-Version: 1.0 Received: from localhost (localhost [127.0.0.1])by parents.the-testas.net (8.9.3/8.8.7) with ESMTP id JAA11449for jtestamail@localhost; Wed, 14 Mar 200