NAVEEN

Thursday, January 14, 2010

Obtaining Tablespace Information

Obtaining Tablespace Information
• Tablespace information:

– DBA_TABLESPACES
– V$TABLESPACE
• Data file information:

– DBA_DATA_FILES
– V$DATAFILE
• Temp file information:

– DBA_TEMP_FILES
– V$TEMPFILE


Dynamic performance views
V$DATAFILE
V$TEMPFILE
V$TABLESPACE

Data dictionary views

DBA_DATA_FILES
DBA_TABLESPACES
DBA_TEMP_FILES

1 comment: