Re: Orace Performance Question

You need to be more explicit.

Things to look at:

How many disks do you have?
How are the datafiles distributed?
I presume tablespaces are Dictionary managed not Locally managed? What SQL is being executed?
Plus lots more!

You should run Statspack to get a snapshot of the system activity, that will point you in the right direction. However, if you need some assistance I'd be happy to look at your system for you.

<spam_at_spam.com> wrote in message news:4007a9b7.72692406_at_news.demon.co.uk...
> 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 - 06:25:48 CST