how many number of users in a database
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?
Re: how many number of users in a database
Quote:
Originally posted by yls177
so how many maximum users can the database support?
depends on 'processes' & 'sessions'...
show parameter processes
show parameter sessions
HTH.