OXM_CBO_STATISTIC COLLECTOR job getting failed

[Former Member]

Hello,

1.)  The job which is scheduled daily in our sap SRM - EHP 3 system running on Linux OS and oracle 11.2. is getting failed regularly and dumps.

What is the need for this job?

2.)  Also , we get a problem in the system when cust runs some queries in the 111 (prod) client - like getting too many dumps (memory related , ASSERTION_FAILED , TIME_OUT's...) and getting ora - 01555 errors regarding old snapshots (undo_retention) deletion time....We get to extend PSAPUNDO when such things happen.

Our undo_ret value is 43200 secs.

Should we increase it?

Undo_size in bytes -  

UNDO_SIZE

----------

6.4466E+10

UNDO_BLOCK_PER_SECOND

---------------------

364.346667

DB_BLOCK_SIZE

-------------

8192

[Former Member]

hi,

Please help me on this.!

Uday

[Sriram2009]

Hi Uday

Could you attach the full dump & Job log as text format.

BR

SS

[Former Member]

Hello SS,

please find the notepad attached with details for OXM job.

-------------------------------------

1.)  The job which is scheduled daily in our sap SRM - EHP 3 system running on Linux OS and oracle 11.2. is getting failed regularly and dumps.

What is the need for this job?

----------------------------------

111- OXM job.txt.zip

[Sriram2009]

Hi Uday

Could you refer the SCN thread

http://scn.sap.com/thread/3456694

BR

SS