Home > IT Answers > Oracle > Calculate SIze of Oracle Table with BLOB column and BLOB Index
Hmhora
10 pts.
 Calculate SIze of Oracle Table with BLOB column and BLOB Index
Oracle Table, Oracle Table Size
I have a 30 GB table with BLOB column and BLOB INDEX. However, when I used Toad to look at the BLOB INDEX, it is a system generated and have NO COLUMN. Question 1: How do I calculate the actual size of thhe BLOB table, BLOB index, etc ... Question 2: How do I determine if this BLOB table and BLOB INDEXES need to be reorganized (HWM, Actual used, etc)

Software/Hardware used:
ASKED: February 5, 2009  5:01 PM
UPDATED: February 5, 2009  5:07 PM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _