Re: Server very slow

You need to be more explicit as to what is slow. What you have said below is like going to the Dr. and saying:
Dr. I'm in pain and I am a Caucasian male age 34, 172 pounds, brown hair, blue eyes, 6 feet tall and wear a size 11 shoe. All true data but the Dr. can't fix the problem. So where does it hurt? How much does it hurt? (eg when I do the following query ... it takes 10 seconds to return, here is the explan plan and the tkprof...)

(you have all your control files in one place on one device - bad idea. That isn't the cause of the slowness, but if you lose the drive you lose the database. Put one somewhere else. Also raid 5 is not always the best idea, but we don't know that is the problem yet.)

Jim

"Maciek" <lokaj_at_poczta.onet.pl> wrote in message news:e13ef080.0210090341.1b522fc5_at_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 - 08:43:31 CDT