Oracle Database Discussions

i had recommendations from addmrpt from oracle support.please help to do step by step procedure steps

my envirom

prod-windows
two node rac
version10.2.0.4


recommendations are as follows

=== ODM Issue Verification ===

addmrpt_1_45161_45283.txt
--------------------------------------------

DETAILED ADDM REPORT FOR TASK 'TASK_107501' WITH ID 107501
----------------------------------------------------------

Analysis Period: from 19-JUN-2011 00:00 to 21-JUN-2011 13:00
Database ID/Instance: 107658090/1
Database/Instance Names: OSONDEMA/osondemand1
Host Name: INFO-IWW-COM-06
Database Version: 10.2.0.4.0
Snapshot Range: from 45161 to 45283
Database Time: 69659 seconds
Average Database Load: .3 active sessions

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


FINDING 1: 100% impact (221542 seconds)
---------------------------------------
Wait class "Cluster" was consuming significant database time.

NO RECOMMENDATIONS AVAILABLE

FINDING 2: 100% impact (69659 seconds)
--------------------------------------
Significant virtual memory paging was detected on the host operating system.

RECOMMENDATION 1: Host Configuration, 100% benefit (69659 seconds)
ACTION: Host operating system was experiencing significant paging but no
particular root cause could be detected. Investigate processes that
do not belong to this instance running on the host that are consuming
significant amount of virtual memory. Also consider adding more
physical memory to the host.

RECOMMENDATION 2: DB Configuration, 100% benefit (69659 seconds)
ACTION: Total PGA memory used was above the specified
"pga_aggregate_target" value for 29% of the time. Consider increasing
your current "pga_aggregate_target". Note that the sum of
"pga_aggregate_target" and SGA size should be less than the physical
memory available on the host.
RATIONALE: The value of parameter "pga_aggregate_target" was "5000 M"
during the analysis period.

FINDING 3: 45% impact (31322 seconds)
-------------------------------------
The SGA was inadequately sized, causing additional I/O or hard parses.

RECOMMENDATION 1: DB Configuration, 45% benefit (31322 seconds)
ACTION: Increase the size of the SGA by setting the parameter
"sga_target" to 8960 M.

ADDITIONAL INFORMATION:
The value of parameter "sga_target" was "5120 M" during the analysis
period.

SYMPTOMS THAT LED TO THE FINDING:
SYMPTOM: Wait class "User I/O" was consuming significant database time.
(35% impact [24184 seconds])



solution

Hi,

Addm report shows the OS memory utilization very high and Host operating system was experiencing significant paging.
The timeframe for the report is very large from 19-JUN-2011 00:00 to 21-JUN-2011 13:00
Windows 32 bit would have limitation to memory ..
Please use below metalink note to validate the memory configuration :
Windows Memory Configuration: 32-bit and 64-bit (Doc ID 873752.1)

my friend suggested solution as follows
Please find the observations as below:

1. Load balancing need to be done properly as report is showing the inadequate size of SGA for Node1 but not prominently for Node2
2. Need to monitor wait class of Global services and do the tuning as required.
3. Need to increase to SGA_TARGET after closing above two points and analysis the ADDM report and AWR report of later snap shots


please suggest me plan and steps to do above

thanks for reply