Monitoring the Load or Unload Operations

You might want to monitor the load or unload operations for the following situations:

• If you expect to load and unload the same table often to build a data mart or data warehouse, monitor the progress of the job to estimate the time of similar jobs for future use.
• If you load or unload from named pipes, monitor the I/O queues to determine if you have a sufficient number of FIFO virtual processors.
• If you load unusually large simple large objects from named pipes, monitor the temporary dbspaces.