Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: 9.2.0.5 No temp file shrinkin after db restart
Thanks!
"Frank van Bortel" <fvanbortel_at_netscape.net> kirjoitti
viestissä:d47pd2$2kt$1_at_news4.zwoll1.ov.home.nl...
> ErkkaH wrote:
>> Hi!
>>
>> Small question: I have 3 TEMP files, of type TEMPFILE/TEMPORARY. The are
>> 99.X % full, the DB shows that no TEMPORARY SEGMENTS are used:
>>
>> SELECT COUNT(*) FROM DBA_EXTENTS WHERE SEGMENT_TYPE='TEMPORARY';
>>
>>
>>
>> result = 0
>>
>>
>>
>> However the space mgm and windows shows that they have more than 1GB used
>> each.
>>
>>
>>
>> Now to my understanding the filesize should shrink when I bounce the DB,
>> but
>> it doesn't. It has stayed like this since DB was taken onto operative use
>> about 6 months ago. After that there have been at least 10
>> shutdown/restarts.
>>
>>
>>
>> Is this normal?
>>
>>
>>
>> TIA!
>>
>>
> Yes - and explained in the Concept Manual.
>
> Temporary segments are just marked as being reusable, hence
> the 100% "used"
>
> --
> Regards,
> Frank van Bortel
Received on Thu Apr 21 2005 - 04:01:48 CDT