File System Requests (Oracle) 

To display the File System Requests:

  1. From the R/3 main screen, choose: Tools ® Administration ® Computing Center ® Management System ® Control ® Performance Menu ® Database ® Activity

    2. Alternatively, use transaction code ST04.

  2. Choose Detail analysis menu ® Filesystem requests.

This screen displays statistics on physical accesses to database files. The display includes duration for block reads and writes measured in milliseconds. To display these time values, the init<SID>.ora parameter timed_statistics ( TIMED_STATISTICS (Oracle)) must be set to true .

You can minimize the time needed for reading from or writing to a data file:

  1. Identify the frequently used data files
  2. Ensure that frequently used files are on separate disks so that I/O requests for objects do not directly compete with each other.

Data file activity has an important effect on performance if your database is very large and is used intensively.