Advantage of blobspaces over dbspaces

If you store simple large objects in a blobspace on a separate disk from the table with which it is associated, instead of storing the objects in a dbspace, you can obtain some performance advantages.

The performance advantages of storing simple large objects in a blobspace are:
  • You have parallel access to the table and simple large objects.
  • Unlike simple large objects stored in a dbspace, blobspace data is written directly to disk. Simple large objects do not pass through resident shared memory, which leaves memory pages free for other uses.
  • Simple large objects are not logged, which reduces logging I/O activity for logged databases.

For more information, see Storing simple large objects in the tblspace or a separate blobspace.


Copyright© 2018 HCL Technologies Limited