Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: help -- extremely slow read blob

Re: help -- extremely slow read blob

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sun, 11 May 2003 18:30:38 +0100
Message-ID: <b9m1tr$ijp$1$830fa7b3@news.demon.co.uk>

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...

> 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
>
>
Received on Sun May 11 2003 - 12:30:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US