step 1: select * from
(select SEGMENT_NAME, sum(bytes)
from dba_segments where TABLESPACE_NAME='APPS_TS_MEDIA'
group by segment_name order by 2 desc)
where rownum <= 10;
Step 2:
Use the following query to find out currently
set value for PCTVERSION:
select PCTVERSION from
dba_lobs where TABLE_NAME = 'FND_LOBS' and
COLUMN_NAME='FILE_DATA';
PCTVERSION
----------
10
Step 3:
PCTVERSION can be changed using
the following SQL (it can be run anytime in a running system):
ALTER TABLE FND_LOBS MODIFY LOB (FILE_DATA) ( PCTVERSION 0 );
Ref: 298698.1
No comments:
Post a Comment