OraFAQ Forum: Server Administration » Table size with BLOB column (CM merged 2)

Home » RDBMS Server » Server Administration » Table size with BLOB column (CM merged 2) (oracle 12c Windows 2012)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Table size with BLOB column (CM merged 2) [message #673485]

Wed, 21 November 2018 06:08

muthukrish104
Messages: 82
Registered: November 2017

Member

Hi,

Need your guidance,

When we found a table (Which has BLOB column) size in export dump file's log file. It shows 9GB.

Code: [Select all] [Show/ hide]

. . exported "TEST"."CENTAL"            9.00 GB   80450 rows

At the same time, if we query the table, it shows only 10MB size.

Code: [Select all] [Show/ hide]

SELECT s.owner,s.segment_name, sum(bytes)/1024/1024
                   FROM dba_SEGMENTS s
      WHERE s.segment_type = 'TABLE'
      and
      S.OWNER='TEST'
      AND
      S.SEGMENT_NAME='CENTAL'
group by s.segment_name,s.owner;

Output is here:
--------------

Code: [Select all] [Show/ hide]

OWNER	SEGMENT_NAME	SUM(BYTES)/1024/1024
------  ------------    --------------------
TEST	CENTAL	        9

How to get the exact size of the table of BLOB.

Regards
M.Krish

Report message to a moderator

Table size with BLOB column [message #673486 is a reply to message #673485]

Wed, 21 November 2018 06:08

muthukrish104
Messages: 82
Registered: November 2017

Member

Hi,

Need your guidance,

When we found a table (Which has BLOB column) size in export dump file's log file. It shows 9GB.

Code: [Select all] [Show/ hide]

. . exported "TEST"."CENTAL"            9.00 GB   80450 rows

At the same time, if we query the table, it shows only 10MB size.

Code: [Select all] [Show/ hide]

SELECT s.owner,s.segment_name, sum(bytes)/1024/1024
                   FROM dba_SEGMENTS s
      WHERE s.segment_type = 'TABLE'
      and
      S.OWNER='TEST'
      AND
      S.SEGMENT_NAME='CENTAL'
group by s.segment_name,s.owner;

Output is here:
--------------

Code: [Select all] [Show/ hide]

OWNER	SEGMENT_NAME	SUM(BYTES)/1024/1024
------  ------------    --------------------
TEST	CENTAL	        9

How to get the exact size of the table of BLOB.

Regards
M.Krish

Report message to a moderator

Re: Table size with BLOB column [message #673488 is a reply to message #673486]

Wed, 21 November 2018 06:22

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

Google told me this Smile

Report message to a moderator

Re: Table size with BLOB column [message #673514 is a reply to message #673488]

Wed, 21 November 2018 23:14

muthukrish104
Messages: 82
Registered: November 2017

Member

Hi Gazzag,

Thanks for the help.

Regards
M.krish

Report message to a moderator

Previous Topic:	Interview question
Next Topic:	Dropping private synonyms

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 13:40:42 CDT 2025