解决ORA-12518的办法

来源：互联网发布：android编译源码刷机编辑：程序博客网时间：2024/04/30 06:15

出现ORA-12518

Pga太小由于pga_aggregate_target设置0参数文件里而启动实例的

或是（Pga太小，会自动改参数processes和sessions值？）参数processes和sessions的关系不对：sessions=1.1*processes+5

SQL> show parameters process

NAME TYPE VALUE

----------------------------------------------- --------------

aq_tm_processes integer 0

cell_offload_processing boolean TRUE

db_writer_processes integer 1

gcs_server_processes integer 0

global_txn_processes integer 1

job_queue_processes integer 50

log_archive_max_processes integer 4

processes integer 150

SQL> show parameters session

NAME TYPE VALUE

----------------------------------------------- --------------

java_max_sessionspace_size integer 0

java_soft_sessionspace_limit integer 0

license_max_sessions integer 0

license_sessions_warning integer 0

session_cached_cursors integer 50

session_max_open_files integer 10

sessions integer 248

shared_server_sessions integer

SQL> select count(*) from v$session;

COUNT(*)

----------

SQL> select count(*) from v$process;

COUNT(*)

----------

ORA-00604: 递归 SQL 级别 1 出现错误

ORA-04030: 在尝试分配 1048592 字节(kxs-heap-w,kcbpioqInitClientBuffer)

时进程内存不足

0 0