7 Replies Latest reply on Oct 28, 2013 4:53 PM by jgarry

    User Tablespace.



      im a newbie.


      We have a user tablespace say 'abc' for eg.

      One of my task is to monitor the tablespace available in the database.

      Tablespace abc size is 10 gb and free space left is 1gb.

      For the past one month the free space remains same but suddenly freespace size got decreased to 400mb and after a day again it back to 1gb.

      My manager asked me to find the reason for this sudden decrease in size for the abc tablespace...

      I thought user might have added some data to the tablespace and dropped it later.

      so if this is the reason can i able to find which table got updated.


      Kindly help.



      Thanks in Advance