Monday, March 9, 2015

trcasst for reading sqlnet trace files

oracle@prepo:/opt/app/oracle/product/10.2.0.5/network/trace>trcasst sql_trace_9371.trc

Trace Assistant Utility: Version 10.2.0.5.0 Production on October 30, 2014 11:15:06 AM

Copyright (c) 2001, 2010, Oracle.  All rights reserved.


    *************************************************************************
    *                        Trace Assistant                                *
    *************************************************************************

<--- Received 167 bytes - Connect packet  timestamp=28-OCT-2014 05:20:02:331
Current NS version number is: 308.
Lowest NS version number can accommodate is: 300.
        Maximum SDU size: 2048
        Maximum TDU size: 32767
        NT protocol characteristics:
                Test for more data
                Spawner is running
                Hang on to Listener connection
                Test operation
                Full duplex I/O
                Urgent data support
                Generate SIGURG signal
                Handoff connection to another
        Line turnaround value: 0
        Connect data length: 133
        Connect data offset: 34
        Connect data maximum size: 0
                Disable NA services on this connection
                Disable NA services on this connection
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(PORT=1521)(HOST=hmadwh2))(CONNECT
    _DATA=(SID=PREPO)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=infadm))))

---> Send 24 bytes - Accept packet  timestamp=28-OCT-2014 05:20:02:332
Accepted NS version number is: 308.
        Accepted maximum SDU size: 2048
        Accepted maximum TDU size: 32767
        Connect data length: 0
                Native Services wanted
                Disable NA services on this connection
                NAU doing O3LOGON - DH key foldedin

<--- Received 33 bytes - Data packet  timestamp=28-OCT-2014 05:20:02:334
Set protocol (TTIPRO)
        Operation 01 (con) Receive protocol version=6
        Destination platform: Java_TTC-8.2.0

---> Send 183 bytes - Data packet  timestamp=28-OCT-2014 05:20:02:334
Set protocol (TTIPRO)
        Operation 01 (con) Send protocol version=6
        Originating platform: SVR4-be-64bit-8.1.0

<--- Received 779 bytes - Data packet  timestamp=28-OCT-2014 05:20:02:335
Set datatypes (TTIDTY)

---> Send 834 bytes - Data packet  timestamp=28-OCT-2014 05:20:02:336
Set datatypes (TTIDTY)

<--- Received 19 bytes - Data packet  timestamp=28-OCT-2014 05:20:02:338
Start of user function (TTIFUN)
        Get Oracle version/date (OVERSION)

---> Send 174 bytes - Data packet  timestamp=28-OCT-2014 05:20:02:338
Return opi parameter (TTIRPA)
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

<--- Received 121 bytes - Data packet  timestamp=28-OCT-2014 05:20:02:339
Start of user function (TTIFUN)
        Get the session key (OSESSKEY)

---> Send 73 bytes - Data packet  timestamp=28-OCT-2014 05:20:02:341
Return opi parameter (TTIRPA)

<--- Received 155 bytes - Data packet  timestamp=28-OCT-2014 05:20:02:342
Start of user function (TTIFUN)
        Generic authentication call (OAUTH)

---> Send 1197 bytes - Data packet  timestamp=28-OCT-2014 05:20:02:345
Return opi parameter (TTIRPA)

<--- Received 92 bytes - Data packet  timestamp=28-OCT-2014 05:20:02:347
Start of user function (TTIFUN)
        New v8 bundled call (OALL8) Cursor # 0
 Parse
ALTER SESSION SET TIME_ZONE = '-7:0'


---> Send 72 bytes - Data packet  timestamp=28-OCT-2014 05:20:02:347
Return opi parameter (TTIRPA)

<--- Received 188 bytes - Data packet  timestamp=28-OCT-2014 05:20:02:348
Start of user function (TTIFUN)
        New v8 bundled call (OALL8) Cursor # 1
 Parse
 ALTER SESSION SET NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH24:MI:SS.FF'  NLS_TIME
STAMP_TZ_FORMAT = 'YYYY-MM-DD HH24:MI:SS.FF TZH:TZM'


