E-AS: Does Seeing many 'SELECT VERSION FROM PSVERSION' in Trace File Indicate a Performance Issue? (Doc ID 1262316.1)

Last updated on JANUARY 10, 2014

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.49 to 8.51 [Release 8.4]
Information in this document applies to any platform.
Checked for currency ***10 JAN 2014***

Symptoms

When running any trace there could be many entries for 'SELECT VERSION FROM PSVERSION'. Does it indicate a performance problem if you see a higher duration time from one line to the next?  

Details from a trace:

Stmt=SELECT VERSION FROM PSVERSION WHERE OBJECTTYPENAME = 'SYS'
Line 1735: PSAPPSRV.249644 (3377) 1-166850 13.01.32    2.296619 Cur#3.249644.PRD RC=0 Dur=0.000196 COM Stmt=SELECT VERSION FROM PSVERSION WHERE OBJECTTYPENAME = 'SYS'
Line 1877: PSAPPSRV.249644 (3377) 1-166992 13.01.32    0.049534 Cur#3.249644.PRD RC=0 Dur=0.000211 COM Stmt=SELECT VERSION FROM PSVERSION WHERE OBJECTTYPENAME = 'SYS'
Line 2563: PSAPPSRV.249644 (3377) 1-167678 13.01.32    0.011962 Cur#3.249644.PRD RC=0 Dur=0.000398 COM Stmt=SELECT VERSION FROM PSVERSION WHERE OBJECTTYPENAME = 'SYS'
Line 8802: PSAPPSRV.249644 (3377) 1-173917 13.01.33    0.026171 Cur#3.249644.PRD RC=0 Dur=0.000175 COM Stmt=SELECT VERSION FROM PSVERSION WHERE OBJECTTYPENAME = 'SYS'
Line 8962: PSAPPSRV.249644 (3377) 1-174077 13.01.33    0.658052 Cur#3.249644.PRD RC=0 Dur=0.000249 COM Stmt=SELECT VERSION FROM PSVERSION WHERE OBJECTTYPENAME = 'SYS'
Line 10611: PSAPPSRV.249644 (3377) 1-175726 13.01.36    0.866720 Cur#3.249644.PRD RC=0 Dur=0.000147 COM Stmt=SELECT VERSION FROM PSVERSION WHERE OBJECTTYPENAME = 'SYS'
Line 10753: PSAPPSRV.249644 (3377) 1-175868 13.01.37    0.046109 Cur#3.249644.PRD RC=0 Dur=0.000212 COM Stmt=SELECT VERSION FROM PSVERSION

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms