Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

INTEGER VS NUMBER

450482Oct 2 2008 — edited Oct 2 2008
Hi
I am trying to understand what is the difference between INTEGER AND NUMBER datatypes in Oracle and when to use what and why?
Would be great if someone could explain.
Thx!

Comments

543354
I forget some important information:

Cliente Timesten Version: 7.0.0.1
Server TimesTen Version: 7.0.0.3

Regards
600280
i have the seem problem
Slaw-Oracle
Is this problem reproducable? i.e. Does it occur whenever you get close to 125 clients connecting to TimesTen? Next time when it happens again, can you check to see whether you can establish a new client/server connection locally on the TimesTen server machine?

Each TimesTen Client connection requires one server process, and by default, a server process is spawned when a client requests a connection. It is possible that you may have too many processes running on the server, hence it cannot spawn additional server processes to handle the new connections. The good news is that in 7.0.3, the TimesTen server is now multi-threaded and each process can handle multiple client connections (this number is configurable), so it's possible to have fewer server processes for the same number of client connections compared to previous releases.

Please check out "Specifying multiple connections to the TimesTen Server" in the 7.0.3 Oracle TimesTen Operations Guide for more information on how to turn on the multithreaded mode.

Regards

Simon
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 30 2008
Added on Oct 2 2008
#general-database-discussions
5 comments
84,056 views