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

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 * mem

RE: DB Size

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

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 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:

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

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 Thomas Day
<[EMAIL PROTECTED]> Sent by: rootcc: Subject: D

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 segme

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 '%arch

Re: DB Size

2002-05-03 Thread Rachel_Carmichael
E-L | || | |+---> >| || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: DB Size | >| Hi all, How could one collect data from an Oracle Serve

DB Size

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

DB SIZE INCREASE AFTER EXPORT/IMPORT?

2002-02-15 Thread Seema Singh
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 receive

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 > > > __

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 www.iNetProf

DB SIZE ?

2001-12-12 Thread Seema Singh
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

DB size question?

2001-08-21 Thread Seema Singh
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 http://explorer.msn.com/intl.as

RE: Large DB Size? Manage datafiles?

2001-03-14 Thread Joseph Testa
OTECTED] >To: Multiple 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 J

RE: Large DB Size? Manage datafiles?

2001-03-14 Thread Joan Hsieh
Our typical databases right now are 800gb size. Each datafile is 4gb on raw disk (HP or SUNOS). One tablespace can have 85 datafiles. The data we deal with are blobs. The performance is not that good. Lots of problem. This place is not easy to change things. I think we should partition the table o

Large DB Size? Manage datafiles?

2001-03-13 Thread Yuzie
Dear All DBAs, So far, I only manage small Oracle databases, size between 30-40 GB (all datafiles). I just want to know how you will manage large Oracle database with 100 or more GB. What size is the largest database size you ever manage? How much data files and tablespaces you use for that datab