how many number of users in a database

[yls177]

my database configuration

Total System Global Area 406056944 bytes
Fixed Size 69616 bytes
Variable Size 82427904 bytes
Database Buffers 323379200 bytes
Redo Buffers 180224 bytes

in my initSID.ora i have the below configuration

open_cursors = 100
max_enabled_roles = 30

db_block_buffers = 39475

shared_pool_size = 52428800

large_pool_size = 614400
java_pool_size = 20971520

log_checkpoint_interval = 1000000
log_checkpoint_timeout = 180000

processes = 120

log_buffer = 163840

db_block_size = 8192

job_queue_processes = 4
job_queue_interval = 60
distributed_transactions = 10
open_links = 4

compatible = "8.1.0"
sort_area_size = 65536
sort_area_retained_size = 65536


so how many maximum users can the database support?

[ggnanaraj]

Originally posted by yls177

so how many maximum users can the database support?

depends on 'processes' & 'sessions'...

show parameter processes

show parameter sessions

HTH.

[yls177]

SVRMGR> show parameter processes
NAME TYPE VALUE
----------------------------------- ------- --------------------------
aq_tm_processes integer 0
db_writer_processes integer 1
job_queue_processes integer 4
log_archive_max_processes integer 1
processes integer 120


NAME TYPE VALUE
----------------------------------- ------- --------------------------
java_max_sessionspace_size integer 0
java_soft_sessionspace_limit integer 0
license_max_sessions integer 0
license_sessions_warning integer 0
mts_sessions integer 132
sessions integer 137


1) how many maximum users can the database support?
2) how many CONCURRENT users can the database support?

thanks

[nagarjuna]

Originally posted by yls177
SVRMGR> show parameter processes
NAME TYPE VALUE
----------------------------------- ------- --------------------------
processes integer 120


NAME TYPE VALUE
----------------------------------- ------- --------------------------
sessions integer 137


1) how many maximum users can the database support?
2) how many CONCURRENT users can the database support?

thanks

So, we can spawn 120 Oracle processes.. Subtract number of background processes from this. The resultant is the number of users that can connect to database at any time.. Hold on.. there is allways something like exp/imp processesm job queue processes, db link processes etc that use Oracle processes.

[yls177]

how do i check the number of " exp/imp processesm job queue processes, db link processes "?

thanks

[yls177]

oops, i can get that from my earlier posts....

but i haev another question though,

oracle license is kept to the number of cpus? i mean the number of users that can use oracle is depend on the number of cpus?

[nagarjuna]

Originally posted by yls177
oops, i can get that from my earlier posts....

but i haev another question though,

oracle license is kept to the number of cpus? i mean the number of users that can use oracle is depend on the number of cpus?

There are many methods in calculation limit of Oracle licence.

Number of sessions.
Number of users.
Number of CPUs.