Database Administration (MOSC)

MOSC Banner

securefile size compress ratio

Hi all,

import from 11g -> 19c pdb : transform=lob_storage:securefile

I can't believe it. securefile compress a lot going from 300M -> 130K bytes

in 11g, blob

lobsegment SYS_LOB000099999C00010$$ 293,601,280    bytes

import to 19c securefile

lobsegment SYS_LOB000012345C00010$$ 131, 072 bytes

Anybody have used securefile before? Is that really compress that much?

Thanks. Appreciate your help!


friendly

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