| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: How to speed up Oracle 9.2.0 on SuSE Enterprise Server 7
True, Daniel... but I feel a piece of new terminology coming on, because as
far as I'm concerned, the spfile is just a binary version of the init.ora,
and the init.ora probably isn't called "init.ora" anyway.
In other words, I use the term "init.ora" as a catch-all phrase for "anything that is used to start your Instance". Regardless of what it's actually called on the day. In the past, I've distinguished between "pfiles and spfiles". And (as I say) used "init.ora" to mean both.
I've confused a student or three doing that already, it's true. But I can't keep saying "init.ora or spfile" or "pfile or spfile", because I use the phrase about 300 times on day 1 of the DBA Fundamentals course!!
So: a competetion (prize: immortality) to provide a generic name for anything that starts the instance. Regardless of its nature (binary/text) or its actual name.
Whaddyareckon?
HJR
"Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message
news:3D9B138E.53FA2B3F_at_exesolutions.com...
> "Howard J. Rogers" wrote:
>
> > If this is blindingly obvious, forgive me: but get hold of the init.ora
> > files from Sofia, and make sure that your init.ora files are identical.
Only
> > then do you start wondering about platform specifics.
> >
> > Regards
> > HJR
> >
> > "Latchezar Kostov" <lgk_at_ifd.orbitel.bg> wrote in message
> > news:c4053a39.0210020350.3154887f_at_posting.google.com...
> > > I had install an Oracle 9.2.0 database over SuSE Enterprise Server 7
> > > and I have a big trouble.
> > > The situation is that...
> > > In our project we import two kind of files - bon and pcout. We have a
> > > developement system in Sofia running on 2xCPU system with Mandrake 8.1
> > > and Oracle 9.0.1. Here the two type of files goes fast - ~ 1 hour for
> > > the pcout files and ~45 min for the bon files (140 files bon and 140
> > > pcout).
> > > When I install the new system - Oracle 9.2.0 on SuSE Enterprise Server
> > > 7 (which is certificate by Oracle) on 2xCPU machine... the pcout files
> > > passed for about 4 hours.. but every file go aproximately for constant
> > > time... but the bigger problem is with bon file. The needed time for
> > > them grown with every one file and for the third file is about 5 hours
> > > for a 5 MB file....
> > > I was trying to change the parameters of the database, to optimise the
> > > SQL but no effect... we just one time have success to run them fast
> > > from our debbuging tool but no more!
> > > I made the database with Oracle tools saying to not make example
> > > schemas and I change some of the parameters which are shown down:
> > >
> >
############################################################################> > >
> > ##
> > > # Copyright (c) 1991, 2001, 2002 by Oracle Corporation
############################################################################> > >
> > ##
> > >
> > > ###########################################
> > > # Cache and I/O
> > > ###########################################
> > > db_block_size=8192
> > > db_cache_size=25165824
> > > db_file_multiblock_read_count=16
> > >
> > > ###########################################
> > > # Cursors and Library Cache
> > > ###########################################
> > > open_cursors=700
> > >
> > > ###########################################
> > > # Database Identification
> > > ###########################################
> > > db_domain=""
> > > db_name=klpb
> > >
> > > ###########################################
> > > # Diagnostics and Statistics
> > > ###########################################
> > > background_dump_dest=/apps/oracle/admin/klpb/bdump
> > > core_dump_dest=/apps/oracle/admin/klpb/cdump
> > > timed_statistics=TRUE
> > > user_dump_dest=/apps/oracle/admin/klpb/udump
> > >
> > > ###########################################
> > > # File Configuration
> > > ###########################################
 |
 |