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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).