Tuning direct path read (lob)

From: <matthias.hoys_at_gmail.com>
Date: Thu, 19 Mar 2009 08:19:55 -0700 (PDT)
Message-ID: <13d5ed22-cb86-4c13-a71c-11dc14bc8ade_at_t3g2000yqa.googlegroups.com>

Hi,

I'm currently investigating a possible performance problem with a Oracle 8.1.7 database on Windows XP (I know 8i is out of support, but this is an "embedded" database that comes with the application).

A statspack report showed me that the biggest amount of waits were related to "direct path read (lob)" events. Any idea on how I could tune this event ? I couldn't find much in the Oracle docs.

Matthias Received on Thu Mar 19 2009 - 10:19:55 CDT

This message: [ Message body ]
Next message: hehehe: "program for analyze archive logs"
Previous message: Robert Klemme: "Re: Is there a tool to allow users to build algorithms that are then run by database"
Next in thread: Jonathan Lewis: "Re: Tuning direct path read (lob)"
Reply: Jonathan Lewis: "Re: Tuning direct path read (lob)"
Maybe reply: matthias.hoys_at_gmail.com: "Re: Tuning direct path read (lob)"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message