RE: Global Cache and Enqueue Services statistics
From: Hameed, Amir <Amir.Hameed_at_xerox.com>
Date: Tue, 31 Jul 2012 15:24:11 -0400
Message-ID: <304F58144267C5439E733532ABC9A3A1159954DC_at_USA0300MS02.na.xerox.net>
The testing people are preparing to run the 2nd run in the next few days. There were a few things that were not done properly during the first run which will be addressed in the next run. So, I will have a better idea after the next run about how well the environment will behave under RAC. After that I will see if we could run another run with CLUSTER_DATABASE set to FALSE.
> Thank you Tim and Gaja for your feedback. It is much appreciated.
> Here is some more information and the reasoning behind my mentioning
of
> FREELSITS and FREELIST GROUPS. Based on the top waits in the AWR
report,
> I queries DBA_HIST_ACTIVE_SESS_HISTORY and was able to identified
> statements that were waiting on these events. There are a total of
12-14
> statements that account for around 90-95% of these waits. These
> statements are SELECT FOR UPDATE, UPDATE, DELETE AND INSERT. These
> include two INSERT statements and one of them is parallelized with
over
> twenty sessions inserting into it in parallel. This was the primary
> reason for looking into FREELISTS and FREELIST GROUPS for a few tables
> that were involved in the INSERT statements. As I had mentioned in my
> previous note, this system was upgraded from 11.0.3 to 11.5.x several
> years ago and is therefore not configured with ASSM. Additionally, it
is
> my observation that prior to EBS 11i, Oracle did not have a standard
on
> defining FREELIST GROUPS on the base Oracle tables and most of the
> tables that I have looked at have these values set to 1. Starting with
> 11i fresh installs (installers prior to 11.5.10), tables started to
get
> created with FLG of 4; at least this is what I have observed. With
> 11.5.10.2 installers, Oracle uses ASSM.
Date: Tue, 31 Jul 2012 15:24:11 -0400
Message-ID: <304F58144267C5439E733532ABC9A3A1159954DC_at_USA0300MS02.na.xerox.net>
The testing people are preparing to run the 2nd run in the next few days. There were a few things that were not done properly during the first run which will be addressed in the next run. So, I will have a better idea after the next run about how well the environment will behave under RAC. After that I will see if we could run another run with CLUSTER_DATABASE set to FALSE.
Any idea why pings in AWR would report higher than pings with the OS ping command?
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Tim Gorman
Sent: Tuesday, July 31, 2012 2:28 PM
To: ORACLE-L
Subject: Re: Global Cache and Enqueue Services statistics
How did the load test do when you ran it from just one instance started with CLUSTER_DATABASE=FALSE?
On 7/31/2012 12:09 PM, Hameed, Amir wrote:
>
> Thank you Tim and Gaja for your feedback. It is much appreciated.
> Here is some more information and the reasoning behind my mentioning
of
> FREELSITS and FREELIST GROUPS. Based on the top waits in the AWR
report,
> I queries DBA_HIST_ACTIVE_SESS_HISTORY and was able to identified
> statements that were waiting on these events. There are a total of
12-14
> statements that account for around 90-95% of these waits. These
> statements are SELECT FOR UPDATE, UPDATE, DELETE AND INSERT. These
> include two INSERT statements and one of them is parallelized with
over
> twenty sessions inserting into it in parallel. This was the primary
> reason for looking into FREELISTS and FREELIST GROUPS for a few tables
> that were involved in the INSERT statements. As I had mentioned in my
> previous note, this system was upgraded from 11.0.3 to 11.5.x several
> years ago and is therefore not configured with ASSM. Additionally, it
is
> my observation that prior to EBS 11i, Oracle did not have a standard
on
> defining FREELIST GROUPS on the base Oracle tables and most of the
> tables that I have looked at have these values set to 1. Starting with
> 11i fresh installs (installers prior to 11.5.10), tables started to
get
> created with FLG of 4; at least this is what I have observed. With
> 11.5.10.2 installers, Oracle uses ASSM.
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Tue Jul 31 2012 - 14:24:11 CDT