Home > PT > When was a query last executed?

When was a query last executed?

PSQRYSTATS table tells you about when was a particular query last executed and more details. This PSQRYSTATS table has following fileds.

OPRID
QRYNAME
EXECCOUNT  – Count of Query Execution
AVGEXECTIME  – Average Query Execution Time
AVGFETCHTIME – Average Fetch Time
LASTEXECDTTM – DateTime of Last Execution
AVGNUMROWS – Average Number of Rows Fetched
NUMKILLS – Number of Times Killed

**********************

PSQRYDEFN has a field QRYTYPE. It is a number field and It’s values are listed below.
7  – ARCHIVE
5  – PROCESS
4  – ROLEQRY
1  – QUERY

Advertisements
Categories: PT Tags: ,
  1. September 26, 2013 at 12:37 pm

    Good post. Really usefull.mypeoplesoft

  1. November 7, 2008 at 8:37 am

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: