Prem Khanna J wrote:
>
> Guys,
>
> I have attached statspack report here.
> The ENV is Oracle 9.2.0.3 / Win2k AS - SP3.
>
> 1.Can you tell me which INIT parameters are to be changed
> which will give improved performance ?
>
> 2.can someone give a rough idea about where the bottlenecks are ?
>
> I read the doc "228913.1 - Systemwide Tuning using STATSPACK Reports"
> and gave a try with YAPP also.
>
> Bind vars are to be used - that is one i found out from statspack
> report.
>
> just new to statspack and so i'm seeking ur suggestions.
>
> Regards,
> Jp.
>
> ------------------------------------------------------------------------
> Name: MOREI0808-2024.sql
> MOREI0808-2024.sql Type: unspecified type (application/octet-stream)
> Encoding: Base64
I think that indexing the 'profile' table on entpc and laccess could be
a good thing to start with.
Probably some work to do on MSG_HISTORY as well. You are right about
bind variables, but it won't help the queries on MSG_HISTORY, where the
long string of ORs is obviously dynamically built. Oracle doesn't often
choose to iterate as it should with a long string of ORs (or a long IN
list), the 'FIRST_ROWS' hint may help. You can also tell your developers
to review the English irregular verbs, especially 'to send'.
Forget about the magical INIT parameter.
--
Regards,
Stephane Faroult
Oriole Software
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephane Faroult
INET: sfaroult_at_oriole.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).
Received on Sun Aug 10 2003 - 10:29:23 CDT
