Temporary Data Files [message #51033] |
Mon, 22 April 2002 06:50 |
Nita
Messages: 34 Registered: March 2002
|
Member |
|
|
I am running Oracle 8i on a Win2000 Server platform.
I have 3 temporary data files in my database. How do I determine which are being used and where?
My data files are:
TEMP01
FC_TEMP01
TEMPORARY_DATA01
Thank you
|
|
|
|
Re: Temporary Data Files [message #51037 is a reply to message #51033] |
Mon, 22 April 2002 10:26 |
Grant
Messages: 578 Registered: January 2002
|
Senior Member |
|
|
You can use this command to see what temporary tablespace the user is using.
select username,default_tablespace,temporary_tablespace from dba_users;
Make sure there are no users in a non-temporary tablespace and for sure not system. You can also use DBA_EXTENTS:
select owner,segment_type from dba_extents where tablespace_name='TEMP';
This will show extents allocated to a user. This may not be a true representation though because the extents may be owned by a user that isn't connected anymore. Temporary tablespaces get cleared when you restart the DB. Someone else may have a better idea on what is actually being used real time.
|
|
|