size of a table
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: size of a table

  1. #1
    Join Date
    Nov 2000
    Posts
    157
    could you please tell me how to find out the SIZE OF A TABLE.(QUERY)

    Thanks
    Ravi
    ravi

  2. #2
    Join Date
    Nov 1999
    Location
    Saint Charles, MO, US
    Posts
    3
    user the dba_segments view.
    Hail Oracle !



  3. #3
    Join Date
    Nov 2000
    Posts
    157

    table size

    can u give me the query to find the size of a table

    thanks
    ravi
    ravi

  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    check the dba_tables

    Sam

  5. #5
    Join Date
    Nov 2000
    Posts
    157

    figured out

    hey guys

    u can use this query to find out the size of a table:



    select owner||'.'||segment_name Segment_Name
    , segment_type "Segment Type"
    , sum(bytes)/1024/1024 "Size In MB"
    from dba_segments
    group by owner||'.'||segment_name
    , segment_type;

    Ravi
    ravi

  6. #6
    Join Date
    Nov 2000
    Posts
    17

    Cool

    When i try to log into SQLplus, i get logged on with an error to run the PUPBLD script. I have run that script twice already as sys and still get the error message. When i query any table, i get an error that the table or view does not exist. When i query the same views in svrmgr, the statement is processed.Please help explain.
    mane

  7. #7
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Hi

    you run pupbld.sql as SYSTEM not as SYS
    The size of a table you need to analyze the table first to get the statistics and query dba_tables

    num_rows* avg length (or smth I forgot thisa column name)

    querying dba_segments is a wrong choice

  8. #8
    Join Date
    Oct 2000
    Posts
    34

    [url]http://www.oracle.com/oramag/code/tips2000/Tip1.html[/url]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width