Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Max sessions With Oracle SE
I don't fully understand what you are trying to say.
On OTN choose download, scroll down to the bottom, under Archived products
choose 8i.
Oracle 8.1.7 EE 64-bit for HP-UX is available for download, not 32-bit, not
SE.
The only reason I can think of why Oracle recommends EE that is "well designed to support high load" is because they get more (much more) license fee and it has some options for scalability and so. Not said that SE could not do the job, but it also depends on if and how your application can use these options.
Do you need 64-bit or do you really need 32-bit? Don't understand what you
wrote.
I've read that 64-bit is not always better/faster than 32-bit. It takes more
memory because a word is always 64-bit, also where 32-bit would be
sufficient. These kind of arguments.....
Maybe the machine is to0 small for 2 databases with so many users. One
should be ok.
It also depends on how big the SGA need to be. Java, many stored procedures,
triggers etc.. need big java_pool and shared_pool_size. How many
db_block_buffers are needed to prevent performance degradation due to heavy
I/O?
These 3 parameters determine most of the SGA size. Enough memory must remain
for the Operating System and the server processes.
Given the limited amount of memory for 300 concurrent user sessions (as a
rule of thumb 1-2 Mb/server?) I would choose for MTS initially, reducing the
number of active (shared) server processes to let's say 2 or 4 for every
database. Don't start too much shared servers. The only result is they start
fighting for the CPU.
I have experienced on a Sun 10K box with 8 CPU's, a V8.0.5 database running
MTS and 200-300 concurrent users that it runs better with 12 shared servers
than with 20. So shared servers = 1.5 or 2 * #CPU's. It appeared to be more
efficient to let dispatchers wait on a free shared server than have more
concurrent active shared servers that get kicked of the CPU by the operating
system (expensive context switches) every x milliseconds, waisting about 10%
of CPU power in system time.
Since you have much less CPU's I don't want to clain this formula scales
down to this number, but never the less I think I should share this
experience with you.
XAV <xbo_at_clt-ufa.net> schreef in berichtnieuws
3d2d696d$1_at_kirchberg2.clt-ufa.net...
| Tx for the feed-back !
|
| I found both release (32b and 64b) for Oracle 9i on oracle site
| (http://otn.oracle.com/software/products/oracle9i/htdocs/hpsoft.html)
| but not for Oracle 8i :
|
| avaible to download
| --------------------------------------------------------------------------