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

Hi from Paris

in order to know what exactly happens on the Oracle instance, have a look at the STATSPACK package...

anyway, have a look at the online redo logs size, as many redo entries will be generated during huge loading...

Cdlt

"André Hartmann" <andrehartmann_at_hotmail.com> a écrit dans le message de news:411ce04a_at_olaf.komtel.net...
> 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 - 14:57:53 CDT