Skip to Content
0
Former Member
Feb 10, 2015 at 11:44 AM

OXM_CBO_STATISTIC COLLECTOR job getting failed

21 Views

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