Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help with poor View Performance??
Try doing an explain plan on the view and see what plan you get. You might
find that there are indexes missing on instance B
Dan Roberts wrote in message <3643AE96.8370E5D0_at_bms.com>...
>Hello All
>
>I have this weird problem..What I have are two oracle 7.3.3.0.0
>instances..I needed to update a db in instanceA but before I could I
>needed to grab a view from instanceA and put it into instanceB so that
>during the update process I would trash a user's work
>
>This is what I did..
>exported the 5 tables I needed from instanceA and imported them into
>instanceB..
>then recreated the view on instanceB.
>
>The view is huge...over a million rows or so..the problem is that when
>someone selects from the view on instanceB it take forever for an answer
>to come back,,,on the order of hours..
>
>What can be so different btw the two instances?? The tablespaces are
>both about the same size btw the two instances??
>
>What else can I check that would help me understand why the performance
>of the view in instanceB is so poor compared to the same view in
>instanceA??>>Thanks!!!>Dan
>
Received on Sat Nov 07 1998 - 04:04:09 CST