Re: Database design

From: Joel Garry <joelga_at_pebble.ml.org>
Date: 1998/01/27
Message-ID: <6am212$hu9$1@pebble.ml.org>#1/1

In article <01bd2919$ba8ce900$cf0bbac3_at_m3bj1>, Mabel Trigüis <mabelle_at_bluewin.ch> wrote:
>Thank you for your answer.
>1) No, the database is not insert intensive.
>2) The idea is to make it easier to maintain. Having the rules in two
>places will double the work.
>We are thinking about calling the relevant store procedure in
>When-validate-item or when-validate record. The problem is that I am afraid
>Oracle will be very slow calling stored procedures.
>Mabel,

You might look into the dbms.shared_pool_keep to pin things in the SGA.

>
>

-- 
These opinions are my own and not necessarily those of Information Quest
jgarry@eiq.com                           http://www.informationquest.com
http://ourworld.compuserve.com/homepages/joel_garry
"See your DBA?"  I AM the @#%*& DBA!

Received on Tue Jan 27 1998 - 00:00:00 CST