Re: locking Oracle SGA into RS/6000 memory

Hi Lance,

i 've made sveral benchmarks on several CPU's (Rs6000 5x, J40, SGI, HP) I found that a smaller SGA resultet in faster benchmarking for our data. Possible reason: Filesystem cache works more efficient that Oracle-file-buffers.

Try with a small SGA!

Kind regards,

Toni

In article <860426695.11641_at_dejanews.com>, Lance Tost <ltost_at_systemautomation.com> wrote:

> We're just getting underway with Oracle 7.3 server under AIX 3.2.5
> (probably soon to be 4.1) on an RS/6000. Can someone tell me (or point me
> to documentation which will tell me) how to lock the SGA into real memory?
> I've looked in the 7.3 Administrators Reference for AIX as well as the
> tuning tips manual-- can't find any mention of it.
>
> email ltost_at_systemautomation.com with any info.
> Thanks.
>
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
 

-- 
A. Dischner, SGI&AIX sysadmin, Oracle DBA       | Don't let friends
Institut fuer Klinische Chemie                  | use WinDose
Klinikum Grosshadern                            | Just say NO. 
Ludwig Maximilians Universitaet Muenchen,  GER  |            
Marchioninistr.15 81366 Muenchen 49-89-70953202 |