| Intermittent TNS-12500 Errors on W2k Advanced Server and Oracle 8.1.7.0.0 [message #62951] |
Fri, 27 August 2004 03:07  |
Trucho
Messages: 10
Registered: March 2002
|
Junior Member |
|
|
Intermittent TNS-12500 Errors:
Sometimes, Oracle return this error when we try to connect.
In many of those moments, there were 145-147 sessions and 148-150 processes (database parameters: Sessions=335 and processes=300).
What's a matter? why?
We have Oracle 8.1.7 run over W2k-A.S.
in 2GB.RAM Server with 2 CPUs.
Occasionally, i have observed errors in my Aplicattions like: "ORA-04030 out of process memory when trying to allocate 16896 bytes (cursor work he,kllcqas:kllsltba)"
that i donīt know if this comes from the same problem.
We have watch the database server and CPUs are working under 40% and free memory is more than 1Gb, normaly.
Can someone help me?
Thk u
Trucho
|
|
|
|
|
|
| Little Share Pool Size [message #62989 is a reply to message #62959] |
Tue, 31 August 2004 01:06  |
Trucho
Messages: 10
Registered: March 2002
|
Junior Member |
|
|
Ok, i have see the Share Pool Size and we just have 311.162.060 bytes.
We think it's a little value. Is it necesary more reduced?.
Moreover, Oracle.exe service is using 1.630.000 bytes.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
