0 Replies Latest reply: Aug 14, 2013 12:28 PM by User404955 RSS

    XMLTYPE datatype segment extent full

    User404955

      Hi Friends,

      One of my application is using XMLTYPE as datatype and storing CLOB as sorage with  maxxtent as 1024 .Now the extent is going to be full and I need to resize .I am trying to figure it out the column name for LOBSEGMENTS which is extent 95% fulll .I have tried from DBA_LOBS  and it is showing column name as SYS_ somrthing not the original column name . How do I find out the COLUMN Name for the LOBSEGMENTS whih is extent full ?

      I have searched a lot and not able identify this .

       

      Storage  clause for columns :

       

      XMLTYPE COLUMN "AGENT_INFO_XML" STORE AS CLOB (

        TABLESPACE "<tablespacename>" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10

        NOCACHE LOGGING

        STORAGE(INITIAL 262144 NEXT 262144 MINEXTENTS 1 MAXEXTENTS 1024

        PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

        BUFFER_POOL DEFAULT))

       

      The segment which extent is going to be full : COLUMN NAME is NOT SHOWING .It is 11.2.3 database .

      SQL> select TABLE_NAME,COLUMN_NAME,SEGMENT_NAME,TABLESPACE_NAME,CHUNK from dba_lobs where SEGMENT_NAME='SYS_LOB0000034131C00071$$';

       

       

      TABLE_NAME

      ------------------------------

      COLUMN_NAME

      --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

      SEGMENT_NAME                   TABLESPACE_NAME                     CHUNK

      ------------------------------ ------------------------------ ----------

      ARCHIVE_AR_TMP

      SYS_NC00071$

      SYS_LOB0000034131C00071$$      AMCSTAB1_256K                        8192