Re: Server very slow

As others have said, "it's slow" doesn't tell us much, and the init.ora is only a tiny part of the equation: we need to know what's happening *internally* when you report slowness.

Have a read up on installing and using STATSPACK (OK, the short answer is connect as sys, run the spcreate.sql script found in the ORACLE_HOME\rdbms\admin directory, and then periodically log on as PERFSTAT, password PERFSTAT and issue the command 'exec statspack.snap'). Make the duration between snaps meaningful (ie, the database is doing some decently-representative work).

Generate a STATSPACK report, and then visit www.oraperf.com to upload it to Anjo's analysis engine (these days, you have to register with the site before you can use it, but it's free). You get a report back within seconds.

If you've not tuned a database before, it can be daunting. But Anjo's site at least gives you somewhere to start.

Regards
HJR "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 - 15:27:51 CDT