Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003

    Unanswered: Temp Tablespaces

    hi all,

    when Temporary Tablespace is 98 % full.What should be the immediate action to be Taken?

    1)Needs to coalesce;

    2) Added datafile

    Pls replay ASAP


  2. #2
    Join Date
    Jun 2004
    Provided Answers: 1
    This is not necessarily a bad thing or a reason to panic - even though Oracle may have finished with temp space it doesn't automatically 'free' it - it stays marked as used. Oracle will just keep going to the end of the free space available, and then take what it needs from the "finished with but still marked" space; so although it says '98% full' it doesn't actually mean that - Oracle has used 98% of the free space, but when it needs more it will take as much as it needs from what was used previously but is now available for re-use.

    The tablespace will continue to say 98%, unless you decide to increase the temp tablespace & file sizes or drop & recreate the temp file.
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts