同样的语句：plsqldeveloper导致ORA-04031，但在本地执行则正常！
用plsqldeveloper执行:
SQL> select tablespace_name,file_name,bytes/1024/1024/1024,autoextensiblefrom dba_temp_files order by tablespace_name,FILE_NAME;
select tablespace_name,file_name,bytes/1024/1024/1024,autoextensiblefrom dba_temp_files order by tablespace_name,FILE_NAME
ORA-04031: unable to allocate 3888 bytes of shared memory ("shared pool","unknown object","sga heap(2,0)","kglsim object batch")
用ssh在服务器本地执行：
SQL> SQL> SQL> SQL> select tablespace_name,file_name,bytes/1024/1024/1024,autoextensiblefrom dba_temp_files order by tablespace_name,FILE_NAME;
TABLESPACE_NAMEFILE_NAME
BYTES/1024/1024/1024 AUT
-------------------- ---------------------------------------------------------------------- -------------------- ---
TEMP2
/data/oradata/smsdb/temp021.dbf
4.8828125 YES
难道是plsqldeveloper的bug？
|
