The Datafiles Layer
Since the datafiles contain the user data and the data dictionary and represent a major component of the database, monitoring the activity on the different datafiles is critical for optimizing database performance. For monitoring datafile activity, the eG Enterprise uses an OracleDataFiles test (see Figure 1). This test is intended to identify the level of activity that is happening on each datafile of a database. The results of the test can be used to reorganize the data storage, so as to balance the activity across the different datafiles and among the different physical disks in use.
