Infor LN ERP Apps
Has anyone worked with InfoLN ERP software with Oracle as backened
We have a Sun Sparc t4-2 Rac one node database in ASM (H/W Mirrored). inforLN runs in a similiar machine
Solaris 10
oracle 11.2.0.3
Hw 120GB Mem
T4-2 Processors
Apps has 256 GB Memory.
I havent seen any application without a procedure,view,sequence ...It just has table and Index and Indexes are more than the no of columns...At times its reall y slow
Currently its running on AMM with 15 GB memory.. It was running on 60GB Memory but lot of complains about slowness and then i decided to reduce to 15 MEMORY_Target value...
The system hasnt gone live and we are testing different parameters
lot of I/O- We reduced the no of archivelogs by setting by a bigger redologs..
.UNDO'-RETENTION set to 47 hours as per the vendor advise.
Does anyone has come across this software and some kind of suggestions.....that i can work on.
Optimizer set to All_ rows but most of the query uses First_rows(n)
Insert stmt has hint with index
Any suggestions are welcome....
AWR report says lot of IO as its quite understandable cos lot of migration activity....