Skip to Content
0
Former Member
Oct 23, 2008 at 09:43 AM

facing problem with the parameter SHARED_POOL value is differ

253 Views

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,