Use the DBMS_SHARED_POOL package to achieve this.