Logo

SQL Script

Database File Statistics

 Tested on Oracle 8.1 Tested on Oracle 8.0 Tested on Oracle 7

Updated : 08-Jan-2002
Version : 1.0

Description

Script displays file statistics within the database.

Parameters

None.

SQL Source

set pages 200
col name form a56

select d.name,s.PHYRDS,s.PHYWRTS
from v$datafile d, v$filestat s
where d.file#=s.file#
order by 1
/

Return to Index of SQL Scripts

Home | Company Profile | Services | Contact Us | SQL scripts and tips | Quiz
Legal

Logo