摘要： 环境：RHEL 6.2 x64Oracle 11.2.0.1.0Memory 4GMEMORY_TARGET=1584M/dev/shm 2G将MEMORY_TARGET调整为2048M后，重启数据库报错ORA-00845: MEMORY_TARGET not supported on this system$ oerr ora 84500845, 00000, "MEMORY_TARGET not supported on this system"// *Cause: The MEMORY_TARGET parameter was not supported on thi 阅读全文

摘要： 1 declare 2 v_sql varchar2(4000); 3 v_c1 number; 4 v_c2 number; 5 begin 6 v_c2 := 999; 7 v_sql := 'begin '; 8 v_sql := v_sql||'update te1 set c1='||v_c1||', c2='||v_c2||' where c1=1 and c2=1;'; 9 v_sql := v_sql||' if sql%notfound then ';10 v_sql := v_sql||' 阅读全文