Oracle-L: Re: oracle temp files

From: <Jared.Still_at_radisys.com>
Date: Tue, 03 Dec 2002 11:04:02 -0800
Message-ID: <F001.00511117.20021203110402@fatcity.com>

v$sort_usage perhaps?

not sure what you're trying to determine.

'TEMPORARY' temp tablespaces provide space for sorting, and the kernel ( forget which process at the moment ) tends to hang on to them once allocated, and supply them to sessions as needed.

This avoids contention on the ST enqueue.

This causes TEMP to appear to be all used up after a while.

Jared

Jack van Zanen <JACK_at_QUANTSYSTEMS.NL>
Sent by: root_at_fatcity.com
12/03/2002 06:44 AM
Please respond to ORACLE-L

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        oracle temp files

If I create a temporary tablespace using temp files, how is it possible to check the space usage of that tablespace.

They do not show up in dba_free_space nor dba_data_files. DBA_TEMP_FILES gives me user_bytes and blocks. is this the opposite of the info in dba_free_space??

TIA
Jack

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Jack van Zanen
INET: JACK_at_QUANTSYSTEMS.NL

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: Jared.Still_at_radisys.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------