Re: quick suggestions for tuning ?

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 <sfaroult_at_oriole.com>
>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: jprem_at_kssnet.co.jp

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).