【摘要】 Oracle系统中,客户和服务器进程通过共享池进行自身对话或与其他进程之间的通信,在系统长期运行的过程中,共享池中因大量进程的调入调出操作而产生大量内存碎片,导致系统运行出错。本文给出了一种利用动态SQL及DBMS＿JOB包来实现自动冲洗共享池的方法。更多还原

【Abstract】 In oracle system,client and server processes communicate with each other or with itself in shared pool. After running a long period, a large mount of page_in or page_out operation will produce a large amount of memory fragments in shared pool, which will result in system running error. This paper gives a methord of automatic flushing shared pool by dynamic SQL and DBMS_JOB package.更多还原