Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Query Speed
3 times is quite a figure, but do remember that when
a database is exported and imported back into a 'fresh'
system, the extents are all compressed in a neat and
ordely fashion, chaining is reduced, etc. I've seen
very dramatic improvements after an export/import cycle.
Run sessions looking at the explain plans, and with utlbstat/ utlestat to see if the access paths or data hits are actually different. Then you'll know if you are actually looking at different datasets.
Joe Condle <condle_at_med.pitt.edu> wrote:
: I am running Oracle 8 for the Solaris OS. I have supposedly two
: identical machines with the same databases on them. The database
: was generated on one and exported to the other. The problem I have
: is when I run simple sql queries on one the same query runs three
: times as fast on the other. It is almost exactly three times
: difference. 22 secs on the origninal machine vers 1 min on the
: other. My question is where do I start to look for differences.
: I am a newbie and have started looking throught all the docs. Please
: point me in the right direction.
: Thanks in Advance
: Joe Condle
: Sys Engr
: Medical ARchival Systems Inc.
: Univ. of Pittsburgh Medical Center
Received on Sat May 02 1998 - 02:06:44 CDT
![]() |
![]() |