| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Login Trigger
I don't understand! So the query is slow, and you want to store the information during login to be useful afterwards!
Why, how many hours will it take the user to press the button after login?
Waleed
-----Original Message----- From: Jared.Still_at_radisys.com [mailto:Jared.Still_at_radisys.com] Sent: Thu 5/20/2004 5:59 PM To: oracle-l_at_freelists.org Cc: Subject: Re: Login Trigger What you're thinking of is package variables. Variables declared in the header of a package will persist until they are changed or the user logs out. e.g. create or replace package p is my_login_name varchar2(30); procedure setname; end; / create or replace package body p is procedure setname is begin my_login_name := user; end; end; / You can now reference p.my_login_name outside of the package. Just call the proc from the login trigger. Jared oracle-l-bounce_at_freelists.org wrote on 03/11/2004 10:16:21 AM:-- Type: application/ms-tnef
> 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 <https://access0.fidelity.com/,DanaInfo=www.orafaq.com+>
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/ <https://access0.fidelity.com/archives/oracle-l/,DanaInfo=www.freelists.org+>
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html <https://access0.fidelity.com/help/fom-serve/cache/1.html,DanaInfo=www.freelists.org+>
> -----------------------------------------------------------------
---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com <https://access0.fidelity.com/,DanaInfo=www.orafaq.com+> ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ <https://access0.fidelity.com/archives/oracle-l/,DanaInfo=www.freelists.org+> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html <https://access0.fidelity.com/help/fom-serve/cache/1.html,DanaInfo=www.freelists.org+> ----------------------------------------------------------------- -- Binary/unsupported file stripped by Ecartis --
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Thu May 20 2004 - 21:26:58 CDT
 |
 |