Oracle-L: RE: Table Size

From: Thomas Day <tday6_at_csc.com>
Date: Wed, 15 Oct 2003 12:49:26 -0800
Message-ID: <F001.005D342B.20031015124926@fatcity.com>

This will get you that actual bytes used by the data in the table; however, it will hit every row in the table and take a long time to run. It takes one parameter, the table being sized.

rem ****************************************************

rem this code was inspired by Kevin Loney

rem ****************************************************

set verify off;
set pages 24;
select COUNT(DISTINCT(SUBSTR(a.ROWID,1,16)))* b.value Bytes_Used from &&1 a,
v$parameter b where b.name = 'db_block_size' group by b.value /

                                                                                                                                       
                      "Pillai, Rajesh"                                                                                                 
                      <Rajesh.Pillai           To:      Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>                    
                      @nordstrom.com>          cc:                                                                                     
                      Sent by:                 Subject: RE: Table Size                                                                 
                      ml-errors                                                                                                        
                                                                                                                                       
                                                                                                                                       
                      10/15/2003 04:19                                                                                                 
                      PM                                                                                                               
                      Please respond                                                                                                   
                      to ORACLE-L

Allan,

I cannot run stats on the table

Regards,
Rajesh

      -----Original Message-----
      From: Nelson, Allan [mailto:anelson_at_midf.com]
      Sent: Wednesday, October 15, 2003 12:54 PM
      To: Multiple recipients of list ORACLE-L
      Subject: RE: Table Size

      If you are running stats on this table or can run stats use
      dba_segements

      Allan
            -----Original Message-----
            From: Pillai, Rajesh [mailto:Rajesh.Pillai_at_nordstrom.com]
            Sent: Wednesday, October 15, 2003 2:24 PM
            To: Multiple recipients of list ORACLE-L
            Subject: Table Size

            Hi All,
                Could somebody help me in finding the actual size of an
            oracle table in GB.

            TIA,
            Rajesh




      ______________________________________________________________________________

      This email is intended solely for the person or entity to which it is
      addressed and may contain confidential and/or privileged information.
      Copying, forwarding or distributing this message by persons or
      entities other than the addressee is prohibited. If you have received
      this email in error, please contact the sender immediately and delete
      the material from any computer. This email may have been monitored
      for policy compliance. [021216]

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Thomas Day
INET: tday6_at_csc.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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 Wed Oct 15 2003 - 15:49:26 CDT