Hi Experts,
I am facing a problem *
the parameter SHARED_POOL_RESERVED_SIZE* value is Different In NODE A 102928220 and NODE B 51464110 memory.
The NODE A is Active.
We are using SAP Ecc5 with oracle 9i on window 2003.
What will be the effect of this parameter it is ok to have difference because I feel there is performance problem since I have change from Node B to nodeA active.
Please suggest What to do. If I have to change the parameter value pleases tell the steps for changing.
The details
SGA_MAX_SIZE 4129140808
SHARED_POOL_RESERVED_SIZE 102928220
SHARED_POOL_SIZE 520093696
SORT_AREA_SIZE 2097152
*ST02 Deatis*
SAP memory Current use
[%] [kB]
Roll area 9.69 25,402
Paging area 10.64 27,901
Extended Memory 36.54 1,835,008
Heap Memory 0
MAx
[kB]
Roll area 38,456
Paging area 60,224
Extended Memory 2,899,968
Heap Memory 0
In memory
[kB]
Roll area 262,144
Paging area 131,072
Extended Memory 5,021,696
On disk [kB]
0
Paging area 131,072
*ST04 Details*
Data buffer Elapsed since start (s) 19,325
Size KB 1,261,568
Quality % 89
Reads 92,315,389
Physical reads 10,043,519
writes 302,040
Buffer busy waits 239,555
Buffer wait time s 1,020
Shared Pool
Size kb 507,904
DD-Cache quality % 86.7
SQL Area getratio % 97.8
pinratio % 99.7
reloads/pins % 0.0004
Log buffer
Size kb 1,176
Entries 1,445,300
Allocation retries 48
Alloc fault rate % 0.0
Redo log wait s 8
Log files (in use) 8( 8)
*St06*
CPU
Utilization user % 69
system % 5
idle % 25
System calls/s 12,236
Interrupts/s 3,170
Count 2
Load average 1 min 2.84
5 min 1.62
15 min 1.68
Context switches/s 4,687
Swap
Commit charge limit Kb 48,492,768
Commit charge free Kb 31,126,272
Maximum swap-space Kb 41,943,040
Actual swap-space Kb 41,910,272
Memory
Physical mem avail Kb 8,376,136 Pages in/s 0
Pages out/s 1,411
Physical mem free Kb 1,301,472 Kb paged in/s 0
Kb paged out/s 11,288
Regards,