This discussion is archived
7 Replies Latest reply: Oct 28, 2013 9:53 AM by jgarry RSS

User Tablespace.

947853 Newbie
Currently Being Moderated

Hi,

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points