ARXRWMAI problem
30-May-06 11:33 Arkiveret i:
issn
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,
|
11.5.10.2 fix for AR Autoinvoice when more than 20000 rows
26-May-06 10:12 Arkiveret i:
issn
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
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
Backup issue, locks etc.
09-May-06 15:32 Arkiveret i:
issn
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,
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,
Problem with diskspace on isspoa2
05-May-06 11:12 Arkiveret i:
issn
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)
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)
Cost Manager
04-May-06 15:32 Arkiveret i:
issn