Performance - EBS (MOSC)

MOSC Banner

FND_LOBS reclaim space

edited Feb 5, 2014 5:31PM in Performance - EBS (MOSC) 21 commentsAnswered

Hi All,

EBS R12.1.3 , DB 11.2.0.2 RAC 2 nodes

I have recently Reclaimed the space from FND_LOBS table , but even after this , Total allocated space showing 135 GB , and when i see the space occupied is 61G only, please help in this how can i get back the space. I followed note

select
  owner                  username,
  segment_name           segment_name,
  segment_type           segment_type,
  bytes/1024/1024/1024   Gbytes,
  extents                extents
from
  dba_segments
where
  segment_name ='SYS_LOB0000034032C00004$$'

USERNAME SEGMENT_NAME      SEGMENT_TYPE  GBYTES                 EXTENTS

APPLSYS SYS_LOB0000034032C00004$$ LOBSEGMENT 135.297607421875 1108358

select sum(dbms_lob.getlength(file_data))/1024/1024/1024 GB from   applsys.fnd_lobs;

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

EBS Performance Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center