>Thanks a lot Stephane.
>
>There are indexes on profile table which u pointed
>out.
>but none of the tables/indexes are analyzed yet.
First thing to do.
>Connor pointed that there are 54million consistent
>gets.
>LIO is high.
>
>does it mean that db_cache_size (700M) is small ?
>how to deal wit
At 06:59 AM 8/11/2003 -0800, you wrote:
Thanks a lot Connor.
Apart from bind vars.,LIO is a big issue here.
54 million consistent gets.
does it mean that db_cache_size (700M) is small ?
No, the buffer pool size has absolutely nothing to do with the number of
logical IOs. Its size only determines h
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.
>Proba
;
> any good docs or links regarding LIO and how to deal with it ?
>
> Can u explain me Connor ?
>
> Regards,
> Jp.
>
>
> >From: Connor McDonald <[EMAIL PROTECTED]>
> >Subject: Fwd: Re: quick suggestions for tuning ?
> >Date: 10-08-2003 23:44:25
> >Its n
Depends on who do you ask, provided you don't ask Anjo or Cary.
On 2003.08.12 06:44, Prem Khanna J wrote:
Jared,
LIO being high and BHCR ‾ 99% : is this is a normal or abnormal ?
Regards,
Jp.
12-08-2003 00:44:23, Jared Still <[EMAIL PROTECTED]> wrote:
>But his BCHR is 99.57% !
--
Please see th
Thanx a lot Tanel.
>select count(*) as cnt from profile where sex = ''j?«' and entpc
> = '192.168.15.1' and laccess between to_date('2003/08/08 00:00:
>00','/mm/dd hh24:mi:ss') and to_date('2003/08/08 23:59:59','
>/mm/dd hh24:mi:ss')
>Do you have index on "laccess" column for example?
Tho
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: Re: quick suggestions for tuning ?
Jared,
LIO being high and BHCR ~ 99% : is this is a normal or abnormal ?
Regards,
Jp.
12-08-2003 00:44:23, Jared Still <[EMAIL PROTE
sql.
Niall
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
> Behalf Of Prem Khanna J
> Sent: 12 August 2003 11:44
> To: Multiple recipients of list ORACLE-L
> Subject: Re: quick suggestions for tuning ?
>
>
> Jared,
>
> LIO
You poor guy. Try to bring some guy with you who can speak English and
Japanese to resolve ths communication problem. in 1993 when I was working in
Tokyo for 10 days in my ex-employer office and having problem with Harware,
the Japanese Engineer was brining one Bangadeshi guy to communicate wit
Jared,
LIO being high and BHCR ~ 99% : is this is a normal or abnormal ?
Regards,
Jp.
12-08-2003 00:44:23, Jared Still <[EMAIL PROTECTED]> wrote:
>But his BCHR is 99.57% !
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Prem Khanna J
INET: [EMAIL PROTECTED]
Fat
Thanx a lot Jared.
With due respect to all my GURUS on this list,
i start reading the docs AGAIN.
Thanx and Regards,
Jp.
13-08-2003 05:46:32, [EMAIL PROTECTED] wrote:
> From: [EMAIL PROTECTED]
> Date: Tue, 12 Aug 2003 13:46:32 -0700
> I would say that is often the norm.
> I would not say
00M) is small ?
>
> any good docs or links regarding LIO and how to deal
> with it ?
>
> Can u explain me Connor ?
>
> Regards,
> Jp.
>
>
> >From: Connor McDonald <[EMAIL PROTECTED]>
> >Subject: Fwd: Re: quick suggestions for tuning ?
> >Dat
bind vars.,LIO is a big issue here.
54 million consistent gets.
does it mean that db_cache_size (700M) is small ?
any good docs or links regarding LIO and how to deal with it ?
Can u explain me Connor ?
Regards,
Jp.
>From: Connor McDonald <[EMAIL PROTECTED]>
>Subject: Fwd: Re:
>Profile(sex,entpc,laccess) and profile(sex,entpc,faccess)
>Would appear to be called for. Obviousdly you will wish to analyze the
>schema, and even more obviously you will do all this in test first.
>If sex is a column that does not have many values (one would think no
>more than 8 or so) then y
JP,
"Since i'm working with a japanese client,communication is a huge
barrier and convincing them is a HERCULEAN task"
You poor guy. Try to bring some guy with you who can speak English and
Japanese to resolve ths communication problem. in 1993 when I was working in
Tokyo for 10 days in my ex-em
Litchfield [mailto:[EMAIL PROTECTED]
> Sent: 12 August 2003 22:27
> To: '[EMAIL PROTECTED]'
> Subject: RE: quick suggestions for tuning ?
>
>
> Probably normal. You are likely repeatedly, and excessively,
> reading the same blocks which are obviously cached after
>Jared,
>
>LIO being high and BHCR ~ 99% : is this is a normal
>or abnormal ?
>
>Regards,
>Jp.
>
>12-08-2003 00:44:23, Jared Still
><[EMAIL PROTECTED]> wrote:
>>But his BCHR is 99.57% !
>
>
OK, let's have another try at it. Let's say that you are a travelling salesman, with a
number of prospect
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 ?
>
Ah but then everything is fine ... Could we suggest buying a bigger machine :-) ?
>- --- Original Message --- -
>From: Jared Still <[EMAIL PROTECTED]>
>To: Multiple recipients of list ORACLE-L
><[EMAIL PROTECTED]>
>Sent: Mon, 11 Aug 2003 07:44:23
>
>
>But his BCHR is 99.57% !
>
>On
Its not really rocket science here...
CPU is at the top of the timed event - and what causes
CPU (or is the most common cause) - logical I/O. 54
million consistent gets later down in the report
probably a bit of a giveaway there :-)
Next section in the report is some nice queries that
use up 4 o
Yes, I agree.
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 12 Aug 2003 22:19:23 -0800
You poor guy. Try to bring some guy with you who can speak English and
Japanese to resolve ths communication problem. in 1993 when I was wor
?
Regards,
Jp.
>From: Connor McDonald <[EMAIL PROTECTED]>
>Subject: Fwd: Re: quick suggestions for tuning ?
>Date: 10-08-2003 23:44:25
>Its not really rocket science here...
>CPU is at the top of the timed event - and what causes
>CPU (or is the most common cause) - l
Thanks a lot Millsap,Stephane Faroult,Jared Still,Wolfgang,Tanel and Dennis for
your pointers and suggestions.
I owe a lot to you Oracle Gurus.
A novice DBA like me is ever grateful to this wonderful list.
I love this list.
Thanks once again.
Jp.
--
Please see the official ORACLE-L FAQ: htt
TECTED]>
>Subject: Fwd: Re: quick suggestions for tuning ?
>Date: 10-08-2003 23:44:25
>Its not really rocket science here...
>CPU is at the top of the timed event - and what causes
>CPU (or is the most common cause) - logical I/O. 54
>million consistent gets later down in the
But his BCHR is 99.57% !
On Sun, 2003-08-10 at 07:44, Connor McDonald wrote:
> Its not really rocket science here...
>
> CPU is at the top of the timed event - and what causes
> CPU (or is the most common cause) - logical I/O. 54
> million consistent gets later down in the report
> probably a b
25 matches
Mail list logo