Re: APPS_TS_TX_IDX growth rapidly.

Posted by raiq1 on
URL: http://erman-arslan-s-oracle-forum.114.s1.nabble.com/APPS-TS-TX-IDX-growth-rapidly-tp9397p9446.html

dear sir,

check the output for your below queries.


SQL> select bytes from dba_segments where segment_name ='SYS_LOB0001144624C00040$$' and owner ='APPLSYS';

     BYTES
----------
  55312384


SQL> SELECT TABLE_NAME, COLUMN_NAME  FROM DBA_LOBS WHERE OWNER = 'APPLSYS' AND  SEGMENT_NAME='SYS_LOB0001144624C00040$$'
  2  ;

TABLE_NAME
------------------------------
COLUMN_NAME
--------------------------------------------------------------------------------
WF_NOTIFICATION_OUT
"USER_DATA"."TEXT_LOB"


lAST QUERY are given error, please check below & rectify, above 2 queries output are there.

select sum(DBMS_LOB.getlength("USER_DATA"."TEXT_LOB")) FROM APPLSYS.WF_NOTIFICATION_OUT

ERROR at line 1:
ORA-00904: "USER_DATA"."TEXT_LOB": invalid identifier