Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

SQL to work out size in MB of rows in a table

782530Jan 21 2011 — edited Jan 27 2011
Hello all,

i am trying to work out the size of rows in a table in MB, as i am going to be doing some housekeeping on the table and i want to work out the size of the rows so i know how many i can delete at once (its a huge table.. so won't be able to delete all the rows required at once.. as it will fill up tempspace and crash)

Would i use something like VSIZE or avg_col_len ?

Thanks in advance for any help!

Ashleigh
This post has been answered by Nicosa-Oracle on Jan 21 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 24 2011
Added on Jan 21 2011
18 comments
2,392 views