temporary tablespace usage

From: Marcin Buchwald <Marcin.Buchwald_at_agora.pl>
Date: Fri, 29 Nov 2002 12:03:34 +0100
Message-ID: <3DE74986.B4C9EA1@agora.pl>

Could You explain why 3rd select results with no rows?

11:58:19 SPA.SPAC.GWSPACER> select * from v$temp_extent_pool;

TABLESPACE_NAME                   FILE_ID EXTENTS_CACHED EXTENTS_USED

BLOCKS_CACHED BLOCKS_USED BYTES_CACHED BYTES_USED RELATIVE_FNO

------------------------------ ---------- -------------- ------------
------------- ----------- ------------ ---------- ------------
TEMP                                    1             20
0          5120           0     20971520          0            1

Całkowity: 00:00:00.10
11:58:42 SPA.SPAC.GWSPACER> select * from dba_temp_files;

FILE_NAME

---

D:\SPAC\TEMP01.DBF Całkowity: 00:00:00.51
11:58:49 SPA.SPAC.GWSPACER> select * from dba_temp_files, v$temp_extent_pool;

no rows selected

Całkowity: 00:00:00.00
11:58:56 SPA.SPAC.GWSPACER> select * from v$version;

BANNER

---

Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production PL/SQL Release 8.1.7.0.0 - Production
CORE 8.1.7.0.0 Production
TNS for 32-bit Windows: Version 8.1.7.0.0 - Production NLSRTL Version 3.4.1.0.0 - Production

The backdoor statement is

select * from
(select bytes from dba_temp_files) f,
(select bytes_cached,bytes_used from v$temp_extent_pool) p

What's happening?

Regards,

        Marcin Received on Fri Nov 29 2002 - 05:03:34 CST