Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Get storage size of CLOB column within a table

Chaka1313Aug 28 2019 — edited Aug 29 2019

Hi all!

We are experiencing an issue where tons of rows are being inserted within a clob column and we are trying to determine what the size of the entire column is. We have the table size, but we'd like to know just how much this one column is taking up so that we can shrink it down and reduce the space within that table. Is there a query that anyone can provide that can determine this?

Comments

Gaz in Oz

Leave the SQL Developer history files format alone.

If you want to get the "timestamp" into readable format, then you can convert the epoch timestamp into readable form using:

alter session set nls_timestamp_format = 'YYYY-MM-DD HH24:MI:SS.FF3';

SELECT to_timestamp('1970-01-01', 'yyyy-mm-dd') +

       numtodsinterval(1513762282594 / 1000, 'SECOND') readable

FROM   dual;

READABLE

--------------------------------

2017-12-20 09:31:22.594

...for example.

1 - 1

Post Details

Added on Aug 28 2019
11 comments
6,621 views