---> Send 335 bytes - Data packet  timestamp=28-OCT-2014 05:20:02:348
Return opi parameter (TTIRPA)

<--- Received 79 bytes - Data packet  timestamp=28-OCT-2014 05:20:02:349
Start of user function (TTIFUN)
        New v8 bundled call (OALL8) Cursor # 1
 Parse Fetch
select USER from DUAL


---> Send 148 bytes - Data packet  timestamp=28-OCT-2014 05:20:02:350
Describe information (TTIDCB)

<--- Received 96 bytes - Data packet  timestamp=28-OCT-2014 05:20:02:350
Start of user function (TTIFUN)
        New v8 bundled call (OALL8) Cursor # 1
 Parse Fetch
select TZ_OFFSET(DBTIMEZONE) from dual


---> Send 163 bytes - Data packet  timestamp=28-OCT-2014 05:20:02:351
Describe information (TTIDCB)

<--- Received 15 bytes - Data packet  timestamp=28-OCT-2014 05:20:02:369
Start of user function (TTIFUN)
        Open a cursor (OOPEN)

---> Send 16 bytes - Data packet  timestamp=28-OCT-2014 05:20:02:370
Return opi parameter (TTIRPA)
        Cursor #: 2

<--- Received 371 bytes - Data packet  timestamp=28-OCT-2014 05:20:02:370
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  2
 Parse
DELETE FROM PCSF_RUN_LOG WHERE RUNCONTEXT = :v0 AND INTEGRATIONSERVICE =:v1 AN
D REPOSITORYNAME = :v2 AND REPOSITORYDOMAIN = :v3 AND RUNID != :v4 AND ENTRYTI
ME < :v5

---> Send 55 bytes - Data packet  timestamp=28-OCT-2014 05:20:02:375
Return opi parameter (TTIRPA)

<--- Received 15 bytes - Data packet  timestamp=28-OCT-2014 05:20:02:376
Start of user function (TTIFUN)
        Open a cursor (OOPEN)

---> Send 16 bytes - Data packet  timestamp=28-OCT-2014 05:20:02:376
Return opi parameter (TTIRPA)
        Cursor #: 3

<--- Received 797 bytes - Data packet  timestamp=28-OCT-2014 05:20:02:376
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
INSERT INTO PCSF_RUN_LOG (ABSOLUTEFILENAME, NODENAME, INTEGRATIONSERVICE, REPO
SITORYDOMAIN, REPOSITORYNAME, FOLDER, WORKFLOW, SESSIONPATH, RUNCONTEXT, RUNID
, ENTRYTIME, OSUSER, RUNINSTANCENAME) VALUES (:v0, :v1, :v2, :v3, :v4, :v5, :v
6, :v7, :v8, :v9, :v10, :v11, :v12)

---> Send 55 bytes - Data packet  timestamp=28-OCT-2014 05:20:02:379
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:20:04:365
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:20:04:370
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:20:12:380
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:20:12:385
Return opi parameter (TTIRPA)

