Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ORA12518

Status
Not open for further replies.
JBOG

JBOG

IS-IT--Management
Apr 23, 2007
2
BE
Hi, we are running an Oracle 10g server on performant hardware (HP DL380 W2003,Dual Xeon, 4 GB ram, write back cache on the controller, RAID 5, etc...)

We migrated this weekend from an Oracle 7.3.4 server to 10g and expierencing a lot of connection troubles with the listener.

When going above 340 threads clients are unable to connect.
We connect with Oracle ODBC drivers to the DB.
Processes and sessions are set on 600.
SGA size is set on 1080 MB.

In the eventviewer we see: "unable to begin another thread"

Anyone an idea where we need to search or how to trace what is giving us these problems?

thanks,
Jef
 
Sort by date Sort by votes
On 32-bit Windows you can have a maximum of (2 GB / thread-size) threads within the overall oracle.exe process. The default thread size on Windows is 1 MB, but is genearlly 3+ MB per thread for dedicated oracle connections. Don't forget Oracle uses many threads for itself. This all implies you can have approx 400 simultaneous users. The more memory used by the threads means the less threads you get. Also, parallel query slaves and other threads eat into your numbers, so 340 was not too suprising.

MarkRem
Author, Oracle Database 10g: From Nuts to Soup
 
Upvote 0 Downvote
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top