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