Hi Hrishy

Thank you very much. I am pasting my Wait events details with memory status, can you please help me - the areas I have to look into and how. I will appreciate your time. ---- I am poor in tuning and learning....

Thanks again in advance.

=====================================================================
Memory:

Instance Efficiency Percentages (Target 100%)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Buffer Nowait %: 99.67 Redo NoWait %: 100.00
Buffer Hit %: 98.65 In-memory Sort %: 100.00
Library Hit %: 100.10 Soft Parse %: 99.85
Execute to Parse %: 98.12 Latch Hit %: 99.59
Parse CPU to Parse Elapsd %: % Non-Parse CPU:

Shared Pool Statistics Begin End
------ ------
Memory Usage %: 89.09 89.08
% SQL with executions>1: 36.88 39.68
% Memory for SQL w/exec>1: 19.72 21.81



SGA breakdown difference for DB: GENPROD Instance: genprod Snaps: 1035 -1036

Pool Name Begin value End value Difference
----------- ------------------------ -------------- -------------- -----------
java pool free memory 32,768 32,768 0
large pool free memory 614,400 614,400 0
shared pool Checkpoint queue 22,293,600 22,293,600 0
shared pool DML locks 816,480 816,480 0
shared pool KGFF heap 474,272 474,272 0
shared pool KGK heap 95,424 95,424 0
shared pool KQLS heap 2,613,704 3,445,512 831,808
shared pool PL/SQL DIANA 1,329,384 1,882,792 553,408
shared pool PL/SQL MPCODE 9,994,360 9,298,088 -696,272
shared pool PL/SQL SOURCE 8,392 8,392 0
shared pool PLS non-lib hp 2,136 2,136 0
shared pool PX msg pool 97,160 97,160 0
shared pool PX subheap 19,600 19,600 0
shared pool State objects 2,238,880 2,238,880 0
shared pool db_block_buffers 348,860,928 348,860,928 0
shared pool db_block_hash_buckets 56,685,584 56,685,584 0
shared pool db_handles 880,000 880,000 0
shared pool dictionary cache 6,926,656 7,125,904 199,248
shared pool errors 252,536 252,536 0
shared pool event statistics per ses 3,836,560 3,836,560 0
shared pool fixed allocation callbac 18,312 18,312 0
shared pool free memory 105,934,248 106,028,456 94,208
shared pool library cache 144,981,336 143,515,128 -1,466,208
shared pool miscellaneous 8,017,896 7,901,568 -116,328
shared pool processes 1,072,000 1,072,000 0
shared pool sessions 2,687,360 2,687,360 0
shared pool simulator trace entries 2,000,000 2,000,000 0
shared pool sql area 247,340,232 247,921,384 581,152
shared pool table columns 25,056 29,248 4,192
shared pool table definiti 6,304 9,672 3,368
shared pool transactions 1,846,800 1,846,800 0
shared pool trigger inform 1,296 1,880 584
db_block_buffers ############## ############## 0
fixed_sga 102,076 102,076 0
log_buffer 4,194,304 4,194,304 0

====================================================================
Wait Events:

Top 5 Wait Events
~~~~~~~~~~~~~~~~~ Wait % Total
Event Waits Time (cs) Wt Time
-------------------------------------------- ------------ ------------ -------
SQL*Net more data to client 7,529,071 0 .00
db file sequential read 6,392,464 0 .00
buffer busy waits 2,150,518 0 .00
latch free 296,948 0 .00
db file parallel write 240,094 0 .00
-------------------------------------------------------------
Wait Events for DB: GENPROD Instance: genprod Snaps: 1035 -1036
-> cs - centisecond - 100th of a second
-> ms - millisecond - 1000th of a second
-> ordered by wait time desc, waits desc (idle events last)

wait Waits
Event Waits Timeouts Time (cs) (ms) /txn
---------------------------- ------------ ---------- ----------- ------ ------
SQL*Net more data to client 7,529,071 0 0 0 170.1
db file sequential read 6,392,464 0 0 0 144.4
buffer busy waits 2,150,518 0 0 0 48.6
latch free 296,948 293,325 0 0 6.7
db file parallel write 240,094 0 0 0 5.4
db file scattered read 124,124 0 0 0 2.8
log file sequential read 64,036 0 0 0 1.4
log file parallel write 40,491 3 0 0 0.9
log file sync 32,073 0 0 0 0.7
control file sequential read 11,310 0 0 0 0.3
file open 6,773 0 0 0 0.2
direct path read 3,142 0 0 0 0.1
control file parallel write 1,170 0 0 0 0.0
LGWR wait for redo copy 858 26 0 0 0.0
direct path write 669 0 0 0 0.0
refresh controlfile command 306 0 0 0 0.0
enqueue 243 0 0 0 0.0
SQL*Net break/reset to clien 41 0 0 0 0.0
log file switch completion 17 0 0 0 0.0
file identify 8 0 0 0 0.0
log file single write 4 0 0 0 0.0
library cache load lock 3 0 0 0 0.0
single-task message 2 0 0 0 0.0
SQL*Net message from client 10,720,427 0 0 0 242.2
SQL*Net message to client 10,720,403 0 0 0 242.2
SQL*Net more data from clien 278,228 0 0 0 6.3
-------------------------------------------------------------
Background Wait Events for DB: GENPROD Instance: genprod Snaps: 1035 -1036
-> ordered by wait time desc, waits desc (idle events last)

Avg
Total Wait wait Waits
Event Waits Timeouts Time (cs) (ms) /txn
---------------------------- ------------ ---------- ----------- ------ ------
db file parallel write 240,097 0 0 0 5.4
log file sequential read 64,036 0 0 0 1.4
log file parallel write 40,488 3 0 0 0.9
latch free 34,759 34,758 0 0 0.8
file open 5,173 0 0 0 0.1
direct path read 3,142 0 0 0 0.1
control file parallel write 1,170 0 0 0 0.0
control file sequential read 1,082 0 0 0 0.0
LGWR wait for redo copy 858 26 0 0 0.0
direct path write 656 0 0 0 0.0
db file sequential read 9 0 0 0 0.0
file identify 8 0 0 0 0.0
log file single write 4 0 0 0 0.0
rdbms ipc message 345,957 2,608 0 0 7.8
pmon timer 1,176 1,176 0 0 0.0
smon timer 12 12 0 0 0.0