Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Simple DBA Type Question

RE: Simple DBA Type Question

From: Rajesh Dayal <Rajesh_at_ohitelecom.com>
Date: Mon, 21 Aug 2000 19:24:07 +0400
Message-Id: <10596.115108@fatcity.com>


Hi Peter,

You can Use this to check overall database size

select sum(bytes)/1024/1024 Total_Size_in_MB from dba_data_files ;

Otherwise you can Use this to check individual table's size

SELECT SEGMENT_NAME, BYTES FROM DBA_SEGMENTS WHERE SEGMENT_NAME = &TABLE_NAME ; HTH,
Rajesh
-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Peter Hazelton
Sent: Monday, August 21, 2000 6:45 PM
To: Multiple recipients of list ORACLE-L Subject: Simple DBA Type Question

Hi guys

Real quick question here! Using SQL plus, how can I determine the physical
size of my database? If that cannot be done, is there a way to see the size
of individual tables?

Thanks a lot

Peter



Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
-- 
Author: Peter Hazelton
  INET: peterhazelton_at_hotmail.com

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: ListGuru_at_fatcity.com (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).
Received on Mon Aug 21 2000 - 10:24:07 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US