Re: Memory-resident table -- VMS

While Oracle will not allow you to "lock" a small table in memory, to increase the chance of that table being there, crank up you're SGA some since you're apparently not hurting for memory, then fire up a detached process that does a select * from table_name every so often. Use the logical/physical I/O requests from sqldba (mentioned previously) to tune the interval that the detached process executes the select. If your'e seeing 0 physical I/Os from your'e detached process then your'e table is in memory. It's crude, but can be effective.

-- 
Joel Fedorko                                Remember Bit Hopper, 
Sr. Consultant                      You must become one with the machine.
Day Data                         It's not the easy way, it's the cowboy way. 
jfedorko_at_ncsa.uiuc.edu             Any opinions I express will be ignored.