Re: Oracle Tuning Question

Daniel Morgan <damorgan_at_exxesolutions.com> wrote in message news:<3F4661A7.626E945D_at_exxesolutions.com>...
> "rc"@die_at_you@!spammers.sandworm.demon.co.uk wrote:
>
> > Hi
> > I new to Oracle, I am familiar with MS SQL, MySQL and Access.
> > I have a question for those of u in the know.
> >
> > We are implemeting a DB with apporx 5m records in it.
> >
> > Can some one tell me how I would go about monitoring that the
> > DB_BLOCK_BUFFER; memory for sort area and shared memory pool (memory
> > for SGA I think) and log buffer size is sufficient, or point me some
> > urls
> >
> > I have no controler over the deisgn of the SQL queries as it is an off
> > the shelf app designed for Oracle
> >
> > I basically want to tune the server for fast querie response, I am not
> > too bothered about the Data input yet
> >
> > Thanks
>
> You have struck all of the others that responded as someone looking for a
> problem to fix: And into that ring I throw my hat too.

Just to be contrarian, I'll point out there is a Planning for Performance manual. And I'll also point out that everyone is answering for reactive tuning, when a new installation needs some kind of ballpark tuning. So size db_block_buffers so that it makes an SGA 1/4 to 1/2 your real memory size to start, and use 8K block size when you create the db. Then search metalink for tuning scripts. Yes, they have some detail and conceptual errors in places, but at least you're in the ballpark. Sort and pool measurement can only be done empirically, as everyone says, although there are formulae floating about, which would only be useful if you knew more about your potential app. If it is a bunch of stored procedures, things are a lot different than if it is a bunch of OCI calls to rowids or brain-dead ODBC.

jg

--
@home.com is bogus.
select * from x$kckce;