Sunday, October 28, 2012

Tablespace (APPS_TS_MEDIA ) is growing



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