This discussion is archived
1 Reply Latest reply: Dec 16, 2011 12:26 AM by Antonio Navarro RSS

pga_aggregate_target value is affect listener?

anbob Newbie
Currently Being Moderated
Last week, encountered a problem, oracle 9i201 database WINDOWS 2003 32-bit, run the process after a period of LSNRCTL.EXE the CPU to 50%, the application can not connect to the database, and before conneced SESSIONs is work, databases is work, query V $ SESSION a total of more than 20, I check the SPFILE the pga_aggregate_target is 25m, then I transferred to the 600m, there is no LSNRCTL.EXE has been returned to the 0% or so, the problem is not observed for two days again

My question is, then I transferred to the test machine to pga_aggregate_target 10M, you can build 20 SESSIONs problem did not appear above, do not know how to reproduce that problem?pga_aggregate_target would not affect the listener´╝č


  • Correct Answers - 10 points
  • Helpful Answers - 5 points