Re: Performance problems with remote queries

From: Dave Steele <DKBSteele_at_aol.com>
Date: 26 May 2004 06:56:30 -0700
Message-ID: <17f9e4c6.0405260556.3e9fdfba_at_posting.google.com>

We had something similar happening when testing our Applications that run on 7.3.4 on a 8.1.7.4 Oracle database. Some queries that connected to a remote database went from 5 seconds to about 15 minutes. The explain plan showed many hash joins in the queries. We had to set the init.ora parameter hash_join_enabled = false, and the queries ran again in about 5 seconds.

Hope this helps,
David Received on Wed May 26 2004 - 15:56:30 CEST

This message: [ Message body ]
Next message: Bevertec: "Oracle Workflow - 6 mths - Jamaica/Canada - Bank"
Previous message: elziko: "Re: Update rows when in other table"
In reply to: Terje J?sang: "Performance problems with remote queries"
Next in thread: M.Kovacic: "Re: Can NOT create Materialized View"

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

Original text of this message