Re: Urgent Request

On Feb 25, 5:16 pm, Smitty <marksmith..._at_hotmail.com> wrote:
> Hello everyone.  I am really hoping that someone can help me with this
> issue.  I have two identical databases (one is a replication of the
> other), where when I run an identical query on each, one returns the
> results in .5 seconds, while the other takes 18 seconds to return the
> same result.  The indexes etc. are all identical on each database.
> When we ran a trace, we noticed that the disk gets hit only once on
> the 'quick' database, but get hit over 10000 times on the 'slow'
> database to return the same number of rows.  Does anyone have any idea
> what could be the issue.  I am attaching the query below.  Thank you
> very much.

How exactly are you replicating? Is it the original or replicant that is slow? How are you determining the indices are identical? What exact version/platform are you on?

Also see http://groups.google.com/group/comp.databases.oracle.server/browse_thread/thread/79d0a3d85381dc64/ed3ab1dbeeaa1cb2?hl=en&

(And a gentle reminder to use descriptive subject lines in the future.)

jg

--
@home.com is bogus.
http://www.signonsandiego.com/uniontrib/20080226/news_lz1n26read.html