Memory issue

[Former Member]

Hi All,

We are having frequent issues where the memory is being consumed fully.

We have 16 gb of ram.

================================================================================

== Checking profile: prd_DVEBMGS52_sapprd

================================================================================

***WARNING: Unexpected parameter: auth/auth_number_in_userbuffer =9000

***WARNING: Unexpected parameter: auth/test_mode =N

***WARNING: Unexpected parameter: system/type =ABAP

***ERROR: /dev/shm is too small (19264 MB required, 8008 MB configured)

***INFO: Temporary create ES2 resource /SAP_ES2_sappfpar_0 with 2047 MB

***INFO: Temporary create ES2 resource /SAP_ES2_sappfpar_1 with 2047 MB

***INFO: Temporary create ES2 resource /SAP_ES2_sappfpar_2 with 2047 MB

***INFO: Temporary create ES2 resource /SAP_ES2_sappfpar_3 with 2047 MB

***INFO: Temporary create ES2 resource /SAP_ES2_sappfpar_4 with 2047 MB

***INFO: Temporary create ES2 resource /SAP_ES2_sappfpar_5 with 2047 MB

***INFO: Temporary create ES2 resource /SAP_ES2_sappfpar_6 with 2047 MB

***INFO: Temporary create ES2 resource /SAP_ES2_sappfpar_7 with 2047 MB

***INFO: Temporary create ES2 resource /SAP_ES2_sappfpar_8 with 2047 MB

***INFO: Temporary create ES2 resource /SAP_ES2_sappfpar_9 with 841 MB

Shared memory disposition overview

================================================================

Shared memory pools

Key: 10 Pool

Size configured.....: 200000000 ( 190.7 MB)

Size min. estimated.: 128139520 ( 122.2 MB)

Advised Size........: 132000000 ( 125.9 MB)

Key: 40 Pool for database buffers

Size configured.....: 184000000 ( 175.5 MB)

Size min. estimated.: 178871040 ( 170.6 MB)

Advised Size........: 182000000 ( 173.6 MB)

Shared memories inside of pool 10

Key: 11 Size: 500000 ( 0.5 MB) Factory calender buffer

Key: 12 Size: 6000000 ( 5.7 MB) TemSe Char-Code convert Buf.

Key: 13 Size: 60500000 ( 57.7 MB) Alert Area

Key: 16 Size: 22400 ( 0.0 MB) Semaphore activity monitoring

Key: 17 Size: 11116480 ( 10.6 MB) Roll administration

Shared memories inside of pool 40

Key: 42 Size: 21312992 ( 20.3 MB) DB TTAB buffer

Key: 43 Size: 66774392 ( 63.7 MB) DB FTAB buffer

Key: 44 Size: 13526392 ( 12.9 MB) DB IREC buffer

Key: 45 Size: 8406392 ( 8.0 MB) DB short nametab buffer

Key: 46 Size: 20480 ( 0.0 MB) DB sync table

Key: 47 Size: 15361024 ( 14.6 MB) DB CUA buffer

Key: 48 Size: 500000 ( 0.5 MB) Number range buffer

Key: 49 Size: 2968344 ( 2.8 MB) Spool admin (SpoolWP+DiaWP)

Shared memories outside of pools

Key: 1 Size: 2500 ( 0.0 MB) System administration

Key: 2 Size: 60839260 ( 58.0 MB) Disp. administration tables

Key: 3 Size: 114048000 ( 108.8 MB) Disp. communication areas

Key: 4 Size: 542848 ( 0.5 MB) statistic area

Key: 6 Size: 638976000 ( 609.4 MB) ABAP program buffer

Key: 7 Size: 14838 ( 0.0 MB) Update task administration

Key: 8 Size: 268435556 ( 256.0 MB) Paging buffer

Key: 9 Size: 268435556 ( 256.0 MB) Roll buffer

Key: 14 Size: 20000000 ( 19.1 MB) Presentation buffer

Key: 18 Size: 3670116 ( 3.5 MB) Paging adminitration

Key: 19 Size: 150000000 ( 143.0 MB) Table-buffer

Key: 30 Size: 70656 ( 0.1 MB) Taskhandler runtime admin.

Key: 31 Size: 4806000 ( 4.6 MB) Dispatcher request queue

Key: 33 Size: 61440000 ( 58.6 MB) Table buffer, part.buffering

Key: 34 Size: 30720000 ( 29.3 MB) Enqueue table

Key: 41 Size: 25010000 ( 23.9 MB) DB statistics buffer

Key: 51 Size: 3200000 ( 3.1 MB) Extended memory admin.

Key: 52 Size: 40000 ( 0.0 MB) Message Server buffer

Key: 54 Size: 40968192 ( 39.1 MB) Export/Import buffer

Key: 55 Size: 8192 ( 0.0 MB) Spool local printer+joblist

Key: 57 Size: 1048576 ( 1.0 MB) Profilparameter in shared mem

Key: 58 Size: 4096 ( 0.0 MB) Enqueue ID for reset

Key: 62 Size: 85983232 ( 82.0 MB) Memory pipes

Key: 63 Size: 409600 ( 0.4 MB) ICMAN shared memory

Key: 64 Size: 4202496 ( 4.0 MB) Online Text Repository Buf.

Key: 65 Size: 4202496 ( 4.0 MB) Export/Import Shared Memory

Key: 76 Size: 1586464 ( 1.5 MB) ?????????????

Key: 77 Size: 518432 ( 0.5 MB) ?????????????

Key: 78 Size: 500256 ( 0.5 MB) ?????????????

Key: 1002 Size: 400000 ( 0.4 MB) Performance monitoring V01.0

Key: 58900152 Size: 4096 ( 0.0 MB) SCSA area

Nr of operating system shared memory segments: 33

Shared memory resource requirements estimated

================================================================

Total Nr of shared segments required.....: 33

System-imposed number of shared memories.: 1000

Shared memory segment size required min..: 638976000 ( 609.4 MB)

System-imposed maximum segment size......: 14025752576 (13376.0 MB)

Swap space requirements estimated

================================================

Shared memory....................: 2008.5 MB

..in pool 10 122.2 MB, 64% used

..in pool 40 170.6 MB, 97% used

..not in pool: 1707.2 MB

Processes........................: 897.9 MB

Extended Memory .................: 7788.0 MB

Extended Memory 2 ...............: 19264.0 MB

.. 70 VMs, 1048.0 MB address space

-

---

Total, minimum requirement.......: 29958.4 MB

Process local heaps, worst case..: 28610.2 MB

Total, worst case requirement....: 58568.7 MB

Errors detected..................: 0

Warnings detected................: 3

sapkxpsrmdb01:prdadm 4> free -m

total used free shared buffers cached

Mem: 16023 15474 548 0 174 11794

-/+ buffers/cache: 3505 12518

Swap: 21599 3717 17882

Oracle memory areas

SQL> show sga

Total System Global Area 4714397696 bytes

Fixed Size 2090240 bytes

Variable Size 2415921920 bytes

Database Buffers 2281701376 bytes

Redo Buffers 14684160 bytes

SQL> show parameter pga

NAME TYPE VALUE

-

---

-

---

-

---

pga_aggregate_target big integer 3407200911

SQL>

Why is that we are running out of memory even though we have enough RAM to accomodate oracle and SAP and linux OS requirements?

I wanted to know as what exactly the sappfpar reports? and PGA will be allocated on demand right?

[markus_doehr2]

> We are having frequent issues where the memory is being consumed fully.

What kind of "issues"? Linux always uses all available memory.

> ***ERROR: /dev/shm is too small (19264 MB required, 8008 MB configured)

what is you /etc/sysconfig/sapconf?

> Processes........................: 897.9 MB

> Extended Memory .................: 7788.0 MB

> Extended Memory 2 ...............: 19264.0 MB

> .. 70 VMs, 1048.0 MB address space

Is VMC activated? (vmcj/activate =1)

> -

---

> Total, minimum requirement.......: 29958.4 MB

So you configured the system to use 30 GB for ABAP.

> Why is that we are running out of memory even though we have enough RAM to accomodate oracle and SAP and linux OS requirements?

What error do you get and where do you get it?

Markus

[Former Member]

Hi Markus,

Thanks for the response.Hope you are doing good.Nice to hear from you.

I presume you are refrering to

sunrpc.tcp_slot_table_entries = 16

sunrpc.udp_slot_table_entries = 16

sunrpc.max_resvport = 1023

sunrpc.min_resvport = 665

sunrpc.nlm_debug = 0

sunrpc.nfsd_debug = 0

sunrpc.nfs_debug = 0

sunrpc.rpc_debug = 0

vxvm.vxinfo.volkio_commitwaitq = volkioq_commitwait_start count: 0

vxvm.vxinfo.volkio_commitwaitq = volkioq_commitwait_start:

vxvm.vxinfo.volkioqueue = volkioq_start count: 0

vxvm.vxinfo.volkioqueue = volkioq_start:

vxvm.vxinfo.volsio_otherq = volsioq_done count: 0

vxvm.vxinfo.volsio_otherq = volsioq_done:

vxvm.vxinfo.volsio_otherq = volsioq_restart count: 0

vxvm.vxinfo.volsio_otherq = volsioq_restart:

vxvm.vxinfo.volsio_otherq = volsioq_redone count: 0

vxvm.vxinfo.volsio_otherq = volsioq_redone:

vxvm.vxinfo.volsio_idleq = volsioq_idle_start count: 0

vxvm.vxinfo.volsio_idleq = volsioq_idle_start:

vxvm.vxinfo.volsioqueue = volsioq_start count: 0

vxvm.vxinfo.volsioqueue = volsioq_start:

vxvm.vxinfo.volktrans = vol_config_loaded: 1

vxvm.vxinfo.volktrans = vol_commit_in_progress: 0

vxvm.vxinfo.volktrans = vol_ktrans_locked: 0

vxvm.vxinfo.volktrans = vol_ktrans_pending_abort: 0

vxvm.vxinfo.volktrans = vol_ktrans_abort_is_possible: 0

vxvm.vxinfo.volktrans = transaction state: last transaction committed

vxvm.vxinfo.voliod_info = voliod_running: 0

vxvm.vxinfo.voliod_info = voliod_need: 0

vxvm.vxinfo.voliod_info = voliod_count: 32

vxvm.vxinfo.voliod_info = voliod_want_count: 32

vxvm.vxinfo.voliomem = memory reservation pool usage

vxvm.vxinfo.voliomem = id: max mem used: total allocated mem: mem in use: min mem: max mem

vxvm.vxinfo.voliomem = 0 0 100000 0 100000 8000000

vxvm.vxinfo.volkiocount_locked = volkiocount: 0

vxvm.vxinfo.volkiocount = volkiocount: 0

vxvm.vxio.vol_rp_decrement = 8

vxvm.vxio.vol_rp_increment = 8

vxvm.vxio.vol_use_rq = 1

vxvm.vxio.vol_use_rq = 1

vxvm.vxio.hacomm_logbuf_slots = 1000

vxvm.vxio.hacomm_transbuf_slots = 256

vxvm.vxio.hacomm_tracebuf_slots = 1024

vxvm.vxio.svm_session_trace_count = 2000

vxvm.vxio.svm_debugging_enable = 0

vxvm.vxio.vxvm_req_stack_endio = 3072

vxvm.vxio.vxvm_req_stack = 4096

vxvm.vxio.hacomm_min_winsz_enable_app = 2048

vxvm.vxio.hacomm_min_winsz_enable_peer = 2048

vxvm.vxio.hacomm_min_split_segsz = 1024

vxvm.vxio.hacomm_max_segsz = 1048576

vxvm.vxio.hacomm_min_split_fragsz = 2048

vxvm.vxio.hacomm_max_fragsz = 1048576

vxvm.vxio.hacomm_rcv_bufsz = 1048576

vxvm.vxio.hacomm_snd_bufsz = 1048576

vxvm.vxio.hacomm_msg_batching_ok = 1

vxvm.vxio.hacomm_direct_send_ok = 1

vxvm.vxio.hacomm_restore_interval = 60

vxvm.vxio.hacomm_hb_interval = 3

vxvm.vxio.hacomm_ack_interval = 200

vxvm.vxio.svm_txpt_type = 2

vxvm.vxio.voldrl_max_seq_dirty = 3

vxvm.vxio.vol_max_volumes = 65534

vxvm.vxio.vol_rvio_maxpool_sz = 134217728

vxvm.vxio.vol_vvr_use_nat = 0

vxvm.vxio.vol_max_wrspool_sz = 16777216

vxvm.vxio.vol_nm_hb_timeout = 10

vxvm.vxio.vol_dcm_replay_size = 262144

vxvm.vxio.volraid_minpool_size = 4194304

vxvm.vxio.volcvm_smartsync = 1

vxvm.vxio.vol_min_lowmem_sz = 4194304

vxvm.vxio.vol_max_nmpool_sz = 16777216

vxvm.vxio.vol_max_rdback_sz = 67108864

vxvm.vxio.volpagemod_max_memsz = 1536 0

vxvm.vxio.vol_fmr_logsz = 4

vxvm.vxio.voliomem_maxpool_sz = 134217728

vxvm.vxio.voliomem_chunk_size = 32768

vxvm.vxio.vol_max_nlogs = 20

vxvm.vxio.vol_max_nconfigs = 20

vxvm.vxio.vxtask_max_monitors = 32

vxvm.vxio.vxtask_max_monitors = 32

vxvm.vxio.vol_checkpt_default = 20480

vxvm.vxio.voliot_max_open = 32

vxvm.vxio.voliot_errbuf_dflt = 16384

vxvm.vxio.voliot_iobuf_default = 8192

vxvm.vxio.voliot_iobuf_max = 65536

vxvm.vxio.voliot_iobuf_limit = 131072

vxvm.vxio.vol_maxstablebufsize = 256

vxvm.vxio.vol_mvr_maxround = 512

vxvm.vxio.vol_maxparallelio = 256

vxvm.vxio.voldrl_max_drtregs = 2048

vxvm.vxio.voldrl_min_regionsz = 1024

vxvm.vxio.vol_default_iodelay = 50

vxvm.vxio.maxiosize = 2048

vxvm.vxio.vol_maxioctl = 32768

vxvm.vxio.vol_maxkiocount = 20000

vxdmp.dmp_retry_count = 5

vxdmp.dmp_restore_cycles = 10

vxdmp.dmp_restore_policy = 1

vxdmp.dmp_restore_interval = 300

vxdmp.dmp_pathswitch_blks_shift = 11

abi.vsyscall32 = 1

dev.scsi.logging_level = 0

dev.raid.speed_limit_max = 200000

dev.raid.speed_limit_min = 1000

dev.cdrom.check_media = 0

dev.cdrom.lock = 1

dev.cdrom.debug = 0

dev.cdrom.autoeject = 0

dev.cdrom.autoclose = 1

dev.cdrom.info = CD-ROM information, Id: cdrom.c 3.20 2003/12/17

dev.cdrom.info =

dev.cdrom.info = drive name: hda

dev.cdrom.info = drive speed: 24

dev.cdrom.info = drive # of slots: 1

dev.cdrom.info = Can close tray: 1

dev.cdrom.info = Can open tray: 1

dev.cdrom.info = Can lock tray: 1

dev.cdrom.info = Can change speed: 1

dev.cdrom.info = Can select disk: 0

dev.cdrom.info = Can read multisession: 1

dev.cdrom.info = Can read multisession: 1

dev.cdrom.info = Can read MCN: 1

dev.cdrom.info = Reports media changed: 1

dev.cdrom.info = Can play audio: 1

dev.cdrom.info = Can write CD-R: 0

dev.cdrom.info = Can write CD-RW: 0

dev.cdrom.info = Can read DVD: 1

dev.cdrom.info = Can write DVD-R: 0

dev.cdrom.info = Can write DVD-RAM: 0

dev.cdrom.info = Can read MRW: 1

dev.cdrom.info = Can write MRW: 1

dev.cdrom.info = Can write RAM: 1

dev.cdrom.info =

dev.cdrom.info =

dev.rtc.max-user-freq = 64

debug.exception-trace = 1

net.ipv6.conf.default.max_addresses = 16

net.ipv6.conf.default.max_desync_factor = 600

net.ipv6.conf.default.regen_max_retry = 5

net.ipv6.conf.default.temp_prefered_lft = 86400

net.ipv6.conf.default.temp_valid_lft = 604800

net.ipv6.conf.default.use_tempaddr = 0

net.ipv6.conf.default.force_mld_version = 0

net.ipv6.conf.default.router_solicitation_delay = 1

net.ipv6.conf.default.router_solicitation_interval = 4

net.ipv6.conf.default.router_solicitations = 3

net.ipv6.conf.default.dad_transmits = 1

net.ipv6.conf.default.autoconf = 1

net.ipv6.conf.default.accept_redirects = 1

net.ipv6.conf.default.accept_ra = 1

net.ipv6.conf.default.mtu = 1280

net.ipv6.conf.default.hop_limit = 64

net.ipv6.conf.default.forwarding = 0

net.ipv6.conf.all.max_addresses = 16

net.ipv6.conf.all.max_desync_factor = 600

net.ipv6.conf.all.regen_max_retry = 5

net.ipv6.conf.all.temp_prefered_lft = 86400

net.ipv6.conf.all.temp_valid_lft = 604800

net.ipv6.conf.all.use_tempaddr = 0

net.ipv6.conf.all.force_mld_version = 0

net.ipv6.conf.all.router_solicitation_delay = 1

net.ipv6.conf.all.router_solicitation_delay = 1

net.ipv6.conf.all.router_solicitation_interval = 4

net.ipv6.conf.all.router_solicitations = 3

net.ipv6.conf.all.dad_transmits = 1

net.ipv6.conf.all.autoconf = 1

net.ipv6.conf.all.accept_redirects = 1

net.ipv6.conf.all.accept_ra = 1

net.ipv6.conf.all.mtu = 1280

net.ipv6.conf.all.hop_limit = 64

net.ipv6.conf.all.forwarding = 0

net.ipv6.conf.bond0.max_addresses = 16

net.ipv6.conf.bond0.max_desync_factor = 600

net.ipv6.conf.bond0.regen_max_retry = 5

net.ipv6.conf.bond0.temp_prefered_lft = 86400

net.ipv6.conf.bond0.temp_valid_lft = 604800

net.ipv6.conf.bond0.use_tempaddr = 0

net.ipv6.conf.bond0.force_mld_version = 0

net.ipv6.conf.bond0.router_solicitation_delay = 1

net.ipv6.conf.bond0.router_solicitation_interval = 4

net.ipv6.conf.bond0.router_solicitations = 3

net.ipv6.conf.bond0.dad_transmits = 1

net.ipv6.conf.bond0.autoconf = 1

net.ipv6.conf.bond0.accept_redirects = 1

net.ipv6.conf.bond0.accept_ra = 1

net.ipv6.conf.bond0.mtu = 1500

net.ipv6.conf.bond0.hop_limit = 64

net.ipv6.conf.bond0.forwarding = 0

net.ipv6.conf.lo.max_addresses = 16

net.ipv6.conf.lo.max_desync_factor = 600

net.ipv6.conf.lo.regen_max_retry = 5

net.ipv6.conf.lo.temp_prefered_lft = 86400

net.ipv6.conf.lo.temp_valid_lft = 604800

net.ipv6.conf.lo.use_tempaddr = -1

net.ipv6.conf.lo.force_mld_version = 0

net.ipv6.conf.lo.router_solicitation_delay = 1

net.ipv6.conf.lo.router_solicitation_interval = 4

net.ipv6.conf.lo.router_solicitations = 3

net.ipv6.conf.lo.dad_transmits = 1

net.ipv6.conf.lo.autoconf = 1

net.ipv6.conf.lo.accept_redirects = 1

net.ipv6.conf.lo.accept_ra = 1

net.ipv6.conf.lo.accept_ra = 1

net.ipv6.conf.lo.mtu = 16436

net.ipv6.conf.lo.hop_limit = 64

net.ipv6.conf.lo.forwarding = 0

net.ipv6.neigh.bond0.locktime = 0

net.ipv6.neigh.bond0.proxy_delay = 79

net.ipv6.neigh.bond0.anycast_delay = 99

net.ipv6.neigh.bond0.proxy_qlen = 64

net.ipv6.neigh.bond0.unres_qlen = 3

net.ipv6.neigh.bond0.gc_stale_time = 60

net.ipv6.neigh.bond0.delay_first_probe_time = 5

net.ipv6.neigh.bond0.base_reachable_time = 30

net.ipv6.neigh.bond0.retrans_time = 1000

net.ipv6.neigh.bond0.app_solicit = 0

net.ipv6.neigh.bond0.ucast_solicit = 3

net.ipv6.neigh.bond0.mcast_solicit = 3

net.ipv6.neigh.lo.locktime = 0

net.ipv6.neigh.lo.proxy_delay = 79

net.ipv6.neigh.lo.anycast_delay = 99

net.ipv6.neigh.lo.proxy_qlen = 64

net.ipv6.neigh.lo.unres_qlen = 3

net.ipv6.neigh.lo.gc_stale_time = 60

net.ipv6.neigh.lo.delay_first_probe_time = 5

net.ipv6.neigh.lo.base_reachable_time = 30

net.ipv6.neigh.lo.retrans_time = 1000

net.ipv6.neigh.lo.app_solicit = 0

net.ipv6.neigh.lo.ucast_solicit = 3

net.ipv6.neigh.lo.mcast_solicit = 3

net.ipv6.neigh.default.gc_thresh3 = 1024

net.ipv6.neigh.default.gc_thresh2 = 512

net.ipv6.neigh.default.gc_thresh1 = 128

net.ipv6.neigh.default.gc_interval = 30

net.ipv6.neigh.default.locktime = 0

net.ipv6.neigh.default.proxy_delay = 79

net.ipv6.neigh.default.anycast_delay = 99

net.ipv6.neigh.default.proxy_qlen = 64

net.ipv6.neigh.default.unres_qlen = 3

net.ipv6.neigh.default.gc_stale_time = 60

net.ipv6.neigh.default.delay_first_probe_time = 5

net.ipv6.neigh.default.base_reachable_time = 30

net.ipv6.neigh.default.retrans_time = 1000

net.ipv6.neigh.default.retrans_time = 1000

net.ipv6.neigh.default.app_solicit = 0

net.ipv6.neigh.default.ucast_solicit = 3

net.ipv6.neigh.default.mcast_solicit = 3

net.ipv6.mld_max_msf = 10

net.ipv6.ip6frag_secret_interval = 600

net.ipv6.ip6frag_time = 60

net.ipv6.ip6frag_low_thresh = 196608

net.ipv6.ip6frag_high_thresh = 262144

net.ipv6.bindv6only = 0

net.ipv6.icmp.ratelimit = 1000

net.ipv6.route.min_adv_mss = 1

net.ipv6.route.mtu_expires = 600

net.ipv6.route.gc_elasticity = 0

net.ipv6.route.gc_interval = 30

net.ipv6.route.gc_timeout = 60

net.ipv6.route.gc_min_interval = 0

net.ipv6.route.max_size = 4096

net.ipv6.route.gc_thresh = 1024

net.unix.max_dgram_qlen = 10

net.token-ring.rif_timeout = 600000

net.ipv4.ip_conntrack_max = 65536

net.ipv4.netfilter.ip_conntrack_tcp_max_retrans = 3

net.ipv4.netfilter.ip_conntrack_tcp_be_liberal = 0

net.ipv4.netfilter.ip_conntrack_tcp_loose = 3

net.ipv4.netfilter.ip_conntrack_tcp_timeout_max_retrans = 300

net.ipv4.netfilter.ip_conntrack_log_invalid = 0

net.ipv4.netfilter.ip_conntrack_generic_timeout = 600

net.ipv4.netfilter.ip_conntrack_icmp_timeout = 30

net.ipv4.netfilter.ip_conntrack_udp_timeout_stream = 180

net.ipv4.netfilter.ip_conntrack_udp_timeout = 30

net.ipv4.netfilter.ip_conntrack_tcp_timeout_close = 10

net.ipv4.netfilter.ip_conntrack_tcp_timeout_time_wait = 120

net.ipv4.netfilter.ip_conntrack_tcp_timeout_last_ack = 30

net.ipv4.netfilter.ip_conntrack_tcp_timeout_close_wait = 60

net.ipv4.netfilter.ip_conntrack_tcp_timeout_fin_wait = 120

net.ipv4.netfilter.ip_conntrack_tcp_timeout_established = 432000

net.ipv4.netfilter.ip_conntrack_tcp_timeout_syn_recv = 60

net.ipv4.netfilter.ip_conntrack_tcp_timeout_syn_sent = 120

net.ipv4.netfilter.ip_conntrack_buckets = 8192

net.ipv4.netfilter.ip_conntrack_count = 223

net.ipv4.conf.eth1.force_igmp_version = 0

net.ipv4.conf.eth1.disable_policy = 0

net.ipv4.conf.eth1.disable_xfrm = 0

net.ipv4.conf.eth1.arp_ignore = 0

net.ipv4.conf.eth1.arp_announce = 0

net.ipv4.conf.eth1.arp_filter = 0

net.ipv4.conf.eth1.tag = 0

net.ipv4.conf.eth1.log_martians = 0

net.ipv4.conf.eth1.bootp_relay = 0

net.ipv4.conf.eth1.medium_id = 0

net.ipv4.conf.eth1.proxy_arp = 0

net.ipv4.conf.eth1.accept_source_route = 0

net.ipv4.conf.eth1.send_redirects = 0

net.ipv4.conf.eth1.rp_filter = 1

net.ipv4.conf.eth1.shared_media = 1

net.ipv4.conf.eth1.secure_redirects = 0

net.ipv4.conf.eth1.accept_redirects = 0

net.ipv4.conf.eth1.mc_forwarding = 0

net.ipv4.conf.eth1.forwarding = 0

net.ipv4.conf.eth0.force_igmp_version = 0

net.ipv4.conf.eth0.disable_policy = 0

net.ipv4.conf.eth0.disable_xfrm = 0

net.ipv4.conf.eth0.arp_ignore = 0

net.ipv4.conf.eth0.arp_announce = 0

net.ipv4.conf.eth0.arp_filter = 0

net.ipv4.conf.eth0.tag = 0

net.ipv4.conf.eth0.log_martians = 0

net.ipv4.conf.eth0.bootp_relay = 0

net.ipv4.conf.eth0.medium_id = 0

net.ipv4.conf.eth0.proxy_arp = 0

net.ipv4.conf.eth0.accept_source_route = 0

net.ipv4.conf.eth0.send_redirects = 0

net.ipv4.conf.eth0.rp_filter = 1

net.ipv4.conf.eth0.shared_media = 1

net.ipv4.conf.eth0.secure_redirects = 0

net.ipv4.conf.eth0.accept_redirects = 0

net.ipv4.conf.eth0.mc_forwarding = 0

net.ipv4.conf.eth0.forwarding = 0

[Former Member]

net.ipv4.conf.bond0.force_igmp_version = 0

net.ipv4.conf.bond0.disable_policy = 0

net.ipv4.conf.bond0.disable_xfrm = 0

net.ipv4.conf.bond0.arp_ignore = 0

net.ipv4.conf.bond0.arp_announce = 0

net.ipv4.conf.bond0.arp_filter = 0

net.ipv4.conf.bond0.tag = 0

net.ipv4.conf.bond0.log_martians = 0

net.ipv4.conf.bond0.bootp_relay = 0

net.ipv4.conf.bond0.medium_id = 0

net.ipv4.conf.bond0.proxy_arp = 0

net.ipv4.conf.bond0.accept_source_route = 0

net.ipv4.conf.bond0.send_redirects = 0

net.ipv4.conf.bond0.rp_filter = 1

net.ipv4.conf.bond0.shared_media = 1

net.ipv4.conf.bond0.secure_redirects = 0

net.ipv4.conf.bond0.accept_redirects = 0

net.ipv4.conf.bond0.mc_forwarding = 0

net.ipv4.conf.bond0.forwarding = 0

net.ipv4.conf.lo.force_igmp_version = 0

net.ipv4.conf.lo.disable_policy = 0

net.ipv4.conf.lo.disable_xfrm = 0

net.ipv4.conf.lo.arp_ignore = 0

net.ipv4.conf.lo.arp_announce = 0

net.ipv4.conf.lo.arp_filter = 0

net.ipv4.conf.lo.tag = 0

net.ipv4.conf.lo.log_martians = 0

net.ipv4.conf.lo.bootp_relay = 0

net.ipv4.conf.lo.medium_id = 0

net.ipv4.conf.lo.proxy_arp = 0

net.ipv4.conf.lo.accept_source_route = 0

net.ipv4.conf.lo.send_redirects = 0

net.ipv4.conf.lo.rp_filter = 1

net.ipv4.conf.lo.shared_media = 1

net.ipv4.conf.lo.secure_redirects = 0

net.ipv4.conf.lo.accept_redirects = 0

net.ipv4.conf.lo.mc_forwarding = 0

net.ipv4.conf.lo.forwarding = 0

net.ipv4.conf.default.force_igmp_version = 0

net.ipv4.conf.default.disable_policy = 0

net.ipv4.conf.default.disable_xfrm = 0

kernel.real-root-dev = 0

kernel.tainted = 3

kernel.core_pattern = core

kernel.core_uses_pid = 1

kernel.print-fatal-signals = 0

kernel.exec-shield-randomize = 1

kernel.exec-shield = 1

kernel.panic = 0

kernel.domainname = (none)

kernel.hostname = sapkxpsrmdb01

kernel.version = #1 SMP Mon Apr 19 06:19:00 EDT 2010

kernel.osrelease = 2.6.9-89.0.25.ELlargesmp

kernel.ostype = Linux

fs.nfs.nlm_tcpport = 4004

fs.nfs.nlm_udpport = 4004

fs.nfs.nlm_timeout = 10

fs.nfs.nlm_grace_period = 0

fs.mqueue.msgsize_max = 8192

fs.mqueue.msg_max = 10

fs.mqueue.queues_max = 256

fs.quota.syncs = 20

fs.quota.free_dquots = 0

fs.quota.allocated_dquots = 0

fs.quota.cache_hits = 0

fs.quota.writes = 0

fs.quota.reads = 0

fs.quota.drops = 0

fs.quota.lookups = 0

fs.aio-max-nr = 65536

fs.aio-nr = 29824

fs.lease-break-time = 45

fs.dir-notify-enable = 1

fs.leases-enable = 1

fs.overflowgid = 65534

fs.overflowuid = 65534

fs.dentry-state = 163695 146421 45 0 0 0

fs.file-max = 65536

fs.file-nr = 13440 0 65536

fs.inode-state = 200654 4901 0 0 0 0 0

fs.inode-nr = 200654 4901

fs.binfmt_misc.status = enabled

net.ipv4.neigh.bond0.delay_first_probe_time = 5

net.ipv4.neigh.bond0.base_reachable_time = 30

net.ipv4.neigh.bond0.retrans_time = 99

net.ipv4.neigh.bond0.app_solicit = 0

net.ipv4.neigh.bond0.ucast_solicit = 3

net.ipv4.neigh.bond0.mcast_solicit = 3

net.ipv4.neigh.lo.locktime = 99

net.ipv4.neigh.lo.proxy_delay = 79

net.ipv4.neigh.lo.anycast_delay = 99

net.ipv4.neigh.lo.proxy_qlen = 64

net.ipv4.neigh.lo.unres_qlen = 3

net.ipv4.neigh.lo.gc_stale_time = 60

net.ipv4.neigh.lo.delay_first_probe_time = 5

net.ipv4.neigh.lo.base_reachable_time = 30

net.ipv4.neigh.lo.retrans_time = 99

net.ipv4.neigh.lo.app_solicit = 0

net.ipv4.neigh.lo.ucast_solicit = 3

net.ipv4.neigh.lo.mcast_solicit = 3

net.ipv4.neigh.default.gc_thresh3 = 1024

net.ipv4.neigh.default.gc_thresh2 = 512

net.ipv4.neigh.default.gc_thresh1 = 128

net.ipv4.neigh.default.gc_interval = 30

net.ipv4.neigh.default.locktime = 99

net.ipv4.neigh.default.proxy_delay = 79

net.ipv4.neigh.default.anycast_delay = 99

net.ipv4.neigh.default.proxy_qlen = 64

net.ipv4.neigh.default.unres_qlen = 3

net.ipv4.neigh.default.gc_stale_time = 60

net.ipv4.neigh.default.delay_first_probe_time = 5

net.ipv4.neigh.default.base_reachable_time = 30

net.ipv4.neigh.default.retrans_time = 99

net.ipv4.neigh.default.app_solicit = 0

net.ipv4.neigh.default.ucast_solicit = 3

net.ipv4.neigh.default.mcast_solicit = 3

net.ipv4.tcp_slow_start_after_idle = 1

net.ipv4.tcp_workaround_signed_windows = 1

net.ipv4.tcp_bic_beta = 819

net.ipv4.tcp_tso_win_divisor = 8

net.ipv4.tcp_moderate_rcvbuf = 1

net.ipv4.tcp_bic_low_window = 14

net.ipv4.tcp_bic_fast_convergence = 1

net.ipv4.tcp_bic = 1

net.ipv4.tcp_vegas_gamma = 2

net.ipv4.tcp_vegas_beta = 6

net.ipv4.tcp_vegas_alpha = 2

net.ipv4.tcp_vegas_cong_avoid = 0

net.ipv4.tcp_westwood = 0

net.ipv4.tcp_no_metrics_save = 0

net.ipv4.ipfrag_secret_interval = 600

net.ipv4.tcp_low_latency = 0

net.ipv4.tcp_frto = 0

net.ipv4.tcp_tw_reuse = 0

net.ipv4.icmp_ratemask = 6168

net.ipv4.icmp_ratelimit = 1000

net.ipv4.tcp_adv_win_scale = 2

net.ipv4.tcp_app_win = 31

net.ipv4.tcp_rmem = 4096 87380 174760

net.ipv4.tcp_wmem = 4096 16384 131072

net.ipv4.tcp_mem = 786432 1048576 1572864

net.ipv4.tcp_dsack = 1

net.ipv4.tcp_ecn = 0

net.ipv4.tcp_reordering = 3

net.ipv4.tcp_fack = 1

net.ipv4.tcp_orphan_retries = 0

net.ipv4.inet_peer_gc_maxtime = 120

net.ipv4.inet_peer_gc_mintime = 10

net.ipv4.inet_peer_maxttl = 600

net.ipv4.inet_peer_minttl = 120

net.ipv4.inet_peer_threshold = 65664

net.ipv4.igmp_max_msf = 10

net.ipv4.igmp_max_memberships = 20

net.ipv4.route.secret_interval = 600

net.ipv4.route.min_adv_mss = 256

net.ipv4.route.min_pmtu = 552

net.ipv4.route.mtu_expires = 600

net.ipv4.route.gc_elasticity = 8

net.ipv4.route.error_burst = 5000

net.ipv4.route.error_cost = 1000

net.ipv4.route.redirect_silence = 20480

net.ipv4.route.redirect_number = 9

net.ipv4.route.redirect_load = 20

net.ipv4.route.gc_interval = 60

net.ipv4.route.gc_timeout = 300

net.ipv4.route.gc_min_interval = 0

net.ipv4.route.max_size = 8388608

net.ipv4.route.gc_thresh = 524288

net.ipv4.route.max_delay = 10

net.ipv4.route.min_delay = 2

net.ipv4.icmp_errors_use_inbound_ifaddr = 0

net.ipv4.icmp_ignore_bogus_error_responses = 0

net.ipv4.icmp_echo_ignore_broadcasts = 1

net.ipv4.icmp_echo_ignore_all = 0

net.ipv4.ip_local_port_range = 1024 65000

net.ipv4.tcp_max_syn_backlog = 4096

net.ipv4.tcp_rfc1337 = 0

net.ipv4.tcp_stdurg = 0

net.ipv4.tcp_abort_on_overflow = 0

net.ipv4.tcp_tw_recycle = 0

net.ipv4.tcp_syncookies = 1

net.ipv4.tcp_fin_timeout = 60

net.ipv4.tcp_retries2 = 15

net.ipv4.tcp_retries1 = 3

net.ipv4.tcp_keepalive_intvl = 75

net.ipv4.tcp_keepalive_probes = 9

net.ipv4.tcp_keepalive_time = 7200

net.ipv4.ipfrag_time = 30

net.ipv4.ip_dynaddr = 0

net.ipv4.ipfrag_low_thresh = 196608

net.ipv4.ipfrag_high_thresh = 262144

net.ipv4.tcp_max_tw_buckets = 180000

net.ipv4.tcp_max_orphans = 262144

net.ipv4.tcp_synack_retries = 5

net.ipv4.tcp_syn_retries = 5

net.ipv4.ip_nonlocal_bind = 0

net.ipv4.ip_no_pmtu_disc = 0

net.ipv4.ip_autoconfig = 0

net.ipv4.ip_default_ttl = 64

net.ipv4.ip_forward = 0

net.ipv4.tcp_retrans_collapse = 1

net.ipv4.tcp_sack = 1

net.ipv4.tcp_window_scaling = 1

net.ipv4.tcp_timestamps = 1

net.core.somaxconn = 128

net.core.divert_version = 0.46

net.core.optmem_max = 20480

net.core.message_burst = 10

net.core.message_cost = 5

net.core.mod_cong = 290

net.core.lo_cong = 100

net.core.no_cong = 20

net.core.no_cong_thresh = 10

net.core.netdev_max_backlog = 300

net.core.dev_weight = 64

net.core.rmem_default = 262144

net.core.wmem_default = 262144

net.core.rmem_max = 262144

net.core.wmem_max = 262144

vm.mmap_min_addr = 0

vm.max_writeback_pages = 1024

vm.swap_token_timeout = 300

vm.write-mapped = 1

vm.drop_caches = 0

vm.inactive_percent = 0

vm.pagecache = 100

vm.percpu_pagelist_fraction = 0

vm.max_queue_depth = 0

vm.oom-kill = 1

vm.legacy_va_layout = 0

vm.vfs_cache_pressure = 100

vm.block_dump = 0

vm.laptop_mode = 0

vm.max_map_count = 300000

vm.min_free_kbytes = 16370

vm.lower_zone_protection = 0

vm.hugetlb_shm_group = 0

vm.nr_hugepages = 0

vm.swappiness = 60

vm.nr_pdflush_threads = 2

vm.dirty_expire_centisecs = 3000

vm.dirty_writeback_centisecs = 500

vm.dirty_ratio = 40

vm.dirty_background_ratio = 10

vm.page-cluster = 3

vm.overcommit_ratio = 50

vm.panic_on_oom = 0

vm.overcommit_memory = 0

kernel.panic_on_unrecovered_nmi = 0

kernel.wake_balance = 1

kernel.suid_dumpable = 0

kernel.unknown_nmi_panic = 0

kernel.ngroups_max = 65536

kernel.printk_ratelimit_burst = 10

kernel.printk_ratelimit = 5

kernel.panic_on_oops = 1

kernel.pid_max = 32768

kernel.sercons_esc = -1

kernel.overflowgid = 65534

kernel.overflowuid = 65534

kernel.pty.nr = 1

kernel.pty.max = 4096

kernel.random.uuid = 88670ef1-d1b4-4252-a1a1-153f7f5f52e6

kernel.random.boot_id = 41a6ce3d-bb09-468e-9639-1f9f79ccaf55

kernel.random.write_wakeup_threshold = 128

kernel.random.read_wakeup_threshold = 64

kernel.random.entropy_avail = 3584

kernel.random.poolsize = 512

kernel.threads-max = 294912

kernel.sysrq = 0

kernel.sem = 1250 256000 100 1024

kernel.msgmnb = 16384

kernel.msgmni = 1024

kernel.msgmax = 8192

kernel.shmmni = 4096

kernel.shmall = 5242880

kernel.shmmax = 23136829430

kernel.acct = 4 2 30

kernel.hotplug = /sbin/vxhotplug

kernel.modprobe = /sbin/modprobe

kernel.printk = 6 4 1 7

kernel.ctrl-alt-del = 0

kernel.real-root-dev = 0

kernel.tainted = 3

kernel.core_pattern = core

kernel.core_uses_pid = 1

kernel.print-fatal-signals = 0

kernel.exec-shield-randomize = 1

kernel.exec-shield = 1

kernel.panic = 0

kernel.domainname = (none)

kernel.hostname = sapkxpsrmdb01

[Former Member]

Hi mark,

There is no file /etc/sysconfig/sapconf.

I pasted the output of /sbin/sysctl -a | more

Please let me know in case i am looking into the wrong file.

[Former Member]

HI markus,

Whats the significance of /dev/shm?Linux does require lot of memory but do you think there is a need for tuning the system.Thanks.

[Former Member]

Hi markus,

Regarding vmc

DEFAULT.PFL:vmcj/option/ps = 768M

DEFAULT.PFL:vmcj/option/maxJavaHeap = 200M

DEFAULT.PFL:vmcj/enable = on

These are the parameters available.Thanks.

[Former Member]

The frequent issues are like hanging of the system we cannot stop the system whenever there is full utlisation of the memory.

[markus_doehr2]

First a few other questions:

What Linux distribution do you use? Is this Redhat?

Are you using Veritas filesystem and/or VxVM?

Markus

[Former Member]

Hi Markus,

This is Red hat

sapkxpsrmdb01:pb0adm 35> uname -a

Linux sapkxpsrmdb01 2.6.9-89.0.25.ELlargesmp #1 SMP Mon Apr 19 06:19:00 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux

Regarding veritas file system i presume you are referring to VCS cluster.We dont have a cluster.Pasted below the file system layout.Markus by the looks does this look like VxVM .

Filesystem Size Used Avail Use% Mounted on

/dev/mapper/sysvg-root

6.8G 3.4G 3.1G 53% /

tmpfs 4.0K 0 4.0K 0% /dev/vx

/dev/sda1 190M 33M 148M 19% /boot

none 7.9G 1019M 6.9G 13% /dev/shm

/dev/mapper/sysvg-home

7.7G 108M 7.2G 2% /home

/dev/mapper/sysvg-opt

20G 4.5G 14G 25% /opt

/dev/mapper/sysvg-var

9.6G 432M 8.7G 5% /var

/dev/mapper/sysvg-crash

45G 999M 41G 3% /var/crash

tmpfs 2.0G 4.0K 2.0G 1% /tmp

/opt/local 20G 4.5G 14G 25% /usr/local

/opt/openv 20G 4.5G 14G 25% /usr/openv

/dev/vx/dsk/localdg/oracle

10G 2.8G 6.9G 29% /oracle

/dev/vx/dsk/localdg/pb0

10G 2.8G 6.9G 29% /oracle/PB0

/dev/vx/dsk/localdg/pb0sapreorg

20G 249M 19G 2% /oracle/PB0/sapreorg

/dev/vx/dsk/localdg/saparchive

5.0G 19M 4.7G 1% /saparchive

/dev/vx/dsk/localdg/pb0_logAo

1.0G 540M 455M 55% /oracle/PB0/origlogA

/dev/vx/dsk/localdg/pb0_logBo

1.0G 540M 455M 55% /oracle/PB0/origlogB

/dev/vx/dsk/localdg/pb0_logAm

1.0G 518M 475M 53% /oracle/PB0/mirrlogA

/dev/vx/dsk/localdg/pb0_logBm

1.0G 518M 475M 53% /oracle/PB0/mirrlogB

/dev/vx/dsk/localdg/sapmnt

5.0G 1.9G 3.0G 39% /sapmnt

/dev/vx/dsk/localdg/usr_sap

57G 18G 38G 32% /usr/sap

/dev/vx/dsk/sapsrmdg/pb0_data

636G 259G 354G 43% /oracle/PB0/data

/dev/vx/dsk/sapsrmdg/pb0_oraarch

20G 4.9G 15G 26% /oracle/PB0/oraarch

[markus_doehr2]

> We dont have a cluster.Pasted below the file system layout.Markus by the looks does this look like VxVM .

Yes, it seems you're using veritas filesystem (check by issuing 'mount').

> none 7.9G 1019M 6.9G 13% /dev/shm

So this seems to be the culprit.

Your profile configuration doesn't match the system configuration. The system tries to allocate more memory on start than there is available. Once the physical memory is reached you swap out to the filesystem which almost stalls the system.

I suggest you go through

Note 941735 - SAP memory management for 64-bit Linux systems

and adapt the profile and/or the system parameters.

Markus

[Former Member]

HI Markus,

One question can you please throw some light as to how the /dev/shm is used in the system.Thanks.

[Former Member]

Hi Markus,

You are simply too good.Thanks for the reply.

Pasted below the output of mount command.

/dev/mapper/sysvg-root on / type ext3 (rw)

none on /proc type proc (rw)

none on /sys type sysfs (rw)

none on /dev/pts type devpts (rw,gid=5,mode=620)

usbfs on /proc/bus/usb type usbfs (rw)

tmpfs on /dev/vx type tmpfs (rw,size=4k,nr_inodes=2097152,mode=0755)

/dev/sda1 on /boot type ext3 (rw)

none on /dev/shm type tmpfs (rw)

/dev/mapper/sysvg-home on /home type ext3 (rw)

