Database Administration (MOSC)

MOSC Banner

Acceleration of NCLOB compression

edited Nov 13, 2019 9:07PM in Database Administration (MOSC) 4 commentsAnswered ✓

  Hello!

in my Lob-table I see this datae allocation (Oracle 12.2)

select

  dbms_lob.getlength(source_data) bytes, count(1) distinct 

  from user1.Lob_table

  group by dbms_lob.getlength(source_data)

order by 2 desc

BYTES      DISTINCT

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

....

385               671767

295          

965257

9051575

If I correctly understand,

- most part of column contains only locators without secure files ?

- in my table 9051575 filds become empty after DML-operations ?

- what can I do to accelerate very long  "alter table" operation

  "alter table user1.Lob_table modify lob(source_data) (compress high);" ?

regards,

Paul

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center