how many number of users in a database
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: how many number of users in a database

  1. #1
    Join Date
    Oct 2002
    Posts
    391

    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?

  2. #2
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865

    Re: how many number of users in a database

    Originally posted by yls177

    so how many maximum users can the database support?
    depends on 'processes' & 'sessions'...

    show parameter processes

    show parameter sessions

    HTH.

  3. #3
    Join Date
    Oct 2002
    Posts
    391
    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

  4. #4
    Join Date
    Aug 2002
    Location
    Bangalore, India
    Posts
    405
    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.
    -nagarjuna

  5. #5
    Join Date
    Oct 2002
    Posts
    391
    how do i check the number of " exp/imp processesm job queue processes, db link processes "?

    thanks

  6. #6
    Join Date
    Oct 2002
    Posts
    391
    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?

  7. #7
    Join Date
    Aug 2002
    Location
    Bangalore, India
    Posts
    405
    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.
    -nagarjuna

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width