DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 14

Thread: How To Determine Data Size Of A Table

  1. #1
    Join Date
    Feb 2001
    Location
    alexandria
    Posts
    100

    Smile How To Determine Data Size Of A Table

    Hi all I need a refresher, how do you determine the size of the data in the table?

    Thanks

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    average row length and number of rows from user_tables, as long as you've recently analyzed.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Feb 2001
    Location
    alexandria
    Posts
    100

    Talking

    thanks so much

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    or look at user_segments, will always be up to date

  5. #5
    Join Date
    Feb 2001
    Location
    alexandria
    Posts
    100

    hello

    is that row num + average number of rows?

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    no, * not +

  7. #7
    Join Date
    Feb 2001
    Location
    alexandria
    Posts
    100
    thanks!

  8. #8
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Quote Originally Posted by davey23uk
    or look at user_segments, will always be up to date
    ... but possibly misleading, if you want the amount of data contained in the segment.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  9. #9
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    well a table is a segment no?

  10. #10
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Yes, but it could be empty of data.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

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