ORACLE 8.0.6

[Ivan Azuara]

I changed the db_max_pct and reduce the use of memory to 60%, I think that's good !

In relation to the changes about init.ora, my dba is checking your recommendations and is changing some values. For now we are going to tuning the performance with this changes ?

Thank's !

P.D. What oracle 8.0.6 manual recommends, for find more information about the tuning on oracle databases ?


Best Regards !

[Eric Ladner]

FYI, dbc_max_pct should be very small to allow for more memory in the SGA. Values above 5 percent should be considered too large.

[Krishna Prasad]

Now that you have more memory let Oracle use it and change the SGA.

[Ian Dennison_1]

Recommended reading,...

http://otn.oracle.com/doc/server.804/a58246/toc.htm

Oracle 8 Tuning and Performance Guide

Share and Enjoy! Ian

[melvyn burnard]

You sjwould hav ebeen better posting this back into your original post wher emany others tried to help you. It is much easier to follow the thread then.