If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Hybrid View

Hi All,
I know it has been said and recommended to use Locally Managed Tablespaces because of their space management and efficiency. However I find hard to believe the way Locally Managed Temporary Tablespace is behaving. NOT DEALLOCATING The free space after session is finished even not at shutdown.
I was on vacation and when I came back I realized that our LMTT has grown from 2G to 18G. The Jr. DBA just keep adding datafiles. and with LMTT there is no option to reclaim the free space.
Has any one experienced the same thing? I am thinking of using DMTT for both TEMPORARY AND RBS tablespace.

Please share your comment

[Edited by Ablakios on 10-18-2002 at 09:43 AM]

Arsene Lupain
The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

Hi Sazzadur
Thanks for the response.The statement shows that extent are being deallocated. However I have about 16gb of wasted space that I can allocate somewhere else that I cannot reclaim. RECLAIMING THE SPACE is my concern.
Thanks

Arsene Lupain
The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

Well it's your DBA's criteria. Why he adds files? Does he get errors? Or he simply query some v$ views and see there are no freespace? With temporary LMT (and temporary DMT) even it says there is no freespace it does have them.