Low performances SYSTEM_CORE_DUMPED

[Former Member]

Hi,

we've SAP ECC 6.0 on Oracle 10.2.0.5 and MS Windows 2003 Server Ent Ed. x64 on MSCS Cluster.

We performed a kernel upgrade to the latest patch (278 for basis 700 sp 14) from a patch level 232.

C:\Documents and Settings\prdadm>disp+work

-

---

disp+work information

-

---

kernel release 700

kernel make variant 700_REL

compiled on NT 5.2 3790 Service Pack 2 x86 MS VC++ 14.00 for NTAMD64

compiled for 64 BIT

compilation mode UNICODE

compile time Oct 31 2010 22:37:06

update level 0

patch number 278

source id 0.278

-

---

supported environment

-

---

database (SAP, table SVERS) 700

operating system

Windows NT 5.0

Windows NT 5.1

Windows NT 5.2

Windows NT 6.0

Windows NT 6.1

Bundled to this action, our DBA has modified some oracle parameters getting this configuration:

########################################################################

1. This init.ora profile is a transparent copy of Oracle spfile. #

2. It was created by BRARCHIVE at 2011-04-20 12.00.05. #

3. Please do not change this file! Maintain only the spfile. #

4. You can use BRSPACE for the altering of database parameters: #

5. brspace -f dbparam #

########################################################################

*._first_spare_parameter=1

*._hash_join_enabled=FALSE

*.aq_tm_processes=0

*.background_dump_dest='D:\ORACLE\PRD\BACKGROUND'

*.compatible='10.2.0'

*.control_file_record_keep_time=30

*.control_files='F:\ORACLE\PRD\ORIGLOGA\CNTRL\CNTRLPRD.DBF','F:\ORACLE\PRD\ORIGLOGB\CNTRL\CNTRLPRD.DBF','F:\ORACLE\PRD\SAPDATA1\CNTRL\CNTRLPRD.DBF'

*.core_dump_dest='D:\ORACLE\PRD\BACKGROUND'

*.db_block_size=8192

*.db_cache_size=10116661248

PRD.db_file_multiblock_read_count=1

*.db_files=254

*.db_name='PRD'

*.db_writer_processes=6

*.filesystemio_options='setall'

*.log_archive_dest_1='LOCATION=F:\oracle\PRD\oraarch\PRDarch'

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

*.log_buffer=30483456

*.log_checkpoints_to_alert=TRUE

*.max_dump_file_size='20000'

*.open_cursors=800

PRD.optimizer_features_enable='10.2.0.4'

*.optimizer_index_cost_adj=20

*.parallel_execution_message_size=16384

*.parallel_max_servers=80

*.parallel_threads_per_cpu=1

*.pga_aggregate_target=6144000000

*.processes=210

*.query_rewrite_enabled='false'

*.recyclebin='off'

*.remote_login_passwordfile='EXCLUSIVE'

*.remote_os_authent=TRUE

*.replication_dependency_tracking=FALSE

*.resource_manager_plan=''

*.sessions=420

*.sga_max_size=20266876928

*.shared_pool_size=8103395328

*.star_transformation_enabled='true'

*.undo_management='AUTO'

*.undo_retention=900

*.undo_tablespace='PSAPUNDO'

*.user_dump_dest='D:\ORACLE\PRD\USERTRACE'

Since those operations, customers says the performances are very slow. In addition we have more SYSTEM_CORE_DUMPED

SAP (R) - R/3(TM) Callstack, Version 1.0

Copyright (C) SAP AG. All rights reserved.

Application exception occurred:

Exception : c0000005 (Access Violation)

App : disp+work.EXE (pid=2864)

When : 4/20/2011 6:9:32.788

Threads : 2

Computer Name : URANO

User Name : SAPServicePRD

Number of Processors: 8

Processor Type: EM64T Family 6 Model 23 Stepping 10

Windows Version : 5.2 Current Build: 3790

State Dump for Thread Id 10d8

FramePtr ReturnAd Param#1 Function Name

0000000008546bf0 000000000075947a 0000000008547ce0 disp+work!DiagoTabFocusColumn [diagoutp.c (2818

0000000008547c80 0000000000759b6e 0000000000000000 disp+work!DiagoSetFocus [diagoutp.c (2486)]

0000000008547d90 000000000075ae09 0000000000000001 disp+work!DiagoFocus [diagoutp.c (2773)]

0000000008548780 000000000075b517 0000000000000000 disp+work!diagoutput [diagoutp.c (903)]

00000000085488b0 000000000074ce3a 000007ffac490050 disp+work!diagmout [diagoutp.c (258)]

0000000008548ed0 0000000000640df7 ffffffffffffffff disp+work!diagmsgo [sapdiag.c (196)]

00000000085490c0 0000000000688180 000007df04ea78a0 disp+work!dytrcexit [dymain.c (2726)]

0000000008549150 000000000068defa 0000000000000000 disp+work!dynpoutf [dymainstp.c (4735)]

0000000008549200 0000000000645575 0000000000000000 disp+work!dynprctl [dymainstp.c (361)]

000000000854fc30 00000000004f729b 0000000000000002 disp+work!dynpen00 [dymain.c (1937)]

000000000854feb0 000000000043069b 0000000008638460 disp+work!TskhLoop [thxxhead.c (4652)]

000000000854fee0 000000000040108d ffffffff00000003 disp+work!DpMain [dpxxdisp.c (1166)]

000000000854ff10 0000000001a708c1 0000000000000000 disp+work!nlsui_main [thxxanf.c (84)]

000000000854ff70 0000000077d596ac 0000000000000000 disp+work!wmainCRTStartup [crtexe.c (498)]

000000000854ffa0 0000000000000000 0000000001a70750 kernel32!BaseProcessStart

State Dump for Thread Id df8

FramePtr ReturnAd Param#1 Function Name

000000000f62fe40 0000000077d5f6f1 0000000000000000 ntdll!NtFsControlFile

000000000f62feb0 00000000019537df fffffffffffffffe kernel32!ConnectNamedPipe

000000000f62ff40 000007ff7fc411c4 0000000000000000 disp+work!SigIMsgFunc [signt.c (679)]

000000000f62ff70 0000000077d6b71a 0000000077d6b6e0 msvcrt!endthreadex

000000000f62ffa0 0000000000000000 0000000000000000 kernel32!BaseThreadStart

Please, help me to find what's going wrong... if I have to change any oracle parameter, if i have made any mistake with the kernel upgrade... or if I have to change all my customers.... 😛

Kind Regards

[markus_doehr2 · Accepted solution]

The stack traces shows that the core is occuring in DiagoTabFocusColumn():

> 0000000008546bf0 000000000075947a 0000000008547ce0 disp+work!DiagoTabFocusColumn [diagoutp.c (2818

> 0000000008547c80 0000000000759b6e 0000000000000000 disp+work!DiagoSetFocus [diagoutp.c (2486)]

> 0000000008547d90 000000000075ae09 0000000000000001 disp+work!DiagoFocus [diagoutp.c (2773)]

> 0000000008548780 000000000075b517 0000000000000000 disp+work!diagoutput [diagoutp.c (903)]

> 00000000085488b0 000000000074ce3a 000007ffac490050 disp+work!diagmout [diagoutp.c (258)]

> 0000000008548ed0 0000000000640df7 ffffffffffffffff disp+work!diagmsgo [sapdiag.c (196)]

> 00000000085490c0 0000000000688180 000007df04ea78a0 disp+work!dytrcexit [dymain.c (2726)]

> 0000000008549150 000000000068defa 0000000000000000 disp+work!dynpoutf [dymainstp.c (4735)]

> 0000000008549200 0000000000645575 0000000000000000 disp+work!dynprctl [dymainstp.c (361)]

> 000000000854fc30 00000000004f729b 0000000000000002 disp+work!dynpen00 [dymain.c (1937)]

> 000000000854feb0 000000000043069b 0000000008638460 disp+work!TskhLoop [thxxhead.c (4652)]

> 000000000854fee0 000000000040108d ffffffff00000003 disp+work!DpMain [dpxxdisp.c (1166)]

> 000000000854ff10 0000000001a708c1 0000000000000000 disp+work!nlsui_main [thxxanf.c (84)]

> 000000000854ff70 0000000077d596ac 0000000000000000 disp+work!wmainCRTStartup [crtexe.c (498)]

> 000000000854ffa0 0000000000000000 0000000001a70750 kernel32!BaseProcessStart

The error is known:

Note 1525687 - Core dump in DiagoTabFocusColumn()

you need to update to at least kernel patchlevel 279.

Markus

[Former Member · Accepted solution]

Hi Markus,

thank you very much for your clear and quick reply!!!

Please, sorry if my question is very dummy, but i really can't find the 279 kernel patch on marketplace under

My Company's Application Components" Complimentary Software" SAP KERNEL 64-BIT UNICODE" SAP KERNEL 7.00 64-BIT UNICODE.

and the download link from the note, links me to the same marketplace page.

Could you please help me once again?

Kind regards

Massimo Solleretto

[markus_doehr2 · Accepted solution]

> Please, sorry if my question is very dummy, but i really can't find the 279 kernel patch on marketplace under

The note says at least kernel patch 279. On the service marketplace only the latest patch is available which is in this case Patch 297.

Markus

[Former Member · Accepted solution]

Hi Markus,

problem solved. I was looking for the 297 patch level complete kernel package, but the 297 patch level refers only to the disp+work package.

I've updated d+w and deleted and recreated oracle statistics.

Now the system works good (even if my customers still says it is slow on some standard transactions).

Thank you very much for your precius help.

Kind regards

Massimo Solleretto