Re: Server cache for certain reference tables...

From: Julio <julio.negueruela_at_si.unirioja.es>
Date: Thu, 23 Apr 1998 16:55:51 +0200
Message-ID: <353F5677.FB1AF3D8@si.unirioja.es>

kolli_s_at_hotmail.com escribió:
> =

> Hi,
> =

> According to our database model we will end up joining the main data=

> table with several smaller reference tables for almost every select
> query. I am trying to find if there is a way in Oracle to keep cert=
ain
> tables in buffer (cache or whatever) *all the time* so that our join=
s
> do not take too long. I know that it's possible in Sybase (11.x.x).

It'd be helpful de small_threshold_table parameter. It's the minimun table size so the table's blocks wont be put on the LRU end of the list after a full scan.

Regards.
-- =

Julio Negueruela
DBA Servicio Informático

Universidad de La Rioja      -      Spain
Telf: 941-299179     Fax: 941- 299180

mailto:julio.negueruela_at_si.unirioja.es Received on Thu Apr 23 1998 - 09:55:51 CDT