Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Performence on Oracle instance running on Sun Solaris/Sparc
"Tommy Svensson" <tkman23_at_hotmail.com> wrote in message
news:ebf7c6db.0105221323.3860f883_at_posting.google.com...
> Hi!
[Snip]
The performence in the Canada instance is good, but the performence in
Norway is terriable
[Snip]
We are pretty slow over here in Norway...
If memory serves me right there were some speed problems when accessing views on 7.3, especially with outer joins. Setting a "PUSH_JOIN_PREDICATE" option made quite a difference for us. It could be set in the init.ora or with a:
ALTER SESSION SET PUSH_JOIN_PREDICATE = TRUE Probably just a shot in the dark though...
D A Received on Mon May 28 2001 - 08:01:41 CDT