Service Oriented Architecture or SOA as it is popularly known is a logical evolution of component based architecture and distributed computing, both of which were prevalent in the 1990s. Today SOA is on the threshold of maturing into a design technique that helps align business with IT initiatives and leverage this alignment to get various [...]
From the monthly archives:
October 2007
In this post I will share a tuning tip that I used to improve the performance of the PeopleSoft Upgrade data conversion AE.
Data Conversion AE was truncating the temporary table è Inserting 35 million rows into temporary table from transaction table è Updating stats
The above steps combined took around 6hrs to complete. It ran in [...]
While building an Inbound/Outbound interface, most of the time we may be in dilemma whether to use Application Engine (AE) or SQR. Here are the tips to build an efficient interface using either AE or SQR.
If we use Application Engine, below points are to be taken into account
If the interface is INBOUND, its better to [...]
The traditional Application Service Provider – ASP Model is overrun by the upcoming Software as a service SaaS Model. Whether it is a deployment, upgrade or maintenence project – the onshore offshore model present in leading indian software companies were growing with a lot of money inflow as a result of ASP model. But In [...]
How to improve the performance of the SQR using Load Lookup Arrays?
For Simple database related validation, we will fire a SQL to check the sanity of data. If this data validation is to be fired for each and every row of data, then it is better to go for Load-Lookup Arrays. This is like Prompt [...]
One of the hallmarks of a good administrator is that they are already troubleshooting the problem before the users complain!
The key to ensuring that the system does not spring surprises is to automate monitoring (without impacting the system performance). In my previous posts, I have provided steps to monitor the process scheduler and application server. [...]
In some cases the two preferred methods for executing UPGCOUNT do not work for you because
You do not have access to PSAE executable
You have very limited access to the environment to successfully run the AE
Here is a PL/SQL that you can use to provide similar result.
set serverout on size 1000000
DECLARE
CURSOR C1 [...]
UPGCOUNT is an AE in current tools releases. Also, there is no delivered page to kick-off this process. The output from this report is critical to determine the success of a major migration (MP or multiple bundles or Upgrade). This helps validate the process to ensure that no data was lost as a result of [...]
Enabler 5 in my list for Business Intelligence Utopia are the ubiquitous, hard-working “Data Models”. Data Model is the heart of any software system and at a fundamental level provides placeholders for data elements to reside.
Business Intelligence systems with all its paraphernalia – Data Warehouses, Marts, Analytical & Mining systems etc. typically deals with the [...]
I have always recommended the following reports to determine a clean migration especially when there are a ton of objects to be migrated (PS Upgrade, Application of Maintenance Packs or Bundles, etc).
Prior to application of the bundles execute the following.
1. SYSAUDIT
2. DDDAUDIT
3. ALTER AUDIT
4. UPGCOUNT (just prior to the actual migration)
The first three can be [...]
