| show parameter session (merged) [message #391156] |
Wed, 11 March 2009 04:36  |
dirish
Messages: 232
Registered: November 2006
|
Senior Member |
|
|
Hi,
I have a DB server with the following parameters:
SQL> sho sga;
Total System Global Area 2550136832 bytes
Fixed Size 1980808 bytes
Variable Size 268437112 bytes
Database Buffers 2264924160 bytes
Redo Buffers 14794752 bytes
SQL> sho parameter sessions;
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
logmnr_max_persistent_sessions integer 1
sessions integer 200shared_server_sessions integer
RAM Size = 8GB
Following the figures above, I want to know the maximum size I can set to the parameter sessions as I am expecting a rise in number of sessions/users.
Thank you,
Dirish
|
|
|
|
|
|
|
|
| Re: show parameter session (merged) [message #391908 is a reply to message #391389] |
Sat, 14 March 2009 09:35  |
alexzeng
Messages: 133
Registered: August 2005
Location: alexzeng.wordpress.com
|
Senior Member |
|
|
| dirish wrote on Thu, 12 March 2009 14:19 | SQL> sho parameter pga;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
pga_aggregate_target big integer 809M
|
Let's say, you can set the pga_aggregate_target to 1200M, then you can set the sessions to 300.
Regards,
Alex
[Updated on: Sat, 14 March 2009 10:03] by Moderator Report message to a moderator |
|
|
|
| Re: show parameter session (merged) [message #392771 is a reply to message #391908] |
Thu, 19 March 2009 04:30 |
dirish
Messages: 232
Registered: November 2006
|
Senior Member |
|
|
Hello,
Kindly let me know if I should increase other parameters to cater for large number of users. Please find below my init.ora file.
processes=150
sga_target=2550136832
db_block_size=8192
compatible=10.2.0.1.0
archive_lag_target=0
db_file_multiblock_read_count=16
db_flashback_retention_target=1440
undo_management=AUTO
undo_tablespace=UNDOTBS1
job_queue_processes=10
open_cursors=300
pga_aggregate_target=848297984
control_files=/oracle/product/10.2.0/Db_1/dbs/DG_CONTROL_FILE
db_name=ROCLIVE
dg_broker_start=true
remote_login_passwordfile=exclusive
db_recovery_file_dest='/archive/arch'
db_recovery_file_dest_size=4096M
log_archive_dest_1='LOCATION=use_db_recovery_file_dest','valid_for=(ALL_ROLES,ONLINE_LOGFILE)'
log_archive_dest_2='LOCATION=use_db_recovery_file_dest','valid_for=(STANDBY_ROLE,STANDBY_LOGFILE)'
db_domain=roc.mti.gov.bw
_log_deletion_policy='all'
db_file_name_convert='/d01/','/d01/'
standby_file_management=auto
log_file_name_convert='/d01/redo','/d01/primredo','/archive/arch//onlinelog','/d01/primredo'
db_unique_name=LIVE
log_archive_format=%t_%s_%r.dbf
local_listener=LISTENER
control_files=/d01/primcontrolfiles/control01.ctl |
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
