Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to make the SQL to run longer?
a.quick.email_at_gmail.com wrote:
> On Jun 28, 4:30 am, Raj <jkama..._at_gmail.com> wrote:
> > Raj wrote: > Raj wrote:
>
> > grant execute on dbms_lock to the_user ; > > create or replace function the_user.sleep_for ( sleep_time in > integer ) > return integer is > begin > DBMS_LOCK.SLEEP(sleep_time) ; > return sleep_time ; > end; > / > > -- Sleep for five seconds > select sleep_for(5) from dual ;
For those interested there are multiple ways to grant "sleep" privileges.
You will find 4 of them here
http://www.psoug.org/reference/sleep.html
If the purpose is to grant the privilege to a user then it is safer to create user_lock (not built by default) and grant privileges on that package.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Fri Jun 29 2007 - 15:45:23 CDT