Hi ,
The size of my temp datafile is 10352640kbytes .It is autoextensible.I am wondering how this has become this much.My understanding about the temp datafile is that it is temporary.After the usage the size should go down.What can i do to avoid such a large temp datafile.The pctincrease is 0 for this tablespace.