Databases Reference
In-Depth Information
17. Take the tablespace online:
ALTER TABLESPACE EXAMPLE ONLINE;
18. Remember to keep on separate disks data that is not related to the database.
The last step may seem obvious, but, in many installations, the same disks are shared
with other applications, such as web or application servers. The disks used by the database
should not be shared among other applications to ensure optimal performance.
How it works...
In step 2, we query the I/O statistics on data files, obtaining the result shown in the
following screenshot:
For each file, we can see the number of physical reads and writes performed and the
time spent (in milliseconds) for these operations. By observing this, we can identify
heavily-accessed data files.
In step 3, we execute a query similar to the one previously mentioned (regarding
temporary files), obtaining the results shown in the following screenshot:
