ARCHIVE: E-COB : Not getting any SQL timings for AE and Cobol processes. i.e seeing zeros for all the SQL timings (Doc ID 659606.1)

Last updated on JANUARY 03, 2023

Applies to:

This document was previously published as Customer Connection Solution 201060343

Symptoms

 
Not getting any SQL timings for AE and Cobol processes as following SQL Trace output

PeopleSoft Batch Timings Report: cobsql_821894.trc

Encoding Scheme Used: Ansi

Time      Line        Elapsed   SQL       Cursor Return   DB API Statement
--------  ---------   -------   -------   ------ -------  ----------------
11:10:04          1     0.000     0.000   #1     RC=0     Connect=XXXXX/people/?
11:10:04          2     0.000     0.000   #1     RC=0     CEX Stmt=SELECT OWNERID FROM PS.PSDBOWNER WHERE DBNAME = 'XXXXX'
11:10:04          3     0.000     0.000   #1     RC=0     SSB column=1, type=SQLPSTR, length=31
11:10:04          4     0.000     0.000   #1     RC=0     Fetch
11:10:04          5     0.000     0.000   #1     RC=0     CEX Stmt=SELECT OWNERID, UNICODE_ENABLED FROM SYSADM.PSSTATUS
11:10:04          6     0.000     0.000   #1     RC=0     SSB column=1, type=SQLPSTR, length=31
11:10:04          7     0.000     0.000   #1     RC=0     SSB column=2, type=SQLPSIN, length=4
11:10:04          8     0.000     0.000   #1     RC=0     Fetch
11:10:04          9     0.000     0.000   #1     RC=0     CEX Stmt=SELECT A.ACCESSID, A.ACCESSPSWD, A.ENCRYPTED FROM SYSADM.PSOPRDEFN O,          SYSADM.PSACCESSPRFL A WHERE O.OPRID='LSILVER' AND A.SYMBOLICID = O.SYMBOLICID
11:10:04         10     0.000     0.000   #1     RC=0     SSB column=1, type=SQLPSTR, length=17
11:10:04         11     0.000     0.000   #1     RC=0     SSB column=2, type=SQLPSTR, length=17
11:10:04         12     0.000     0.000   #1     RC=0     SSB column=3, type=SQLPSIN, length=4
11:10:04         13     0.000     0.000   #1     RC=0     Fetch
11:10:04         14     0.000     0.000   #1     RC=0     Disconnect
11:10:04         15     0.000     0.000   #1     RC=0     Connect=XXXXX/SYSADM/?
11:10:04         16     0.000     0.000   #1     RC=0     SET OprId=YYYYY
11:10:04         17     0.000     0.000   #1     RC=0     SET type= cursor=persistent
11:10:04         18     0.000     0.000   #1     RC=0     CEX Stmt=SELECT OPERPSWD FROM PSOPRDEFN WHERE OPRID = 'YYYYY'
11:10:04         19     0.000     0.000   #1     RC=0     SSB column=1, type=SQLPSTR, length=33
11:10:04         20     0.000     0.000   #1     RC=0     Fetch
11:10:04         21     0.000     0.000   #1     RC=0     VER db-version=10KNOWN
11:10:04         22     0.000     0.000   #1     RC=0     SIL RL
11:10:04         23     0.000     0.000   #1     RC=0     Commit
11:10:04         24     0.000     0.000   #1     RC=0     Commit
11:10:04         25     0.000     0.000   #1     RC=0     GETSTMT Stmt=PTPUSTAT_U_PRCRQSE, length=158
11:10:04         26     0.000     0.000   #0     RC=0     STMT before Meta-Sql expansion=UPDATE PSPRCSRQST SET RUNSTATUS = :1 ,PRCSRTNCD = :2 ,ENDDTTM = %CURRENTDATETIMEIN ,LASTUPDDTTM = %CURRENTDATETIMEIN ,CONTINUEJOB = :3 WHERE PRCSINSTANCE = :4
11:10:04         27     0.000     0.000   #1     RC=0     COM Stmt=UPDATE PSPRCSRQST SET RUNSTATUS = :1 ,PRCSRTNCD = :2 ,ENDDTTM = SYSDATE ,LASTUPDDTTM = SYSDATE ,CONTINUEJOB = :3 WHERE PRCSINSTANCE = :4
11:10:04         28     0.000     0.000   #1     RC=0     Bind-1, type=SQLPBUF, length=1, value=9
11:10:04         29     0.000     0.000   #1     RC=0     Bind-2, type=SQLPSSH, length=2, value=0
11:10:04         30     0.000     0.000   #1     RC=0     Bind-3, type=SQLPSSH, length=2, value=0
11:10:04         31     0.000     0.000   #1     RC=0     Bind-4, type=SQLPSLO, length=4, value=821894
11:10:04         32     0.000     0.000   #1     RC=0     EXE
11:10:04         33     0.000     0.000   #2     RC=0     Connect=XXXXX/SYSADM/?
11:10:04         34     0.000     0.000   #2     RC=0     GETSTMT Stmt=PTPUSTAT_U_PRCQUE, length=127
11:10:04         35     0.000     0.000   #0     RC=0     STMT before Meta-Sql expansion=UPDATE PSPRCSQUE SET RUNSTATUS = :1 ,PRCSRTNCD = :2 ,LASTUPDDTTM = %CURRENTDATETIMEIN ,CONTINUEJOB = :3 WHERE PRCSINSTANCE = :4
11:10:04         36     0.000     0.000   #2     RC=0     COM Stmt=UPDATE PSPRCSQUE SET RUNSTATUS = :1 ,PRCSRTNCD = :2 ,LASTUPDDTTM = SYSDATE ,CONTINUEJOB = :3 WHERE PRCSINSTANCE = :4
11:10:04         37     0.000     0.000   #2     RC=0     Bind-1, type=SQLPBUF, length=1, value=9
11:10:04         38     0.000     0.000   #2     RC=0     Bind-2, type=SQLPSSH, length=2, value=0
11:10:04         39     0.000     0.000   #2     RC=0     Bind-3, type=SQLPSSH, length=2, value=0
11:10:04         40     0.000     0.000   #2     RC=0     Bind-4, type=SQLPSLO, length=4, value=821894
11:10:04         41     0.000     0.000   #2     RC=0     EXE
11:10:04         42     0.000     0.000   #3     RC=0     Connect=XXXXX/SYSADM/?
11:10:04         43     0.000     0.000   #3     RC=0     GETSTMT Stmt=PTPUSTAT_S_JOBINST, length=58
11:10:04         44     0.000     0.000   #3     RC=0     COM Stmt=SELECT JOBINSTANCE FROM PSPRCSRQST WHERE PRCSINSTANCE = :1
11:10:04         45     0.000     0.000   #3     RC=0     Bind-1, type=SQLPSLO, length=4, value=821894
11:10:04         46     0.000     0.000   #3     RC=0     SSB column=1, type=SQLPSLO, length=4
11:10:04         47     0.000     0.000   #3     RC=0     EXE
11:10:04         48     0.000     0.000   #3     RC=0     Fetch
11:10:04         49     0.000     0.000   #3     RC=0     Disconnect
11:10:04         50     0.000     0.000   #1     RC=0     Commit
11:10:04         51     0.000     0.000   #1     RC=0     Commit
11:10:04         52     0.000     0.000   #2     RC=0     Disconnect
11:10:04         53     0.000     0.000   #1     RC=0     Disconnect

                                          PeopleSoft Batch Statistics
                                            (All timings in seconds)

Encoding Scheme Used: Ansi

                       R e t r i e v e        C o m p i l e        E x e c u t e         F e t c h               STMT TOTALS
Statement            Count         Time   Count         Time   Count         Time   Count         Time         Time    % SQL

COMMIT                    0         0.00       0         0.00       4         0.00       0         0.00         0.00     NaNQ
CONNECT                   0         0.00       0         0.00       3         0.00       0         0.00         0.00     NaNQ
DISCONNECT               0         0.00       0         0.00       3         0.00       0         0.00         0.00     NaNQ
PTPUSTAT_S_JOBINST       1         0.00       1         0.00       1         0.00       1         0.00         0.00     NaNQ
PTPUSTAT_U_PRCQUE        1         0.00       1         0.00       1         0.00       0         0.00         0.00     NaNQ
PTPUSTAT_U_PRCRQSE       1         0.00       1         0.00       1         0.00       0         0.00         0.00     NaNQ
                    ------- ------------ ------- ------------ ------- ------------ ------- ------------
Total:                    3         0.00       3         0.00      13         0.00       1         0.00
                                    -----                 -----                 -----                 -----
Percent of Total:                   NaNQ%                 NaNQ%                 NaNQ%                 NaNQ%

                                     Time  % Total
Total in SQL:                       0.00     0.00
Total in Application:              0.00     0.00
                                ---------
Total Run Time:                     0.00


Total Statements:                  6
Max Cursors Connected:            3
11:10:04         54     0.000     0.000   #0     RC=0     DON


 

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.