user8897201 wrote:what happens when "static" data changes in parameter tables?
In the beginning of my stored procedure I need to read static data from parameters tables. This stored procedure is executed a lot of times. There's any good approach to ensure that static data is always in memory and access will be faster?
We are using Oracle 11gR2.
You would replace the static assignment of 'myState' with a query to read your parameter table and init your variables.
create or replace package test_vars is myState VARCHAR2(30); end; / create or replace package body test_vars is begin myState := 'California'; end; /
user8897201 wrote:Don't bother doing anything. If the data really is read frequently it will remain in the Oracle buffer (memory) anyway.
The issue is that the stored procedure is executed through a job execution, i.e., everytime the job is executed I need to read again the table.