R12.1.3 Payables: Invoice Validation program has performance issue

For the article "R12: AP: Invoice Validation program (APPRVL): Performance Issue - Insufficient Parameters" on My Oracle Support via document ID 2138625.1 you need to read up on the attached bug as well since it appears this dynamic query is actually being designed to run for an excessive amount of time if you do not provide an invoice date range.  That means that just entering an Operating Unit parameter does not actually limit the query as much as you would think, and Oracle Development has closed the bug as "not a bug" even though it really sounds like a bug!

R12.2.4 Payables: Payments form has performance issue

I have talked about XLA slowness in Payables before, but the My Oracle Support note "R12: AP: Performance Issue With Payments Form (APXPAWKB)" from article 2117534.1 has no hooks into XLA but still has a performance issue due to indexes that appear to be missing or incomplete on AP_INVOICES_ALL!

11gR2: Performance with NVL or NVL2 is slow

My Oracle Support article ID 2093132.1 for the document "Slow Performance With NVL or NVL2 Referencing PL/SQL Function Even When Ignoring the Function's Result" directs us not to an issue but to a basic fundamental part of PL/SQL that is certainly worth checking out!  Without looking at the document, can you guess why this is happening?

R12.1.3 Payables: Performance issue with Period Close

MOS article ID 1408983.1 for "Performance issue with the Payables Period Close" reports that this can take up to 30-45 minutes to run due to a combination of wrong table in the query and lack of index so make sure you check the version you have of the files for this and patch if needed!

Oracle Cloud: DaaS customers need to patch due to excessive I/O

Tonight we get an article from MOS entitled "ALERT: Customers with Database as a Service instances must apply a critical patch as soon as possible" from document ID 2068023.1 which is important because specific disk volumes can grow to 90%, prevent backups from running, and a negative I/O performance issue can occur!

R12.2.3 Procurement: No backend server available for connection error message due to performance issue

If you are on EBS R12.2.3 or planning on going to it, make sure you add into your testing suite the issue detailed in article "Performance When Searching Items To Receive In iProcurement: No Backend Server Available For Connection" which note ID 2054046.1 tells us is due to an incorrect index and what patches are available to resolve the issue.

ZFS Storage Appliance and Solaris can see write performance degradation when filesystem is almost full

Tonight MOS has a surprising article in store for us as "Solaris 10, Solaris 11 and ZFS Storage Appliance (ZFSSA) Software may Experience Write Performance Degradation when ZFS Filesystem is Near Quota" from note ID 1985528.1 as an entire pool can lose performance if the poolset comes within 2GB of being totally used!  You can also find out what commands are used to check this, and if you are affected then see what patchsets are available so you can get patched up to prevent this from happening to you.

Weekend Learning: Top 5 database/performance RAC issues

If you are running Oracle RAC, check out MOS note "Top 5 Database and/or Instance Performance Issues in RAC Environment" from document ID 1373500.1 to bone up on a few new things this weekend!

Weekend Learning: Data Pump and Oracle DB parameters to increase Data Pump performance

Tonight My Oracle Support article 1611373.1 "What DataPump And Oracle RDBMS Parameters Can Significantly Affect DataPump Performance ?" is a very straightforward listing of parameters which could teach you how to speed up Data Pump but also it can teach you about the Oracle DB as well by introducing you to some of these parameters maybe for the first time!

Weekend Learning: Collecting information to troubleshoot SQL performance problems

Have you ever run into a situation where SQL is not performing like it should?  We have a lot of tools now compared to "back in the day" (before Oracle Enterprise Manager) but some of the classics can be found in MOS article "SRDC - How to Collect Standard Information for a SQL Performance Problem" from note ID 1594386.1 and even if you do not need to work with Oracle to help solve the problem you can utilize these tools to diagnose and possibly resolve it!

"Latch free"/"Real-time plan statistics latch" wait events seen during slow system performance

Tonight provides us an opportunity to learn more about the SQL Monitor interface from MOS document "Slow Performance Featuring Contention on "latch free" with "Real-time plan statistics latch" Having the Most Sleeps and Causing High Operating System Activity" by searching for article ID 2030320.1 which will lead you not only to the Database SQL Tuning Guide if you were not already familiar with it, but ALSO the section detailing the Real-Time SQL Monitoring and Real-Time Database Operations.  Why would you be concerned with this?  Well, do you know how your system is setup to monitor SQL?  Would you like to AND feel comfortable that this feature will not cause you problems in the future?

Payables: Performance issue with purge routine

Even though you may be on R12 the article "Slow Performance When Running Payables Purge" on My Oracle Support deals with 11i, which can be found by document ID 2030741.1, and will remind you that there are purging routines for the Payables EBS module if you have not already set them up!

JDBC query with bind variables can have performance issue

It seems like I am on a performance kick after finding this note on My Oracle Support "Poor Performance With Query Called From JDBC Using Bind Variables Compared To A DATE Column" from document ID 1557194.1 which teaches us about the reasons a JDBC query might not use the best access path/plan based on what kind of DATE or TIMESTAMP variables you use.

Missing Indexes on Foreign Keys?

In the interest of better performance, you may want to check out My Oracle Support article "Script to check for Missing Indexes for Foreign Keys" from document ID 16428.1 and then run the attached script looking for ways to possibly improve your system performance!

Weekend Learning: Performance tuning PeopleSoft on Microsoft SQL Server

The article "Performance Tuning Advice For Microsoft SQL Server" on My Oracle Support found via note ID 2020083.1 does not say that it helps with PeopleSoft installations, but it links to several MSSQL documents including one specifically for PeopleSoft applications on MSSQL!

Weekend Learning: PeopleTools performance guidelines

If you have PeopleSoft and PeopleTools in your environment, then you should check out this 67 page "PeopleTools Performance Guidelines Red Paper" found on My Oracle Support from document ID 747389.1 in order to enhance your knowledge this weekend!

Weekend Learning: MySQL performance and antivirus issues

Usually I focus on the Oracle DB platform, but tonight I am branching out a bit by sharing with you several MySQL items so you can start adding to your toolbox for when you may need to support this technology:

Antivirus software, malware protection, firewalls, automated backups, and MySQL - Note ID 1451297.1
MySQL server performance vs. Windows background services - Note ID 1665946.1

Weekend Learning: 12c and SQL performance with In Database Row Archiving

This weekend make sure that you read the My Oracle Support document "Potential SQL Performance Degradation When Using "In Database Row Archiving"" from note ID 1579790.1 so that you are aware of a. how In Database Row Archiving works and b. how it affects SQL performance tuning.  Everybody wants to upgrade right?  Everybody wants to use the latest and greatest features right?  Find out what happens when you do both with 12c and In Database Row Archiving!

R12.1.3 Payables: Format Payment Instructions performance issue

Have you had any issues with the Format Payment Instructions report taking too long to run and maybe even erroring out after running too long?  If so, you probably want to check out MOS note "Performance Issue With "Format Payment Instructions"" from article ID 1966352.1 in order to find out what patch you need to apply so this issue can be avoided.

R12.1.3: Requisition Import slows down due to number of records processed

If you check out MOS article "Requisition Import(REQIMPORT) Process Slow performance issue" via note ID 1631101.1 you will find an interesting situation where this report will slow down if it has to process more than 3000 records!  It even is choking on a relatively simple UPDATE statement too!!  Not only am I going to see if we are suffering from this issue, but think about a way to get a handle on how well reports perform according to the volume of data it needs to process.