报错如下
第一种办法:(可以马上生效,但是不长久。)
alter system flush shared_pool;
第二种办法:(需要重启数据库)
修改共享内存池大小
1.关闭数据库 shutdown immediate 或者 shutdown abort 2.启动数据库 startup 3.登陆数据库查看当前共享池空间 [oracle@oracle-server bin]$ ./sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Wed May 15 16:20:16 2019 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> conn sys/sys as sysdba Connected. SQL> show parameter shared_pool_size; NAME TYPE ------------------------------------ ---------------------- VALUE ------------------------------ shared_pool_size big integer 128M SQL> 4.适当增加共享池空间 SQL> alter parameter system shared_pool_size = '500M' scope=spfile; system altered 5.重启数据库 (执行步骤1,2) 6.查询共享池大小(执行步骤 3)
—————————————————————–搞定————————————————————————-