<--- Received 138 bytes - Data packet  timestamp=28-OCT-2014 05:20:20:395
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
SELECT sys_context('USERENV', 'SERVER_HOST'), sys_context('USERENV', 'INSTANCE
_NAME') FROM dual

---> Send 53 bytes - Data packet  timestamp=28-OCT-2014 05:20:20:396
Return opi parameter (TTIRPA)

<--- Received 22 bytes - Data packet  timestamp=28-OCT-2014 05:20:20:397
Start of user function (TTIFUN)
        New describe any call (ODNY)

---> Send 172 bytes - Data packet  timestamp=28-OCT-2014 05:20:20:397
Return opi parameter (TTIRPA)

<--- Received 72 bytes - Data packet  timestamp=28-OCT-2014 05:20:20:398
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 !Keep Fetch

---> Send 100 bytes - Data packet  timestamp=28-OCT-2014 05:20:20:398
Row transfer header (TTIRXH)
        end of row
        Requests: 2, Iteration #: 0
        Number of iterations: 125, UAC buffer length: 0

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:20:20:399
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:20:20:403
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:20:28:414
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:20:28:418
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:20:36:429
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:20:36:433
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:20:44:444
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:20:44:448
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:20:52:459
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:20:52:464
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:21:00:474
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:21:00:479
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:21:08:489
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:21:08:493
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:21:16:504
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:21:16:521
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:21:24:532
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:21:24:539
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:21:32:549
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:21:32:556
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:21:40:566
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:21:40:570
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:21:48:581
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:21:48:585
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:21:56:596
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:21:56:601
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:22:04:611
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:22:04:617
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:22:12:628
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:22:12:632
Return opi parameter (TTIRPA)

<--- Received 361 bytes - Data packet  timestamp=28-OCT-2014 05:22:14:887
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
DELETE FROM PCSF_RUN_LOG WHERE RUNCONTEXT = :v0 AND INTEGRATIONSERVICE =:v1 AN
D REPOSITORYNAME = :v2 AND REPOSITORYDOMAIN = :v3 AND RUNID != :v4 AND ENTRYTI
ME < :v5

---> Send 53 bytes - Data packet  timestamp=28-OCT-2014 05:22:14:895
Return opi parameter (TTIRPA)

<--- Received 712 bytes - Data packet  timestamp=28-OCT-2014 05:22:14:895
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  2
 Parse
INSERT INTO PCSF_RUN_LOG (ABSOLUTEFILENAME, NODENAME, INTEGRATIONSERVICE, REPO
SITORYDOMAIN, REPOSITORYNAME, FOLDER, WORKFLOW, SESSIONPATH, RUNCONTEXT, RUNID
, ENTRYTIME, OSUSER, RUNINSTANCENAME) VALUES (:v0, :v1, :v2, :v3, :v4, :v5, :v
6, :v7, :v8, :v9, :v10, :v11, :v12)

---> Send 55 bytes - Data packet  timestamp=28-OCT-2014 05:22:14:898
Return opi parameter (TTIRPA)

<--- Received 365 bytes - Data packet  timestamp=28-OCT-2014 05:22:17:496
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  2
 Parse
DELETE FROM PCSF_RUN_LOG WHERE RUNCONTEXT = :v0 AND INTEGRATIONSERVICE =:v1 AN
D REPOSITORYNAME = :v2 AND REPOSITORYDOMAIN = :v3 AND RUNID != :v4 AND ENTRYTI
ME < :v5

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:22:17:505
Return opi parameter (TTIRPA)

<--- Received 769 bytes - Data packet  timestamp=28-OCT-2014 05:22:17:505
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
INSERT INTO PCSF_RUN_LOG (ABSOLUTEFILENAME, NODENAME, INTEGRATIONSERVICE, REPO
SITORYDOMAIN, REPOSITORYNAME, FOLDER, WORKFLOW, SESSIONPATH, RUNCONTEXT, RUNID
, ENTRYTIME, OSUSER, RUNINSTANCENAME) VALUES (:v0, :v1, :v2, :v3, :v4, :v5, :v
6, :v7, :v8, :v9, :v10, :v11, :v12)

---> Send 55 bytes - Data packet  timestamp=28-OCT-2014 05:22:17:531
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:22:20:643
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:22:20:647
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:22:28:658
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:22:28:662
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:22:36:673
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:22:36:678
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:22:44:689
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:22:44:694
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:22:52:704
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:22:52:709
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:23:00:720
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:23:00:724
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:23:08:735
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:23:08:739
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:23:16:750
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:23:16:755
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:23:24:765
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:23:24:770
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:23:32:780
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:23:32:785
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:23:40:796
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:23:40:800
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:23:48:811
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:23:48:815
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:23:56:826
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:23:56:831
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:24:04:841
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:24:04:846
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:24:12:857
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:24:12:861
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:24:20:872
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:24:20:876
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:24:28:887
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:24:28:911
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:24:36:921
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:24:36:926
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:24:44:937
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:24:44:942
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:24:52:952
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:24:52:957
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:25:00:968
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:25:00:972
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:25:08:983
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:25:08:987
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:25:16:998
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:25:17:002
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:25:25:013
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:25:25:018
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:25:33:028
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:25:33:034
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:25:41:045
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:25:41:049
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:25:49:060
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:25:49:065
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:25:57:076
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:25:57:082
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:26:05:093
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:26:05:097
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:26:13:108
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:26:13:112
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:26:21:123
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:26:21:127
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:26:29:138
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:26:29:142
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:26:37:153
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:26:37:158
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:26:45:168
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:26:45:173
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:26:53:183
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:26:53:188
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:27:01:199
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:27:01:203
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:27:09:214
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:27:09:218
Return opi parameter (TTIRPA)

<--- Received 361 bytes - Data packet  timestamp=28-OCT-2014 05:27:14:448
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
DELETE FROM PCSF_RUN_LOG WHERE RUNCONTEXT = :v0 AND INTEGRATIONSERVICE =:v1 AN
D REPOSITORYNAME = :v2 AND REPOSITORYDOMAIN = :v3 AND RUNID != :v4 AND ENTRYTI
ME < :v5

---> Send 53 bytes - Data packet  timestamp=28-OCT-2014 05:27:14:456
Return opi parameter (TTIRPA)

<--- Received 712 bytes - Data packet  timestamp=28-OCT-2014 05:27:14:456
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  2
 Parse
INSERT INTO PCSF_RUN_LOG (ABSOLUTEFILENAME, NODENAME, INTEGRATIONSERVICE, REPO
SITORYDOMAIN, REPOSITORYNAME, FOLDER, WORKFLOW, SESSIONPATH, RUNCONTEXT, RUNID
, ENTRYTIME, OSUSER, RUNINSTANCENAME) VALUES (:v0, :v1, :v2, :v3, :v4, :v5, :v
6, :v7, :v8, :v9, :v10, :v11, :v12)

---> Send 55 bytes - Data packet  timestamp=28-OCT-2014 05:27:14:459
Return opi parameter (TTIRPA)

<--- Received 365 bytes - Data packet  timestamp=28-OCT-2014 05:27:17:139
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  2
 Parse
DELETE FROM PCSF_RUN_LOG WHERE RUNCONTEXT = :v0 AND INTEGRATIONSERVICE =:v1 AN
D REPOSITORYNAME = :v2 AND REPOSITORYDOMAIN = :v3 AND RUNID != :v4 AND ENTRYTI
ME < :v5

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:27:17:148
Return opi parameter (TTIRPA)

<--- Received 769 bytes - Data packet  timestamp=28-OCT-2014 05:27:17:148
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
INSERT INTO PCSF_RUN_LOG (ABSOLUTEFILENAME, NODENAME, INTEGRATIONSERVICE, REPO
SITORYDOMAIN, REPOSITORYNAME, FOLDER, WORKFLOW, SESSIONPATH, RUNCONTEXT, RUNID
, ENTRYTIME, OSUSER, RUNINSTANCENAME) VALUES (:v0, :v1, :v2, :v3, :v4, :v5, :v
6, :v7, :v8, :v9, :v10, :v11, :v12)

---> Send 55 bytes - Data packet  timestamp=28-OCT-2014 05:27:17:151
Return opi parameter (TTIRPA)

<--- Received 371 bytes - Data packet  timestamp=28-OCT-2014 05:27:17:169
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
DELETE FROM PCSF_RUN_LOG WHERE RUNCONTEXT = :v0 AND INTEGRATIONSERVICE =:v1 AN
D REPOSITORYNAME = :v2 AND REPOSITORYDOMAIN = :v3 AND RUNID != :v4 AND ENTRYTI
ME < :v5

---> Send 55 bytes - Data packet  timestamp=28-OCT-2014 05:27:17:173
Return opi parameter (TTIRPA)

<--- Received 789 bytes - Data packet  timestamp=28-OCT-2014 05:27:17:174
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  2
 Parse
INSERT INTO PCSF_RUN_LOG (ABSOLUTEFILENAME, NODENAME, INTEGRATIONSERVICE, REPO
SITORYDOMAIN, REPOSITORYNAME, FOLDER, WORKFLOW, SESSIONPATH, RUNCONTEXT, RUNID
, ENTRYTIME, OSUSER, RUNINSTANCENAME) VALUES (:v0, :v1, :v2, :v3, :v4, :v5, :v
6, :v7, :v8, :v9, :v10, :v11, :v12)

---> Send 55 bytes - Data packet  timestamp=28-OCT-2014 05:27:17:176
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:27:17:228
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  2
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:27:17:233
Return opi parameter (TTIRPA)

<--- Received 372 bytes - Data packet  timestamp=28-OCT-2014 05:30:44:327
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  2
 Parse
DELETE FROM PCSF_RUN_LOG WHERE RUNCONTEXT = :v0 AND INTEGRATIONSERVICE =:v1 AN
D REPOSITORYNAME = :v2 AND REPOSITORYDOMAIN = :v3 AND RUNID != :v4 AND ENTRYTI
ME < :v5

---> Send 53 bytes - Data packet  timestamp=28-OCT-2014 05:30:44:328
Return opi parameter (TTIRPA)

<--- Received 806 bytes - Data packet  timestamp=28-OCT-2014 05:30:44:328
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
INSERT INTO PCSF_RUN_LOG (ABSOLUTEFILENAME, NODENAME, INTEGRATIONSERVICE, REPO
SITORYDOMAIN, REPOSITORYNAME, FOLDER, WORKFLOW, SESSIONPATH, RUNCONTEXT, RUNID
, ENTRYTIME, OSUSER, RUNINSTANCENAME) VALUES (:v0, :v1, :v2, :v3, :v4, :v5, :v
6, :v7, :v8, :v9, :v10, :v11, :v12)

---> Send 55 bytes - Data packet  timestamp=28-OCT-2014 05:30:44:332
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:30:45:629
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:30:45:635
Return opi parameter (TTIRPA)

<--- Received 372 bytes - Data packet  timestamp=28-OCT-2014 05:30:46:279
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
DELETE FROM PCSF_RUN_LOG WHERE RUNCONTEXT = :v0 AND INTEGRATIONSERVICE =:v1 AN
D REPOSITORYNAME = :v2 AND REPOSITORYDOMAIN = :v3 AND RUNID != :v4 AND ENTRYTI
ME < :v5

---> Send 53 bytes - Data packet  timestamp=28-OCT-2014 05:30:46:280
Return opi parameter (TTIRPA)

<--- Received 797 bytes - Data packet  timestamp=28-OCT-2014 05:30:46:281
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  2
 Parse
INSERT INTO PCSF_RUN_LOG (ABSOLUTEFILENAME, NODENAME, INTEGRATIONSERVICE, REPO
SITORYDOMAIN, REPOSITORYNAME, FOLDER, WORKFLOW, SESSIONPATH, RUNCONTEXT, RUNID
, ENTRYTIME, OSUSER, RUNINSTANCENAME) VALUES (:v0, :v1, :v2, :v3, :v4, :v5, :v
6, :v7, :v8, :v9, :v10, :v11, :v12)

---> Send 55 bytes - Data packet  timestamp=28-OCT-2014 05:30:46:284
Return opi parameter (TTIRPA)

<--- Received 372 bytes - Data packet  timestamp=28-OCT-2014 05:30:48:274
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  2
 Parse
DELETE FROM PCSF_RUN_LOG WHERE RUNCONTEXT = :v0 AND INTEGRATIONSERVICE =:v1 AN
D REPOSITORYNAME = :v2 AND REPOSITORYDOMAIN = :v3 AND RUNID != :v4 AND ENTRYTI
ME < :v5

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:30:48:276
Return opi parameter (TTIRPA)

<--- Received 816 bytes - Data packet  timestamp=28-OCT-2014 05:30:48:276
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
INSERT INTO PCSF_RUN_LOG (ABSOLUTEFILENAME, NODENAME, INTEGRATIONSERVICE, REPO
SITORYDOMAIN, REPOSITORYNAME, FOLDER, WORKFLOW, SESSIONPATH, RUNCONTEXT, RUNID
, ENTRYTIME, OSUSER, RUNINSTANCENAME) VALUES (:v0, :v1, :v2, :v3, :v4, :v5, :v
6, :v7, :v8, :v9, :v10, :v11, :v12)

---> Send 55 bytes - Data packet  timestamp=28-OCT-2014 05:30:48:278
Return opi parameter (TTIRPA)

<--- Received 372 bytes - Data packet  timestamp=28-OCT-2014 05:30:50:249
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
DELETE FROM PCSF_RUN_LOG WHERE RUNCONTEXT = :v0 AND INTEGRATIONSERVICE =:v1 AN
D REPOSITORYNAME = :v2 AND REPOSITORYDOMAIN = :v3 AND RUNID != :v4 AND ENTRYTI
ME < :v5

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:30:50:250
Return opi parameter (TTIRPA)

<--- Received 793 bytes - Data packet  timestamp=28-OCT-2014 05:30:50:251
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  2
 Parse
INSERT INTO PCSF_RUN_LOG (ABSOLUTEFILENAME, NODENAME, INTEGRATIONSERVICE, REPO
SITORYDOMAIN, REPOSITORYNAME, FOLDER, WORKFLOW, SESSIONPATH, RUNCONTEXT, RUNID
, ENTRYTIME, OSUSER, RUNINSTANCENAME) VALUES (:v0, :v1, :v2, :v3, :v4, :v5, :v
6, :v7, :v8, :v9, :v10, :v11, :v12)

---> Send 55 bytes - Data packet  timestamp=28-OCT-2014 05:30:50:258
Return opi parameter (TTIRPA)

<--- Received 372 bytes - Data packet  timestamp=28-OCT-2014 05:30:52:245
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  2
 Parse
DELETE FROM PCSF_RUN_LOG WHERE RUNCONTEXT = :v0 AND INTEGRATIONSERVICE =:v1 AN
D REPOSITORYNAME = :v2 AND REPOSITORYDOMAIN = :v3 AND RUNID != :v4 AND ENTRYTI
ME < :v5

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:30:52:246
Return opi parameter (TTIRPA)

<--- Received 806 bytes - Data packet  timestamp=28-OCT-2014 05:30:52:246
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
INSERT INTO PCSF_RUN_LOG (ABSOLUTEFILENAME, NODENAME, INTEGRATIONSERVICE, REPO
SITORYDOMAIN, REPOSITORYNAME, FOLDER, WORKFLOW, SESSIONPATH, RUNCONTEXT, RUNID
, ENTRYTIME, OSUSER, RUNINSTANCENAME) VALUES (:v0, :v1, :v2, :v3, :v4, :v5, :v
6, :v7, :v8, :v9, :v10, :v11, :v12)

---> Send 55 bytes - Data packet  timestamp=28-OCT-2014 05:30:52:249
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:30:53:645
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:30:53:649
Return opi parameter (TTIRPA)

<--- Received 372 bytes - Data packet  timestamp=28-OCT-2014 05:30:55:146
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
DELETE FROM PCSF_RUN_LOG WHERE RUNCONTEXT = :v0 AND INTEGRATIONSERVICE =:v1 AN
D REPOSITORYNAME = :v2 AND REPOSITORYDOMAIN = :v3 AND RUNID != :v4 AND ENTRYTI
ME < :v5

---> Send 53 bytes - Data packet  timestamp=28-OCT-2014 05:30:55:147
Return opi parameter (TTIRPA)

<--- Received 808 bytes - Data packet  timestamp=28-OCT-2014 05:30:55:148
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  2
 Parse
INSERT INTO PCSF_RUN_LOG (ABSOLUTEFILENAME, NODENAME, INTEGRATIONSERVICE, REPO
SITORYDOMAIN, REPOSITORYNAME, FOLDER, WORKFLOW, SESSIONPATH, RUNCONTEXT, RUNID
, ENTRYTIME, OSUSER, RUNINSTANCENAME) VALUES (:v0, :v1, :v2, :v3, :v4, :v5, :v
6, :v7, :v8, :v9, :v10, :v11, :v12)

---> Send 55 bytes - Data packet  timestamp=28-OCT-2014 05:30:55:151
Return opi parameter (TTIRPA)

<--- Received 15 bytes - Data packet  timestamp=28-OCT-2014 05:33:16:939
Start of user function (TTIFUN)
        Close cursor (OCLOSE) Cursor # 2

---> Send 13 bytes - Data packet  timestamp=28-OCT-2014 05:33:16:940
V6 Oracle func complete (TTISTA)
        Succeeded

<--- Received 15 bytes - Data packet  timestamp=28-OCT-2014 05:33:16:940
Start of user function (TTIFUN)
        Close cursor (OCLOSE) Cursor # 3

---> Send 13 bytes - Data packet  timestamp=28-OCT-2014 05:33:16:941
V6 Oracle func complete (TTISTA)
        Succeeded

<--- Received 13 bytes - Data packet  timestamp=28-OCT-2014 05:33:16:941
Start of user function (TTIFUN)
        Logoff off of Oracle (OLOGOFF)
        MAXIMUM OPEN CURSORS: 2
        CURSORS NOT CLOSED: 0


---> Send 12 bytes - Data packet  timestamp=28-OCT-2014 05:33:16:942
V6 Oracle func complete (TTISTA)
        Succeeded

///////////////////////////////////////////////////////////////
Error found. Error Stack follows:
              id:0
  Operation code:68
      NS Error 1:12537
      NS Error 2:12560
NT Generic Error:507
  Protocol Error:0
        OS Error:0
 NS & NT Errors Translation
12537, 00000 "TNS:connection closed"
 // *Cause: "End of file" condition has been reached; partner has disconnected.
 // *Action: None needed; this is an information message.
/
12560, 00000 "TNS:protocol adapter error"
 // *Cause: A generic protocol adapter error occurred.
 // *Action: Check addresses used for proper protocol specification. Before
 // reporting this error, look at the error stack and check for lower level
 // transport errors.For further details, turn on tracing and reexecute the
 // operation. Turn off tracing when the operation is complete.
/
00507, 00000 "Connection closed"
 // *Cause: Normal "end of file" condition has been reached; partner has
 // disconnected.
 // *Action: None needed; this is an information message.
/
///////////////////////////////////////////////////////////////


----------------------
Trace File Statistics:
----------------------
Start Timestamp : 28-OCT-2014 05:20:02:331
End Timestamp   : 28-OCT-2014 05:33:16:942
Total number of Sessions: 1

DATABASE:
  Operation Count:    2 OPENS,    86 PARSES,    86 EXECUTES,     3 FETCHES
    Parse Counts:
       0 PL/SQL,     3 SELECT,     12 INSERT,    57 UPDATE,    12 DELETE,
       0 LOCK,       0 TRANSACT,    2 DEFINE,     0 SECURE,     0 OTHER
    Execute counts with SQL data:
       0 PL/SQL,     3 SELECT,     12 INSERT,    57 UPDATE,    12 DELETE,
       0 LOCK,       0 TRANSACT,    2 DEFINE,     0 SECURE,     0 OTHER

    Operation Ratio: 43.0 PARSES per OPEN,  1.0 EXECUTES per PARSE

  Packet Ratio: 1.1511627906976745 packets sent per operation
  Currently opened Cursors: 0
  Maximum opened Cursors  : 2

ORACLE NET SERVICES:
  Total Calls  :        99 sent,         99 received,          96 oci
  Total Bytes  :      7981 sent,      31395 received
    Average Bytes:        80 sent per packet,        317 received per packet
    Maximum Bytes:      1197 sent,        816 received

  Grand Total Packets:     99  sent,      99 received


    *************************************************************************
    *                    Trace Assistant has completed                      *
    *************************************************************************

No comments:

Post a Comment

Featured Post

Apply Patch 22191577 latest GI PSU to RAC and DB homes using Opatch auto or manual steps

Patch 22191577: GRID INFRASTRUCTURE PATCH SET UPDATE 11.2.0.4.160119 (JAN2016) Unzip the patch 22191577 Unzip latest Opatch Version in or...