?
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) - logical I/O. 54
million consistent
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
quote
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
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
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 Sun,
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
[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 the
first read. I have a theory - lets call
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
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 prospects to visit at a
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 you
.,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: quick suggestions for tuning
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: quick suggestions for tuning
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
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
quote
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
.
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 being high and BHCR ~ 99% : is this is a normal
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 PROTECTED] wrote:
But his BCHR is 99.57% !
--
Please see the official
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?
Though
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 the
[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) - logical I/O. 54
million consistent gets later down in the report
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
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
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 with this ?
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:
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 bit of
]
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 report
probably a bit of a giveaway
25 matches
Mail list logo
