From oracle-l-bounce@freelists.org Fri Mar 12 09:53:56 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i2CFrug32458 for ; Fri, 12 Mar 2004 09:53:56 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i2CFruo32453 for ; Fri, 12 Mar 2004 09:53:56 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2E22F394DEE; Fri, 12 Mar 2004 10:52:53 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 12 Mar 2004 10:51:16 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from smtp.wangtrading.com (smtp.wangtrading.com [167.206.68.5]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 172B1394943 for ; Fri, 12 Mar 2004 10:50:45 -0500 (EST) Received: from mladen.wangtrading.com (Not Verified[192.168.3.47]) by smtp.wangtrading.com with NetIQ MailMarshal (v5.5.5.8) id ; Fri, 12 Mar 2004 10:55:24 -0500 Received: from mladen (localhost.localdomain [127.0.0.1]) by mladen.wangtrading.com (8.12.8/8.12.8) with ESMTP id i2CFu11C002200 for ; Fri, 12 Mar 2004 10:56:01 -0500 Date: Fri, 12 Mar 2004 10:56:01 -0500 From: Mladen Gogala To: oracle-l@freelists.org Subject: Re: Login Trigger Message-ID: <20040312155601.GA2163@mladen.wangtrading.com> References: <5.2.1.1.2.20040312104106.01ceac38@pop.netaddress.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Disposition: inline In-Reply-To: <5.2.1.1.2.20040312104106.01ceac38@pop.netaddress.com> (from maryann_30@yahoo.com on Fri, Mar 12, 2004 at 10:44:34 -0500) X-Mailer: Balsa 2.0.16 Lines: 72 X-archive-position: 680 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: mladen@wangtrading.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l 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@yahoo.com 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@freelists.org > >put 'unsubscribe' in the subject line. > >-- > >Archives are at http://www.freelists.org/archives/oracle-l/ > >FAQ is at http://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@freelists.org > >put 'unsubscribe' in the subject line. > >-- > >Archives are at http://www.freelists.org/archives/oracle-l/ > >FAQ is at http://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@freelists.org > put 'unsubscribe' in the subject line. > -- > Archives are at http://www.freelists.org/archives/oracle-l/ > FAQ is at http://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@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------