Improving the performance of Veritas Velocity for Oracle Database

You can improve the performance of the Velocity ingest and sandbox processes for Oracle Database by using these best practices:

• Maximize the size of the data chunks to 1 MB in Oracle RMAN.

  Use the following SQL*Plus commands to edit the buffer size for backup sets and image copies:

  Perform these edits before you run the ingest_dba application. See Ingesting an Oracle database into Velocity from the command line

  ALTER SYSTEM SET "_backup_file_bufcnt"=256

  ALTER SYSTEM SET "_backup_file_bufsz"=1048576

  ALTER SYSTEM SET "_backup_disk_bufcnt"=256

  ALTER SYSTEM SET "_backup_disk_bufsz"=1048576

• Enable block change tracking.

  Type the following SQL*Plus commands to enable block change tracking:

  ALTER DATABASE

  ENABLE BLOCK CHANGE TRACKING

  USING FILE

  '[bctFilename | +ASMDiskgroup]'