Re: Query with LONG RAW
From: Sybrand Bakker <sybrandb_at_gmail.com>
Date: Tue, 02 Mar 2010 23:16:19 +0100
Message-ID: <td3ro5975gv9ejt4c4fn5vict92016r7eh_at_4ax.com>
On Tue, 2 Mar 2010 21:46:51 +0100, "bob123" <bob123_at_gmail.com> wrote:
Date: Tue, 02 Mar 2010 23:16:19 +0100
Message-ID: <td3ro5975gv9ejt4c4fn5vict92016r7eh_at_4ax.com>
On Tue, 2 Mar 2010 21:46:51 +0100, "bob123" <bob123_at_gmail.com> wrote:
>How can I speed up the query below (third party software)
>it takes 30 min to execute.
>Oracle 9.2.0.6
>LONG RAW on PFMQ_MESSAGEDATASTORAGE
Apparently the table has heavy row chaining, which means 1 row is in
more than 1 block. This is always resulting in severe performance
hits.
There is nothing wrong with the query, the design of that table is
wrong, as is still running a desupported release of Oracle.
-- Sybrand Bakker Senior Oracle DBAReceived on Tue Mar 02 2010 - 16:16:19 CST