PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

After an upgrade from PT8.48.09 to PT 8.51.25 we get blocking locks on PSLOCK and PSVERSION. Also ge

edited Sep 1, 2015 8:05PM in PeopleTools and Lifecycle Management - PSFT (MOSC) 6 commentsAnswered ✓

We just upgraded from Tools 8.48.09 to 8.51.25.

Since the upgrade we are experiencing blocking locks on PSLOCK and PSVERSION

 

I have run the VERSION AE program, and cleared cache.

I observe locking with this statement:

SELECT VERSION, OBJECTTYPENAME

  FROM PSLOCK

  WHERE OBJECTTYPENAME IN ('QDM')

  FOR UPDATE OF VERSION ;

We have several 2/3-tier query clients.

The Appserver shows Queuing on the PSSAMSRV Appserver process, we have 6 SAM processes running and are still getting queuing.

Also 2-tier/3-tier logins sometimes hang, and saving a query frequently hangs.

The system worked fine 2 days ago before the upgrade.

All tables have good stats.

We are running oracle 10.2.0.4 on HPUX Itanium, App servers on RH Linux 6

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center