on 03-24-2011 10:18 AM
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?
> 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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
> 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
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)
Hi,
could you paste the int<sid>.ora or spfile.ora
Mark
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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'
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.