Comments on The PeopleSoft DBA Blog: Database Links and PeopleSoft

thanks for the article,it help me alot to understa...

2009-11-23T07:34:05.841Z

thanks for the article,it help me alot to understanding DML

Hi David, Instead of using EIP integration points...

2009-11-21T23:39:42.833Z

Hi David,

Instead of using EIP integration points for our HR and CRM application , we are planning to use the DB2 views for full data load as well as incremental load. Seeing the volume of our organisational data we are thinking that full data load using EIP can cause issue around performance and service availablity but at the same time is it possible to use the EIP business logic using DB2 views to get data from HCM table at the realtime basis for our CRM instance?

Thaks

I'd be interested to see what is causing you p...

2009-11-12T11:44:35.774Z

I'd be interested to see what is causing you problems. But let's move this off the blog. Can you either mail me direct, or post to PeopleSoft DBA forum (http://groups.yahoo.com
/group/psftdba).

Hi.. Thanks a tonne. The Presentation really g...

2009-11-12T10:43:49.144Z

Hi..
Thanks a tonne. The Presentation really gave me some useful insights. But unfortunately for me I found that the queries are coming from deep within PeopleTools. These queries usually dont use bind variables and my DBAs claim that this is the reason why the query is slow. Since there is no way for me to edit the query I am pretty much helpless now :(.

It depends. Some queries come from within the app...

2009-11-12T01:30:55.165Z

It depends. Some queries come from within the application and can be changed via the PeopleSoft Application Designer, some come from the ad-hoc PS/Query tool and can be changed on-line, and some queries are coded deep within PeopleTools, and you cannot change them.

You need to work out where the query came from. It is a subject that I addressed in the book, but this presentation on my website might give you some help working out where these problem queries are coming from: http://www.go-faster.co.uk/psftpres.htm#SQL*Fingerprints

Hi... I would like to ask for a small clarifica...

2009-11-11T23:06:15.102Z

Hi...
I would like to ask for a small clarification. The Oracle Grid Monitor throws up some of the queries run internally by PeopleSoft as bad queries. Is there any way where we can go and edit these queries to improve the performance?

I think you need to consider the cost of developme...

2009-11-05T10:43:12.250Z

I think you need to consider the cost of development and maintenance if you’re going to recommend building messages everywhere in order to support ad hoc queries. You can end up having a ton is integration points that need to be supported for management reporting... I don't think that is very realistic... If it's an online page that is heavily used I completely agree that the data needs to be in the local db...