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
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.
> -----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 footnote also confirms that this email message has been swept by Received on Fri May 19 2000 - 08:57:21 CDT
![]() |
![]() |