Free 30 Day Trial
Find the root-cause of your cloud, hybrid-cloud
or on-prem performance issues
|
||
|
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.