| Blob inquiries on sizes [message #273052] |
Mon, 08 October 2007 23:12  |
rkl1
Messages: 97
Registered: June 2005
|
Member |
|
|
Dear All,
I came across lately 3 tables with blob column in them. And the tables have several thousand rows. Now to get the correct size of these tables: (I used the sum(bytes) from user_segments), is that the correct way: since the table size came very low bytes number. And then the tablespace where these tables are stored has been almost filled up. That adds to my confusion (which happens to me all the times more than anybody else) since the tablespace is more than 2GB and containing only these 3 low lying tables (with their blob storage). Summing it up, I have 2 questions:
1. How to find out the correct size for the tables with blob column.
2. How to find out how much storage space being taken out by blob columns from a particular tablespace.
Thanks.
ps: any help,suggestion, advices, or what ever would be gladly accepted and remembered for a very long time.
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
