Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: 8.1.5 much slower than 7.3.4
Configuration tuning of an 8i database and the migration process from 7.3.4
is not an afterthought. Did you do a default install and migrate?
-----Original Message-----
From: Lord David [mailto:DLord_at_axis-resources.co.uk]
Sent: Friday, May 19, 2000 7:47 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: 8.1.5 much slower than 7.3.4
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 footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses.
www.mimesweeper.com
-- Author: Lord David INET: DLord_at_axis-resources.co.uk Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You mayReceived on Fri May 19 2000 - 08:07:40 CDT
![]() |
![]() |