Server very slow

From: Maciek <lokaj_at_poczta.onet.pl>
Date: 9 Oct 2002 04:41:01 -0700
Message-ID: <e13ef080.0210090341.1b522fc5@posting.google.com>

Hi all. Bit stumped here (hopefully just a simple problem):

os windows 2000 advanced server
6gb ram
4 x Xeon 700MHz
Oracle v. 8.1.7
ESRI sde
RAID-5 160GB (initorcl.ora)
background_dump_dest = e:\oracle\admin\orcl\bdump compatible = 8.1.7

control_files = "e:\oracle\oradata\orcl\control01.ctl"
control_files = "e:\oracle\oradata\orcl\control02.ctl"
control_files = "e:\oracle\oradata\orcl\control03.ctl"
db_block_buffers = 102066
db_block_lru_latches = 2
db_block_size = 8192
db_file_multiblock_read_count = 12
db_files = 1024

db_name = orcl
db_writer_processes = 2
distributed_transactions = 10
global_names = TRUE
hash_area_size = 2097152
instance_name = orcl

java_pool_size = 20971520
job_queue_interval = 60
job_queue_processes = 4

large_pool_size = 277872640

log_archive_dest_1 = "LOCATION=c:\oracle\ora817\RDBMS"
log_archive_start = TRUE
log_buffer = 10485760
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
max_dump_file_size = 10240
max_enabled_roles = 60
mts_dispatchers = "(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)"
mts_max_servers = 100
nls_language = Polish
nls_territory = Poland

open_cursors = 1000
open_links = 4
oracle_trace_collection_name = ""
os_authent_prefix = ""
parallel_max_servers = 5
processes = 400
remote_login_passwordfile = EXCLUSIVE
service_names = orcl
sessions = 321
shared_pool_size = 278710681

sort_area_retained_size = 262144
sort_area_size = 1048576
user_dump_dest = e:\oracle\admin\orcl\udump

utl_file_dir = e:\oracle\logs

server very slow !!!
have any suggestions on
where I should be looking for possible problem ?

Best Regards
Maciek Received on Wed Oct 09 2002 - 06:41:01 CDT