Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Orace Performance Question
Hi
I am fairly new to oracle. About three months a go we test our app on a oracle 8i running on Sparc Solaris 8. Every thing was fine.. it the standard suit of report we run were very fast.
So we moved the data onto a live system and stated using it. But now we cannot get the same performance. I know I am asking how is a pice of string question, but would like some recommendation.. This is some of the difference between the test and live system
1 The main table on the test system had 26 extents but on the live system it is on 222... Would that have a baring on the performance. It has it own table space
2 The secondary tables also have more extents the test system, and the
tablespace they live in has lot more large tables in it then the test
system. Would that cause the HI IO we are seeing when the secondary
tables are accessed.
The other tables are archive data, they are very rarely accessed.
If any one can comment on if this has a baring on the performance ?
Thanks Received on Fri Jan 16 2004 - 03:16:50 CST