|
Explanation: To obtain detailed information about the data files associated with the temporary table space, you must query the V$TEMPFILE or DBA_TEMP_FILES views in Oracle 9i. Some of the important columns in the V$TEMPFILE dynamic performance view are NAME, FILE#, TS#, STATUS, ENABLED, and BYTES. Reference: Oracle 9i Net Services Administrator’s Guide Oracle 9i Net Services Reference Guide Oracle 9i Recovery Manager Reference Oracle 9i Backup and Recovery Concepts
|