RE: 8.1.5 much slower than 7.3.4

From: Lord David <DLord_at_axis-resources.co.uk>
Date: Fri, 19 May 2000 12:27:11 +0100
Message-Id: <10502.106073@fatcity.com>

Hi list

We are having a similar problem with a database migrated from 734 to 815 on Solaris 2.6. The machine is showing every sign of memory starvation (high page-out rate, high IO on the swap device, degraded performance, etc). I've done a bit of investigation with the proc tools (/usr/proc/bin/ptree & pmap) and, as far as I can tell, the user processes are using massively more memory in 815. For instance, the total size of the process address space for sqlplus in 734 is ~4Mb. In 815 it's ~8.9Mb. A dedicated server process (excluding the shared SGA) uses 10Mb in 734 and 44Mb in 815 (BTW its only 33Mb on 816).

Unfortunately, I'm not very experienced at performance tuning so I could be getting the wrong end of the stick. Does anybody else have any better informed views on this?

Regards
David Lord
Senior DBA, Axis Resources, Cardiff.

> -----Original Message-----
> From: cyril [mailto:cyril_at_stockholding.com]
> Sent: 19 May 2000 09:49
> To: Multiple recipients of list ORACLE-L
> Subject: RE: 8.1.5 much slower than 7.3.4
>
>
>
>
> Hello!
>
> Sorry, the performance degradation we are talking of is
> a 'general and overall performance degradation' whose
> source is not the
> 'application code'
>
> The reason I say this is.. we even found some utilities (I repeat
> utilities not application code)
> were found to perform worse than Oracle 7.3.4.
>
> The utility I am mentioning is export utility and not import.
>
> Surely select count(*) from table_name is a good test to
> start with isn't
> it...
> before we as DBAs point a finger at the 'poor' developers!!!!
>
> Of course we caught hold of a 'caring' Oracle Support person
> who was kind enough to let us know that there was a bug with
> the export
> utility...
>
> I would love for feedback on this question as we at our site
> are baffled
> and filled with self doubt
> (believe me I am not exaggerating).. particularly since we
> had invested
> money in
> 64-bit hardware under the notion that 64-bit hardware will provide a
> larger I/O bandwidth
> and hence decrease ( I repeat again decrease not increase) the export
> time.
>
> But could some 'experienced' soul cast more light on this issue..
>
> Regards
>
>
> --
> Author: cyril
> INET: cyril_at_stockholding.com

---

This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager.

This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com Received on Fri May 19 2000 - 06:27:11 CDT