LOB-insert performance: is 25secs for 10Mb okay ?

Hi everyone,

  I want to share a performance experience and I would like to know if this performance is quite okay or if it is worth digging into tuning or other aspects because there is boombastic room for improvements.

  This is about loading LOB data into an Oracle instance.

  What I have is this:

  Oracle Server: 9i, Win2000, 1GHz, 1MByte, one test instance running. Not swapping. Data file that the LOB is going to is on an IDE hard disk. Nothing else doing.
  Oracle Client: 9i, Win2000, 1GHz, 1Mbyte, nothing else doing. LOB data not read from file (so hard disk is no issue here) but generated randomly in main memory while running (chunks of 32kb).

  Both are connected via a TCP/IP ethernet 100MBit/s.

  I have a table "LOBTest" which has a string key column and a BLOB column. I insert a row with an empty_lob and then get a lob locator and stuff 10.000.000 bytes (so roughly 10MB) into the lob locator.

  What I get is it takes around 25 seconds with my appl built in RELEASE mode (VC++) and 35 seconds when build in DEBUG mode. During that time period no significant load is incurred on any of the computers (i observe with task manager) nor is the network a bottleneck (my network admin monitors with a tool that shows no collisions).

  At first glance I find that 25+ secs a lot for just 10MB. Of course I know there is some overhead on both the client and especially the server.

  But maybe other people can come up with some figures from their environment or maybe you ask me to provide more details even though I have put here everything that seems top important for this issue. If some guys come up and say that is a terribly bad performance I would also appreciate any hints as to what I could do to improve. Received on Fri Aug 13 2004 - 10:37:42 CDT