Delfi Konsult

1. We have had a problem with ARXRWMAI for quite some time..... Finally today we managed to get a proper trace-file, which have been uploaded to Oracle Support, and it appears(we still need Oracle Support to confirm this) the culprit is enqueues, which is a Unix resource... weird that this problem only appears on HP-UX and not on Solaris..... running tkprof on the trace-file as: tkprof oa_prod_ora_7537_JAHI oa_prod_ora_7537_JAHI explain=apps/xxx sort=exeela,prsela,fchela showed the problem, see SR: https://metalink.oracle.com/metalink/plsql/f?p=200:37:4645549304284338632::::p_tar_num,p_ctryCode:5343244.993,

1. A problem has arised after upgrading to 11.5.10.2:
When running Ar autoinvoice, performance crawls to a halt due to a missing index, and statistics missing.
The following needs to be done:
1. Create a index on ra_interface_lines_all(trx_number)
2. Pl. submit AutoInvoice Master with "AI Gather Stats" profile option = Yes.
3. Also make sure that "AI message level" is set to 105

1. Finally lost my confidence in the fact that the CSC India part should get the backup problems fixed.. called Thmoas Nielsen in the Storage group,
and he also confirmed that the "policies" which were a direct copy from the old isspoa1 box would never work......
2. and locks! for users MATO and CAGU... we still have the issue with the ARXRWMAI form, which is causing a lot of headache!!!
see: https://metalink.oracle.com/metalink/plsql/f?p=200:37:7254277664734253071::::p_tar_num,p_ctryCode:5343244.993,

1. Had a Prio 1 problem: 100% on the primary disks for isspoa2; problem is partly that the backup of the RDBMS has not been since the upgrade, and as such all
archivelogs remains on the system, which led to the disk being 100% full...
2. Applied patch 4901634 to the OA_PROD(isstoa1) environment; and restarted the Apache server(issue with images not being generated)

1. problem with Cost Manager in the production environment....needs testing!
2. Installed patch 4345224 on OA_PROD(isstoa1) and OA_PROD(isspoa2)