Re: something about oracle performance

I suppose you don't have the documentation for the database. If it is Oracle 8 then have a look at this: http://www.sleepnet.net/reference/oracle8/index.htm You'll find it all there, perhaps not all that detailed. I'm using this documentation locally every day.

1. Oracle at it's peak is a big thing. You can use scripts to query Oracle's dictionary tables to get information about eg. buffer cache hit ratio, explain plans of sql statements, analyzing tables, trace files etc. Planning the physical structure of the database, "Oracle striping", partition tables, cluster tables.
2. The only way I know of changing this is in the init.ora file (see parameter files). There are different caches
3. The logwriter (LGWR) writes online redologs. run "select * from v$bgprocess" and you'll see what different processes there are.

Check the documentation and you'll find what your looking for!

HTH /Jerra

Sam TANG wrote in message ...
>Hi, there
>
>I am very interested in Oracle database. Now I bought a book named "Oracle
>Database Administration"
>but I can't find some answer from it.
>
>So I hope who can help me to answer some question:
>
>1.How can I know the Oracle is working at peak?
>2.How to increase the cache by SQL statement?
>3. Could you tell me some thing about log writter?
>
>
>thanks in advance.
>
>your sincerely
>
>Higgins
>
>Mar 20, 2000
>
>
Received on Tue Mar 21 2000 - 00:00:00 CST