4 Replies Latest reply on Jan 8, 2013 3:43 PM by Lenny_

    BLOB inserts performance slow when segment space management is Auto

    Sreekeshava S
      We had DB performance issue while inserting data into blob columns. Blob column data would be normally 10-12 MB size and will be inserting this data into a table for every 4 seconds. Inserts became very slow.

      Similarly, for another table also, we are inserting data into blob and clob columns. Blob column data would be normally 10KB and clob column value would be normally 3-4 KB. For this table, insertion will be happening at a rate of 250 records/sec.

      Inserts were too slow during the above 2 scenarios.

      We investigated and found that below changes to resolve the issue that gave better performance.

      1) db_block_size = to be changed from 8K to 16K
      2) intial and next extent size to be changed to 100M
      3) segment_space_management to be changed from Auto to Manual

      But,our Customer DBA however is not agreeing for point 3. He says MANUAL segment space mgmt is not recommended as they will require downtime for defragmentation of manually managed segment space.

      Need help in this regard to make BLOB inserts faster.

      Thanks in advance/Sreekeshava S