Re: 9.2.0.5 No temp file shrinkin after db restart

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