Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: help -- extremely slow read blob
Check the cache/nocache and logging/nologging options on the LOB definitions. I have seen cases where performance on NOCACHE LOBs is bad.
Also, re-run the job with event 10046 level 8 switched and check the trace file to see where the waits are.
-- Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html ____Denmark__May 21-23rd ____Sweden___June ____Finland__September ____Norway___September Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html ____UK_(Manchester)_May x 2 ____Estonia___June 4th - 6th ____Australia_June 18th - 20th (Perth) ____Australia_June 23rd - 25th (t.b.a) ____USA_(CA, TX)_August The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html "Kenny Yu" <kyu_at_biodiscovery.com> wrote in message news:vbkvqi9barpjc2_at_corp.supernews.com...Received on Sun May 11 2003 - 12:30:38 CDT
> On two servers, which happen to be outside US, the java application
is
> extremely slow in loading images stored as BLOB. 15 minutes for a 10
mb
> tiff, as compared to 20 seconds normally seen on the server in the
States.
> Both slow instances are on RAID 5. Execution plans and autotrace
turn out as
> fine as on the fast servers. I captured the running sql to be
dbms_lob.read
> that's taking the time. Even running the client app on the server
box is
> slow; ruling out the network as the culprit. The schemas are the
same, as
> well as the client code. Anyone ran into similar problem before?
>
> Kenny
> kyu_at_biodiscovery.com
>
>