如何增加PROCESSES参数值以允许Oracle数据库侦听器根据我的环境要求生成更多服务器进程? [英] How to increase the PROCESSES parameter value to allow the Oracle database Listener to spawn more server process as required in my environment ?

问题描述

如何增加PROCESSES参数值以允许Oracle数据库侦听器根据您的环境产生更多的服务器进程?
当我尝试更新MAX_UTILIZATION时，oracle向我提示错误:
"ORA-02030:只能从固定的表/视图中选择"

从下面的非解决方案复制的其他信息
我只是在同一个应用程序中运行几个查询(超过40个查询(插入，选择，删除，更新，...)，然后在google中搜索此错误:google说""v $ resource_limit"中的MAX_UTILIZATION "table = 40，当我尝试
时我无法更新它 更新v $ resource_limit设置MAX_UTILIZATION = 100"(并且我已登录到系统"帐户)
我在oracle xe 10上工作
请帮助我
非常感谢您

How can i increase the PROCESSES parameter value to allow the Oracle database Listener to spawn more server process as required in your environment?
when i try to update the MAX_UTILIZATION the oracle shouw me a error:
"ORA-02030: can only select from fixed tables/views"

additional information copied from non-solution below
i just run several queries in the same application ( more than 40 queries (insert,select,delete,update,... ) , and i search in google on this error : google "says" that the MAX_UTILIZATION in the "v$resource_limit" table = 40 and i can''t update it when i try
"update v$resource_limit set MAX_UTILIZATION = 100 " (and i am logged into the "system" account)
i work on oracle xe 10
please help me
thank you very much

推荐答案

resource_limit表= 40，当我尝试
时我无法更新它 "update v

resource_limit" table = 40 and i can''t update it when i try
"update v

resource_limit set MAX_UTILIZATION = 100"(并且我已登录系统"帐户)
我在oracle xe 10上工作
请帮助我
非常感谢

resource_limit set MAX_UTILIZATION = 100 " (and i am logged into the "system" account)
i work on oracle xe 10
please help me
thank you very much

这篇关于如何增加PROCESSES参数值以允许Oracle数据库侦听器根据我的环境要求生成更多服务器进程?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！