| temporary tablespace [message #59405] |
Mon, 17 November 2003 12:20  |
Damon
Messages: 7
Registered: April 2001
|
Junior Member |
|
|
When I run following SQL, I couldn't find temporary tablespace TEMP.
select distinct tablespace_name from dba_free_space;
But I can find my temp filename by
select name from v$tempfile;
What went wrong in my Oracle server?
|
|
|
|
| Re: temporary tablespace [message #59406 is a reply to message #59405] |
Mon, 17 November 2003 12:46  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
There's nothing wrong. Dba_free_space doesnt show information for true temporary tablespaces.
Instead,
SQL> select * from v$temp_space_header;
TABLESPACE_NAME FILE_ID BYTES_USED BLOCKS_USED BYTES_FREE
------------------------------ ---------- ---------- ----------- ----------
BLOCKS_FREE RELATIVE_FNO
----------- ------------
TEMP 1 4194304 512 37748736
4608 1
1 row selected.
Also query v$sort_segment,v$sort_usage for additional details.
-Thiru
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
