If on 8i you could use a startup trigger for this. Here's mine:
create or replace trigger sys.pin_db_objects
after startup on database
begin
sys.dbms_shared_pool.keep('SYS.DBMSZEXP_SYSPKGGRNT');
sys.dbms_shared_pool.keep('SYS.DBMS_ALERT');
alternately you can put in into a sql file and run/start at sql from statup
script. No need for any trigger...File may be added with additional packages
for pinning...
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Sat, 20 Apr
Bunyamin,
Either try
removing the 'EXEC' or try putting a begin and end around the
call?
EXECUTE IMMEDIATE
'SYS.DBMS_SHARED_POOL.KEEP('||tab_row.owner||'.'||tab_row.object_name||')';
or
EXECUTE IMMEDIATE 'BEGIN
SYS.DBMS_SHARED_POOL.KEEP('||tab_row.owner||'.'||tab_row.object_name||')' ||
.
- Original Message -
From:
Mercadante, Thomas F
To: Multiple recipients of list ORACLE-L
Sent: Thursday, April 18, 2002 4:18
PM
Subject: RE: DBMS_SHARED_POOL.KEEP
Bunyamin,
Either try
removing the 'EXEC' or try putting a begin and end around the
call?
EXECUTE
Um,
why can't you do this...
create or replace
procedure pin_packages_defined assql_sentence
varchar2(200);cursor_name
INTEGER;rows_processed INTEGER;CURSOR tab_cur
IS SELECT owner,object_name FROM
arsiv.pin_aday_objeler;tab_row
tab_cur%ROWTYPE;BEGINFOR tab_row IN tab_cur
LOOP
You
are calling a PL/SQL package from PL/SQL. Just get rid of all the execute
immediate
exec
stuff and call the package directly :
sys.dbms_shared_pool.keep();
-Original Message-From: Bunyamin K. Karadeniz
[mailto:[EMAIL PROTECTED]]Sent: Thursday, April 18, 2002
4:28 AMTo: