Maryann, here is the solution of all solutions for disk caching. I believe that a thing like that would solve your problem: http://www.techworld.com/news/index.cfm?fuseaction=displaynews&NewsID=1176 On 03/12/2004 10:44:34 AM, Maryann Atkinson wrote: > Some coworker told me that login triggers actually > store things on disk instead, and that every time this > stored info is needed, a disk access will have to occur instead, > and that doesnt sound too great of a concept... > > Does anyone who used login triggers extensively > have any knowledge and/or opinion to share? > > thanks, > maa > > > At 10:22 AM 3/12/2004, you wrote: > >Maa, > > It is a great concept,,, store everything in memory and eliminate > >disks. with enough memory you could store the info each user needed. > > If the user is going to request the same info each time why not use > >materialized views to increase the thru put. > >Ron > > > > >>> maryann_30@xxxxxxxxx 03/11/2004 1:16:21 PM >>> > >We have a fairly big query that takes about 6 hours > >to complete. To speed up things, we thought of the > >following: Create a logon trigger, which stores in memory > >each user's info during login time. > > > >Then when the user clicks a button that starts this query, > >to have his/her info already in memory as opposed to > >getting it from disk somewhere. > > > >So basically, I just wanted to verify that a login trigger > >does indeed store things in memory and keeps it there > >until logout. Is that correct, or should I expect surprises? > > > >thanks, > >maa > > > >---------------------------------------------------------------- > >Please see the official ORACLE-L FAQ: http://www.orafaq.com > >---------------------------------------------------------------- > >To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx > >put 'unsubscribe' in the subject line. > >-- > >Archives are at //www.freelists.org/archives/oracle-l/ > >FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > >----------------------------------------------------------------- > >---------------------------------------------------------------- > >Please see the official ORACLE-L FAQ: http://www.orafaq.com > >---------------------------------------------------------------- > >To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx > >put 'unsubscribe' in the subject line. > >-- > >Archives are at //www.freelists.org/archives/oracle-l/ > >FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > >----------------------------------------------------------------- > > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > ----------------------------------------------------------------- > ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------