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
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 *
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
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:
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
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
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
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
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:
I like to use this SQL*Plus script:
-- Begin
script --
/**
* File: spc.sql
* Type: SQL*Plus script
* Author: Tim Gorman (Evergreen Database Technologies, Inc.)
*
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,
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
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
13 matches
Mail list logo