forget about parameters ... look at fixing the SQL
that is causing the problem
hth
connor
- Hamid Alavi <hamid.alavi_at_quovadx.com> wrote: >
Dear List,
>
> I am monitoring a database, & I findout there is a
> transaction which runing
> a long time and others are waiting for this
> transaction, this transaction
> have 8,000,000 consistant gets with only 1 Physical
> I/O.
> My question is, what I have to do except the SQL
> tuning to make this
> transaction faster, we have done all the necessary
> tuning on all the SQL
> query's.
> Here is a copy of ora.ini:
>
> Oracle 8.1.7.4 on sun solaris 2.8
>
> background_dump_dest = /oracle/admin/cmstst/bdump
> compatible = 8.1.7.4
> control_files = "/cmsdb/cmstst/control02.ctl"
> control_files = "/oralogs1/cmstst/control03.ctl"
> control_files =
> "/oracle/oradata/cmstst/control01.ctl"
> core_dump_dest = /oracle/admin/cmstst/cdump
> db_block_buffers = 10000 ??? this need to
> increase?
> db_block_lru_latches = 4
> db_block_size = 8192
> db_file_multiblock_read_count = 16
> db_name = cmstst
> hash_area_size = 2048000 ??? need tuning ???
> instance_name = cmstst
> java_pool_size = 20971520
> large_pool_size = 614400
> log_archive_dest_1 = "location=/archlogs/cmstst"
> log_archive_format = "arch%s.arc"
> log_archive_start = TRUE
> log_buffer = 262144 ?? this log buffer
> is enough??
> log_checkpoint_interval = 10000 ??
> log_checkpoint_timeout = 1800
> max_enabled_roles = 30
> open_cursors = 300
> optimizer_index_caching = 90
> optimizer_index_cost_adj = 35
> os_authent_prefix = ""
> processes = 100
> remote_login_passwordfile = EXCLUSIVE
> session_cached_cursors = 100
> shared_pool_size = 134217728
> sort_area_retained_size = 262144
> sort_area_size = 262144
> timed_statistics = TRUE
>
>
> I realy appreciate your help and assistant. I am
> getting confused, just want
> to know changing any of these parameter help the
> performance to reduce the
> number of CONSISTANT GETS or NOT???
>
> Thanks in advance.
>
>
>
> Hamid Alavi
> Office 818 737-0526
> Cell 818 416-5095
>
>
>
>
>
>
> ======================= Confidentiality Statement
> =======================
> The information contained in this message and any
> attachments is
> intended only for the use of the individual or
> entity to which it is
> addressed, and may contain information that is
> PRIVILEGED, CONFIDENTIAL
> and exempt from disclosure under applicable law. If
> you have received
> this message in error, you are prohibited from
> copying, distributing, or
> using the information. Please contact the sender
> immediately by return
> e-mail and delete the original message from your
> system.
> ===================== End Confidentiality Statement
> =====================
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Hamid Alavi
> INET: hamid.alavi_at_quovadx.com
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web
> hosting services
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Connor McDonald
http://www.oracledba.co.uk
http://www.oaktable.net
"GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day"
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
INET: hamcdc_at_yahoo.co.uk
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Thu Nov 14 2002 - 12:23:59 CST
