谢谢楼上的几位兄弟,我按照各位兄弟的说法办了,
首先把sga_target去掉,然后再执行alter system set statistics_level = basic scope=both;
但是有问题,在切换用户的时候出现
SQL> connect ive/live@pd
ERROR:
ORA-00604: error occurred at recursive SQL level 3
ORA-04031: unable to allocate 4000 bytes of shared memory ("shared
pool","select /*+ rule */ bucket_cn...","Typecheck heap","seg:kggfaAllocSeg"
ERROR:
ORA-00604: error occurred at recursive SQL level 3
ORA-04031: unable to allocate 4096 bytes of shared memory ("shared
pool","select name,password,datats#...","Typecheck heap","kgghteInit"
Error accessing package DBMS_APPLICATION_INFO
Connected.
在执行SQL的时候也出现这个问题
SQL> declare
2 cursor c_1 is select * from user_tables where last_analyzed is not null;
v_sql1 varchar2(200);
begin
for x_1 in c_1 loop345
6 v_sql1 := ' analyze table '||x_1.table_name||' delete statistics ';
execute immediate (v_sql1);
end loop;
end;789
10/
cursor c_1 is select * from user_tables where last_analyzed is not null;
*
ERROR at line 2:
ORA-06550: line 2, column 30:
PL/SQL: ORA-00604: error occurred at recursive SQL level 3
ORA-04031: unable to allocate 4000 bytes of shared memory ("shared
pool","select /*+ rule */ bucket_cn...","Typecheck heap","seg:kggfaAllocSeg"
ORA-06550: line 2, column 16:
PL/SQL: SQL Statement ignored
ORA-06550: line 6, column 31:
PLS-00364: loop index variable 'X_1' use is invalid
ORA-06550: line 6, column 2:
PL/SQL: Statement ignored
看来,这次问题是大了...............................
|