Re: Performance

I found out that 90% of my performance bottlenecks were in the initSID.ora file.

The DB_BLOCK_SIZE was defaulted to 2048 so I changed it to 8192, you need to rebuild the DB to change this parameter. Then the second parameter was DB_BLOCK_BUFFERS which was defaulted to 1200 I changed it to 12500.
The shared pool size is also something to take a look at. I recommend buying the book Oracle Performance Tuning by Richard J Niemic (Oracle Press)

I will include my ORA file so if anybody sees something that can be enhanced, please let me know.
This database takes up around 160-180Mb of RAM but it runs really well.

Filip

db_name = HFDB
db_files = 1020
control_files = ("D:\Oracle\Ora81\database\ctl1HFDB.ora", "D:\Oracle\Ora81\database\ctl2HFDB.ora") db_file_multiblock_read_count = 16
db_block_buffers = 12500
shared_pool_size = 50000000
shared_pool_reserved_size = 5000000
log_checkpoint_interval = 9999999
processes = 100
dml_locks = 200
log_buffer = 2097152
sequence_cache_entries = 30
sequence_cache_hash_buckets = 23
#audit_trail = true
#timed_statistics = true
background_dump_dest = D:\Oracle\Ora81\rdbms80\trace user_dump_dest = D:\Oracle\Ora81\rdbms80\trace db_block_size =8192
compatible = 8.0.5.0.0
sort_area_size = 262144
sort_area_retained_size = 65536
log_checkpoint_timeout = 0
remote_login_passwordfile = shared
max_dump_file_size = 10240
nls_date_format = "DD-MON-YYYY"
optimizer_mode = CHOOSE
dbwr_io_slaves = 2
sort_direct_writes = true
log_archive_min_succeed_dest = 1
pre_page_sga = true
large_pool_size = 5000000
log_simultaneous_copies = 4

Nilo P.A. Cabrera <cabreras_at_wtp.net> wrote in message news:378F77B9.E846C787_at_wtp.net...
> I am have a problem with performance:
> Connecting/disconnecting to and from the database
> takes to long. 8-10 seconds. Even when working
> directly on the system console.
>
> Working with Oracle 7.3.3, 128MB ram
> dual pentiums, SCO Openserver 5.
>
> Any suggestions
>
>
> Nilo
>
Received on Fri Jul 16 1999 - 13:49:55 CDT