Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: 8.1.5 much slower than 7.3.4

RE: 8.1.5 much slower than 7.3.4

From: Lord David <DLord_at_axis-resources.co.uk>
Date: Fri, 19 May 2000 14:57:21 +0100
Message-Id: <10502.106099@fatcity.com>


Sorry, I didn't explain very well. This is a migration to a fresh instance on a different machine using export/import etc. My aim in posting this is not to find out what's wrong - I know the box hasn't got enough memory (256Mb BTW, whoever spec'ed it needs shooting;-). What I'm trying to find out is what peoples views are regarding the relative memory usage of 7.3 and 8/8i.

Regards
David Lord
Senior DBA, Axis Resources, Cardiff.



Tel: +44 (0)29 20 544013
Fax: +44 (0)29 20 692464
Email: dlord_at_axis-resources.co.uk

> -----Original Message-----
> From: Norwood Bradly A
> [mailto:Bradley.A.Norwood_at_M1.IRSCOUNSEL.TREAS.GOV]
> Sent: 19 May 2000 15:28
> To: Multiple recipients of list ORACLE-L
> Subject: 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-----
> 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).
>



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 Received on Fri May 19 2000 - 08:57:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US