Home » RDBMS Server » Performance Tuning » increase of sessions (Oracle 8.1.7)
increase of sessions [message #330593] Mon, 30 June 2008 09:44
darcioreine
Messages: 1
Registered: June 2008
Junior Member

Hello
I have a server with 1300 sessions
I need to increase 500 more because this ouver users. But we need this
redimensioning the memory of Oracle 8.1.7. And do not know much of Oracle 8.
How do these calculations? what parameters can this motion?
Below the confiraçoes of my oracle
I would thank

# in accordance to the OS block size on the HP...
db_block_size = 8192
ROLLBACK_SEGMENTS = (r01,r02,r03, r04,r05,r06, r07,r08,r09, r10)
db_file_multiblock_ read_count = 32
db_block_buffers = 65000
shared_pool_ size = 600000000
shared_pool_ reserved_ size = 30000000
large_pool_size = 83886080
pre_page_sga = yes
transactions_ per_rollback_ segment = 25
log_checkpoint_ interval = 999999999
distributed_ transactions = 350
processes = 900
dml_locks = 4860
log_buffer = 1048576
max_dump_file_ size = 302000 # limit trace file size to 5 Meg each
max_enabled_ roles = 50
CORE_DUMP_DEST = /tools/oracle/ admin/D03MB1/ cdump
USER_DUMP_DEST = /tools/oracle/ admin/D03MB1/ udump
AUDIT_FILE_DEST = /tools/oracle/ admin/D03MB1/ audit
BACKGROUND_DUMP_ DEST = /tools/oracle/ admin/D03MB1/ bdump
# The following three parms are required for automatic archiving ...
#log_archive_ start = true # if you want automatic archiving
log_archive_ start = false # if you do not want automatic archiving
log_archive_ dest = /tools/oracle/ admin/D03MB1/ arch/
log_archive_ format = archD03MB1_% s.dbf
timed_statistics = false
# On the recommendation of Oracle in regards to an ORA-600 abend:
# For remote os login using ops$ ...
# remote_os_authent = true remarks by Ledu 19-jun-2001
# remote_os_roles = true remarks by Ledu 19-jun-2001
resource_limit = true
open_cursors = 455
parallel_min_ servers = 2 # For parallel Query
parallel_max_ servers =150
_trace_files_ public = true
sort_area_size = 1048576
sort_area_retained_ size = 262144
db_writer_processes = 4
recovery_parallelis m = 2
db_block_lru_ latches = 8
hash_join_enabled = false
NLS_DATE_FORMAT= "DD-MON-RR"
enqueue_resources = 2500
open_links = 50
distributed_ transactions = 350
compatible=8. 1.7.4
optimizer_mode = rule
max_rollback_ segments= 50
job_queue_processes =3
sessions = 1300
processes = 1000
Previous Topic: Query is taking more time to execute
Next Topic: Tuning a query
Goto Forum:
  


Current Time: Thu Dec 08 02:37:52 CST 2016

Total time taken to generate the page: 0.10622 seconds