Home » RDBMS Server » Server Administration » Blob inquiries on sizes
Blob inquiries on sizes [message #273052] Mon, 08 October 2007 23:12 Go to next message
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.
Re: Blob inquiries on sizes [message #273064 is a reply to message #273052] Tue, 09 October 2007 00:11 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

select segment_name from dba_segments where segment_name like '%LOB%';

desc dba_segments;->bytes
Re: Blob inquiries on sizes [message #273084 is a reply to message #273064] Tue, 09 October 2007 01:22 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I think you meant: segment_type like '%LOB%'

Regards
Michel
Re: Blob inquiries on sizes [message #273098 is a reply to message #273052] Tue, 09 October 2007 01:48 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Oh! Yes.
Previous Topic: conversion of NLS_CHARACTERSET FROM AL32UTF8 TO UTF8
Next Topic: Partition
Goto Forum:
  


Current Time: Thu Dec 08 08:44:21 CST 2016

Total time taken to generate the page: 0.06732 seconds