RE: Table Size

I think we can use dbms_space_admin package to get the accurate size of the table...not the allocated (querying the data dictionary will report the allocated space...)

Murali.

|---------+---------------------------->


|         |           "Goulet, Dick"   |

|         |           <DGoulet_at_vicr.com|

|         |           >                |

|         |           Sent by:         |

|         |           ml-errors_at_fatcity|

|         |           .com             |

|         |                            |

|         |                            |

|         |           10/15/2003 05:24 |

|         |           PM               |

|         |           Please respond to|

|         |           ORACLE-L         |

|         |                            |

|---------+---------------------------->
  >--------------------------------------------------------------------------------------------------------------|
  |                                                                                                              |
  |       To:       Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>                                  |
  |       cc:                                                                                                    |
  |       Subject:  RE: Table Size                                                                               |
  >--------------------------------------------------------------------------------------------------------------|

Then the easy answer is:

select sum(nvl(vsize(<column_1>),1)+nvl(vsize(<column_2>),1)+...... )/1073741824
from <table_name>;

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

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

      All the tables already exist and have data.

      Thanks a lot for your response,
      Rajesh
            -----Original Message-----
            From: Goulet, Dick [mailto:DGoulet_at_vicr.com]
            Sent: Wednesday, October 15, 2003 12:45 PM
            To: Multiple recipients of list ORACLE-L
            Subject: RE: Table Size

            Raj,

                Does the table already exist & have data or are you looking
            for a gestimate?



            Dick Goulet
            Senior Oracle DBA
            Oracle Certified 8i DBA


                  -----Original Message-----
                  From: Pillai, Rajesh [mailto:Rajesh.Pillai_at_nordstrom.com]
                  Sent: Wednesday, October 15, 2003 3: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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: Murali_Pavuloori/Claritas_at_claritas.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).