Re: Creating a 'library cache pin' wait for testing.

On 9 Mar 2006 14:03:19 -0800, "P" <paul.hancock1_at_gmail.com> wrote:

>Can anyone please advise of a good method for creating a 'library cache
>pin' wait event in order that I can test out some scripts I have to
>capture information.
>
>The only way I currently have of doing this is (as per Metalink):
>
>Session 1: Create a dummy procedure:
>Create or replace procedure dummy1 is
>begin
>null;
>end;
>/
>Session 1: Execute the above procedure in a PL/SQL block:
>Begin
>Dummy1;
>Dbms_lock.sleep(60);
>End;
>/
>Session 2: grant execute on dummy1 to user_name;
>

So what's the problem with this code? Invoking procedures requires the pin. I don't see why the sleep is in there. You can also create a loop with a lot of dynamic sql.
.......
We run Oracle 9.2.0.6 on RH4 AMD
remove NSPAM to email Received on Tue Mar 14 2006 - 11:03:25 CST