Re: Performence on Oracle instance running on Sun Solaris/Sparc

> I think you should take a utlbstat/utlestat snapshot and post the results. I
> also think it is most likely NOT a memory issue because of lack of 'sr'. It
> doesn't matter really that SYSTEM tablespace is almost full. When that
> becomes an issue, you will get an error and not a performance problem.

Ok, I have setup some test to run during the night to see if we can find anything intresting out of utlbstat/utlestat.

> I notice that your redo logs are on the same disk as oracle binaries - in
> which case, if you are having connections coming in (client's attaching)
> during your work, then there will be sever contention on that disk which
> will result in waits...

I agree... But the setup is the same between Canada and Norway so it should explain the huge different (factor 10) between Canada and Norway. As I said before even in the Canada setup we can do some performance improvement but that not the number #1 on my todo list. All the clients has there own copy of the oracle binaries so the binary directory is not exported via NFS or SMB/Samba.

Kind Regards

//Tommy Received on Wed May 23 2001 - 17:34:26 CDT