Thanks a lot Stephane. There are indexes on profile table which u pointed out. but none of the tables/indexes are analyzed yet.
Connor pointed that there are 54million consistent gets. LIO is high. does it mean that db_cache_size (700M) is small ? how to deal with this ? Can u throw some light on this Stephane ? Regards, Jp. >From: Stephane Faroult <[EMAIL PROTECTED]> >Subject: Fwd: Re: quick suggestions for tuning ? >Date: 11-08-2003 00:29:23 >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: Prem Khanna J 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).