By Gary Piper on
5/14/2012 8:19 PM
Here we go again! After having written and blogged about this topic a fair bit in the past, having too many managers is a problem I still continue to see all too often. A good example is a site I worked with recently; it had 20+ managers just to run the workflow background processes.
Putting aside the need to address the excessive workflow background processes (which is another problem in its own right) there are major...
|
By Gary Piper on
3/12/2012 11:03 AM
Scheduled requests are one of the mainstays of OEBS concurrent processing.
One of the benefits of recurring scheduled requests is they are “set and forget” they just happily run and resubmit without you having to do a thing.
The biggest issue I’ve found, and this applies to almost all sites, is the “forget” component. I regularly find scheduled requests that have been running for years that are no longer required, and also duplicate scheduled requests which have come about because someone doesn’t know the original request exists. Both these issues are a waste of processing resources. ...
|
By Gary Piper on
2/2/2012 4:44 PM
I have seen examples of sites with over 50 million rows in the fnd_concurrent_requests_u1 index; a huge waste of space! More importantly however is the problem of poor performance in such a core OEBS activity.
|
By Gary Piper on
12/8/2011 2:46 PM
Not known at this address...
|
By Gary Piper on
11/19/2011 1:58 PM
The case of the missing workflow e-mail addresses
|
By Gary Piper on
8/23/2011 8:28 PM
Step by step instructions for creating a dual scale bar and line TOAD Report Manager chart
|
By Gary Piper on
2/28/2011 4:43 PM
Step by step instructions for adding a simple yes / no dialog box to the beginning of a report
|
By Gary Piper on
1/18/2011 1:32 PM
Index maintenance is all too often overlooked and can, over time, have a serious impact on performance. Ever growing indexes account for large amounts of wasted space and failing to perform regular index rebuilds on dynamic application tables is just throwing away performance.
In this paper I will provide a simple list of indexes to start with, and a method of identifying if any of these indexes should be rebuilt (TOAD report). I also cover why you should exercise caution when using an auto index rebuild script you find on the web, some do not readily translate to an OEBS environment
|
By Gary Piper on
11/18/2010 7:00 PM
All too often I see sites with far too many concurrent manager processes and the site wonders why they have intermittent performance issues. Remember, having more concurrent manager processes does not mean more throughput.
|
By Gary Piper on
11/5/2010 5:03 PM
The site in presented with over 30 million rows in the fnd_logins table, growing at a rate of approximately 25,000 records per day. Even holding 31 days of history on-line I would have expected no more than 800,000 rows in the table.
How did this happen when the site was running the sign-on audit purge program Purge Signon Audit data (FNDSCPRG) daily
This case review reviews how this could happens and how I would go about addressing the issue
|
By Gary Piper on
10/9/2010 9:08 PM
I am a business user, so why say to me “it ran for 0.049 days”?
All too often I see reports created by technical staff and DBAs being presented to management and business users with elapsed times (such as concurrent request run times) calculated in days or seconds and this often causes frustration amongst report recipients.
In this blog I will show you how to convert date and time format to something more business user friendly…
|
By Gary Piper on
9/12/2010 10:13 PM
Where a database column and its content is larger than the size you wish to show in a report, it is easy to just substring the column value to fit your report column size. However, this often does not look that good in user facing reports.
|
By Gary Piper on
8/26/2010 2:38 PM
A practical approach to understanding and dealing with Application Response Time issues – Including a FREE Toad report
|
By Gary Piper on
7/23/2010 5:54 PM
Step by step instructions for changing the colour of report text based on the text’s value
|
By Gary Piper on
6/26/2010 8:30 PM
Step by step instructions for hiding TOAD Report Manager report rows with no data – including example report
|
By Gary Piper on
5/11/2010 8:42 PM
Step by step instructions for change a TOAD Manager reports name and or category
|
By Gary Piper on
4/12/2010 3:19 PM
Step by step instructions for calling a procedure from a TOAD Manager Report
|
By Gary Piper on
2/13/2010 11:42 AM
Step by step instructions for creating TOAD Report Manager charts
|
By Gary Piper on
1/14/2010 12:23 PM
A simple, step by step guide for creating TOAD Report Manager reports and templates (TRD -TOAD Report Definition format).
|
By Gary Piper on
12/13/2009 4:10 PM
Step by step instructions for importing and exporting TOAD Report Manager reports (TRD -TOAD Report Definition format).
|