/dev/mapper/sysvg-opt on /opt type ext3 (rw)

/dev/mapper/sysvg-var on /var type ext3 (rw)

/dev/mapper/sysvg-crash on /var/crash type ext3 (rw)

tmpfs on /tmp type tmpfs (rw,size=2g)

/opt/local on /usr/local type none (rw,bind)

/opt/openv on /usr/openv type none (rw,bind)

/dev/vx/dsk/localdg/oracle on /oracle type vxfs (rw,delaylog,largefiles,ioerror= mwdisable)

/dev/vx/dsk/localdg/pb0 on /oracle/PB0 type vxfs (rw,delaylog,largefiles,ioerror =mwdisable)

/dev/vx/dsk/localdg/pb0sapreorg on /oracle/PB0/sapreorg type vxfs (rw,delaylog,l argefiles,ioerror=mwdisable)

/dev/vx/dsk/localdg/saparchive on /saparchive type vxfs (rw,delaylog,largefiles, ioerror=mwdisable)

/dev/vx/dsk/localdg/pb0_logAo on /oracle/PB0/origlogA type vxfs (rw,delaylog,lar gefiles,ioerror=mwdisable)

/dev/vx/dsk/localdg/pb0_logBo on /oracle/PB0/origlogB type vxfs (rw,delaylog,lar gefiles,ioerror=mwdisable)

/dev/vx/dsk/localdg/pb0_logAm on /oracle/PB0/mirrlogA type vxfs (rw,delaylog,lar gefiles,ioerror=mwdisable)

/dev/vx/dsk/localdg/pb0_logBm on /oracle/PB0/mirrlogB type vxfs (rw,delaylog,lar gefiles,ioerror=mwdisable)

/dev/vx/dsk/localdg/sapmnt on /sapmnt type vxfs (rw,delaylog,largefiles,ioerror= mwdisable)

/dev/vx/dsk/localdg/usr_sap on /usr/sap type vxfs (rw,delaylog,largefiles,ioerro r=mwdisable)

/dev/vx/dsk/sapsrmdg/pb0_data on /oracle/PB0/data type vxfs (rw,delaylog,largefi les,ioerror=mwdisable)

/dev/vx/dsk/sapsrmdg/pb0_oraarch on /oracle/PB0/oraarch type vxfs (rw,delaylog,l argefiles,ioerror=mwdisable)

none on /proc/sys/fs/binfmt_misc type binfmt_misc (rw)

sunrpc on /var/lib/nfs/rpc_pipefs type rpc_pipefs (rw)

sapsepp:/interface on /interface type nfs (rw,soft,intr,addr=10.13.129.36)

nfsd on /proc/fs/nfsd type nfsd (rw)

[Former Member]

Hi,

could you paste the int<sid>.ora or spfile.ora

Mark

[Former Member]

HI Mark,

SpFILe

*._b_tree_bitmap_plans=FALSE

*._cursor_features_enabled=10

*._first_spare_parameter=1

*._fix_control='5099019:ON','5705630:ON','5765456:3','6221403:ON','6329318:ON','6399597:ON','6430500:ON','6440977:ON','662601

8:ON','6670551:ON','6972291:ON','7325597:ON','7692248:ON','7891471:ON'

*._OPTIM_PEEK_USER_BINDS=FALSE

*._optimizer_better_inlist_costing='OFF'

*._optimizer_mjc_enabled=FALSE

*._sort_elimination_cost_ratio=10

*.audit_sys_operations=TRUE

*.audit_trail='TRUE'

*.background_dump_dest='/oracle/PB0/saptrace/background'

*.compatible='10.2.0'

*.control_file_record_keep_time=30

*.control_files='/oracle/PB0/origlogA/cntrl/cntrlPB0.dbf','/oracle/PB0/origlogB/cntrl/cntrlPB0.dbf','/oracle/PB0/sapdata1/cnt

rl/cntrlPB0.dbf'

*.core_dump_dest='/oracle/PB0/saptrace/background'

*.db_block_size=8192

*.db_cache_size=2272002048

*.db_files=254

*.db_name='PB0'

*.event='10027 trace name context forever, level 1','10028 trace name context forever, level 1','10142 trace name context for

ever, level 1','10183 trace name context forever, level 1','10191 trace name context forever, level 1','10411 trace name cont

ext forever, level 1','10629 trace name context forever, level 32','10753 trace name context forever, level 2','14532 trace n

ame context forever, level 1','38068 trace name context forever, level 100','38085 trace name context forever, level 1','3808

7 trace name context forever, level 1','44951 trace name context forever, level 1024'

*.FILESYSTEMIO_OPTIONS='setall'

*.large_pool_size=8388608

*.log_archive_dest_1='LOCATION=/oracle/PB0/oraarch/PB0arch'

*.log_archive_format='%t_%s_%r.dbf'

*.log_buffer=1048576

*.log_checkpoints_to_alert=true

*.max_dump_file_size='20000'

*.nls_length_semantics='BYTE'

*.open_cursors=800

*.optimizer_dynamic_sampling=6

*.optimizer_index_cost_adj=20

*.parallel_execution_message_size=16384

ame context forever, level 1','38068 trace name context forever, level 100','38085 trace name context forever, level 1','3808

7 trace name context forever, level 1','44951 trace name context forever, level 1024'

*.FILESYSTEMIO_OPTIONS='setall'

*.large_pool_size=8388608

*.log_archive_dest_1='LOCATION=/oracle/PB0/oraarch/PB0arch'

*.log_archive_format='%t_%s_%r.dbf'

*.log_buffer=1048576

*.log_checkpoints_to_alert=true

*.max_dump_file_size='20000'

*.nls_length_semantics='BYTE'

*.open_cursors=800

*.optimizer_dynamic_sampling=6

*.optimizer_index_cost_adj=20

*.parallel_execution_message_size=16384

*.parallel_max_servers=40

*.parallel_threads_per_cpu=1

*.pga_aggregate_target=3407200911

*.processes=250

*.query_rewrite_enabled='FALSE'

*.recyclebin='off'

*.remote_os_authent=true

*.replication_dependency_tracking=FALSE

*.sessions=640

*.shared_pool_size=2272002048

*.star_transformation_enabled='TRUE'

*.undo_management='AUTO'

*.undo_retention=900

*.undo_tablespace='PSAPUNDO'

*.user_dump_dest='/oracle/PB0/saptrace/usertrace'

[Former Member]

Hi,

*.shared_pool_size=2272002048

2.2GB is huge unless there is an Oracle requirement on LINUX.

you can scale this right back by at least 1.6GB.

Tho I am running AIX 5.3 so I would check first via SMP notes.

Mark