DBMS_SHARED_POOL.KEEP

From: Bunyamin K. Karadeniz <bunyamink_at_havelsan.com.tr>
Date: Thu, 18 Apr 2002 00:28:22 -0800
Message-ID: <F001.00447917.20020418002822@fatcity.com>

I want to pin most run packages , I have loeded them into a table. For this I have written ,

create or replace procedure pin_packages_defined as sql_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;
BEGIN
FOR tab_row IN tab_cur LOOP
--EXECUTE IMMEDIATE 'EXEC SYS.DBMS_SHARED_POOL.KEEP('||tab_row.owner||'.'||tab_row.object_name||')';
cursor_name := dbms_sql.open_cursor;
sql_sentence :='SYS.DBMS_SHARED_POOL.KEEP('''||tab_row.owner||'.'||tab_row.object_name||''')';

dbms_output.put_line(sql_sentence);
dbms_sql.parse(cursor_name,sql_sentence, dbms_sql.native);
rows_processed := dbms_sql.execute(cursor_name);
dbms_sql.close_cursor(cursor_name);

END LOOP;
END; But , It does not execute , Is it impossible to execute DBMS_SHARED_POOL.KEEP dynamically ...I tried DBMS_JOB , It did not work too.

How can I do this?

Bunyamin K. Karadeniz
Oracle DBA / Developer
Civilian IT Department
Havelsan A.S. Eskisehir yolu
7.km Ankara Turkey
Phone: +90 312 2873565 / 1217
Mobile : +90 535 3357729

The degree of normality in a database
is inversely proportional to that of its DBA.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Bunyamin K. Karadeniz
  INET: bunyamink_at_havelsan.com.tr

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Apr 18 2002 - 03:28:22 CDT