Hi Lawrence,Same situation here IFS APPS 8. Last successful message was 9th May 12:13 and failures thereafter on the 10th May.Our Live and Test machines exhibit the same failures:1:javax.net.ssl.SSLHandshakeException: Remote host closed connection during handshake We also implemented the java parameter last year for TLS 1.2.The only suspicious thing I can see so far is that HMRC renewed their certificate recently but I cant see how that would impact this process.
Thanks Alan I really appreciate your time on this, I’ll look to adding the indexes but I’ll have to liaise with IFS on changing the cursor in the package, I’ll let you know the results from both and if we continue to be impacted by the contention. Thanks again,Tom
Hi Alan, Once again thanks for your time.I’ve added a file of an extract of all indexes and all index columns I hope you will find this helpful. WORK_ORDER_CODING_UIV does contain a bit of site level user security within the view which I can understand why it would have an impact on the performance, sadly its being called within IFS’s logic so I can’t edit this myself, but I will raise this point with IFS.
Hi Alan,Thanks for the reply first and foremost, your explanation of of the latch buffer chains was very helpful.To answer your questions:What version of Oracle? Here’s our v$version:Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionPL/SQL Release 11.2.0.4.0 - Production"CORE 11.2.0.4.0 Production"TNS for Linux: Version 11.2.0.4.0 - ProductionNLSRTL Version 11.2.0.4.0 - ProductionCan you please provide a dump of your Oracle initialization parameters? I’ve attached our initialization parameters How much memory is installed on the server? 80GB available on the server, currently is using 52.8GB (middle of working day) Is this the only database on the server or are there multiple instances? Single instanceBased on the results from the SQLSTATS query the top query is the “Problem” statement that our 3rd party identified for us previously.BUFFER_GETS: 4157385699SELECT NVL(SUM(NVL(WOC.AMOUNT,0)), 0) TOTAL_AMOUNT FROM WORK_ORDER_CODING_UIV WOC, PURCHASE_REQ_LINE
Thank you both for your valuable feedback. However I was really hoping to get some discussion going from existing customers out there in the wilderness to discover any pros or cons to the paths that were taken. Anyone out there willing to share their experiences so far?
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.