RE: 8.1.5 much slower than 7.3.4

Hi Louis:

I'll try to get back to you later if Winnie doesn't clarify it first......i'm in the middle of database rebuilds.

-----Original Message-----
From: Louis BROUILLETTE [mailto:Louis_Brouillette_at_UQTR.UQuebec.CA] Sent: Friday, May 19, 2000 11:26 AM
To: Multiple recipients of list ORACLE-L Subject: RE: 8.1.5 much slower than 7.3.4

Yes I did.

How should I have done it ?

At 06:28 05-19-00 -0800, you wrote:
>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-----
>Sent: Friday, May 19, 2000 7:47 AM
>To: Multiple recipients of list ORACLE-L
>
>
>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
>**********************************************************************
>--
>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 may
>also send the HELP command for other information (like subscribing).
>--
>Author: Norwood Bradly A
> INET: Bradley.A.Norwood_at_M1.IRSCOUNSEL.TREAS.GOV
>
>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 may
>also send the HELP command for other information (like subscribing).
>
>

Louis Brouillette
Analyste en informatique (DBA)
Universite du Quebec a Trois-Rivieres
Tel: (819) 376-5011 ext. 2435
Email: Louis_Brouillette_at_uqtr.uquebec.ca

-- 
Author: Louis BROUILLETTE
  INET: Louis_Brouillette_at_UQTR.UQuebec.CA

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