Home » RDBMS Server » Server Administration » Table size with BLOB column (CM merged 2) (oracle 12c Windows 2012)
Table size with BLOB column (CM merged 2) [message #673485] Wed, 21 November 2018 06:08 Go to next message
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.

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


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

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:
--------------

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

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

Regards
M.Krish
Table size with BLOB column [message #673486 is a reply to message #673485] Wed, 21 November 2018 06:08 Go to previous messageGo to next message
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.

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


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

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:
--------------

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

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

Regards
M.Krish
Re: Table size with BLOB column [message #673488 is a reply to message #673486] Wed, 21 November 2018 06:22 Go to previous messageGo to next message
gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK
Senior Member
Google told me this Smile
Re: Table size with BLOB column [message #673514 is a reply to message #673488] Wed, 21 November 2018 23:14 Go to previous message
muthukrish104
Messages: 82
Registered: November 2017
Member
Hi Gazzag,

Thanks for the help.

Regards
M.krish
Previous Topic: Interview question
Next Topic: Dropping private synonyms
Goto Forum:
  


Current Time: Fri Mar 29 00:10:06 CDT 2024