Database Administration (MOSC)

MOSC Banner

When LOB_DATA/LOB_INDEX is created

edited Apr 12, 2017 5:01AM in Database Administration (MOSC) 4 commentsAnswered

Hi,

under which circumstances does oracle create LOB_DATA and LOB_INDEX segments in temporary tablespace? In my case it happens if a select is issued through a jdbc interface. The view (object view) which is selected has no LOB column at all. The problem is now that this LOB_DATA and LOB_INDEX segment stays in the tablespace until the session gets disconnected.

I know LOBs need to get freed explicitly when you select them, but why are there LOB segments when not even selecting a LOB column?

regards,

Mathias

Tagged:

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