Re: Weblogic, thin driver and lob segments

From: Gaja Krishna Vaidyanatha <oraperfman_at_yahoo.com>
Date: Sat, 11 Oct 2003 10:14:31 -0800
Message-ID: <F001.005D2D5C.20031011101431@fatcity.com>

Hi Gunnar,

Can you please turn on event# 10046 at level 8 and trace some of your sessions? You can then run 9i tkprof on the trace files, to determine the most expensive SQL statements, from a resource consumption and wait perspective.

I am sure there is enough expertise on this list to figure out where the problem may be, if you did post the tkprof output files.

Cheers,

Gaja  

• Gunnar Berglund <oracledbasweden_at_yahoo.co.uk> wrote:
  > Hi all,
  >
  > we are facing some serious problems with the
  > following case:
  >
  > we have an application which stores quite a lot of
  > documents to database (average document size is
  > 2mb). Application loads document template from
  > database and when we are having 100-200 hundred
  > users there will be a queue on a weblogic server in
  > order to wait to handle those documents and saving
  > the updates to database.
  >
  > Do you have any ideas how to do this faster or is
  > there something we haven't realized.
  >
  > TIA
  > gb
  >
  >
  > ---------------------------------
  > Want to chat instantly with your online friends? Get
  > the FREE Yahoo!Messenger
  

  ---

Gaja Krishna Vaidyanatha
Principal Technical Product Manager,
Application Performance Management, Veritas Corporation E-mail : gaja_at_veritas.com Phone: (650)-527-3180 Website: http://www.veritas.com

---

Do you Yahoo!?
The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gaja Krishna Vaidyanatha
  INET: oraperfman_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Sat Oct 11 2003 - 13:14:31 CDT