16.7.5.3 Two-Task Common (TTC) Packet Examples
TTC handles requests, such as open cursor, select rows, and update rows that are directed to the database server.
All requests are answered by the database server. If you request to log on, then a response is returned from the database server that the request was completed.
Summary information for TTC from the -ou option is different from other displays in that it shows two packets on each line, rather than one. This is done to mirror the request/response pairings process by which TTC operates.
Output is displayed in the following format:
descriptionTTC_messagecursor_numberSQL_statementbytes_sentbytes_received
Example 16-18 shows all of the details sent along with the connect data in negotiating a connection.
Example 16-18 trcasst -ou Output
*************************************************************************
* Trace Assistant *
*************************************************************************
Bytes Bytes
Sent Rcvd
Send operation(TTIPRO) 32 140
Send operation(TTIDTY) 33 22
Get the session key (OSESSKEY) 229 145
Generic authentication call (OAUTH) 368 1001
Send operation(TTIPFN) 44 144
Send operation(TTIPFN) 36 16
Parse a statement (OSQL) # 1 SELECT USER FROM ... 47 100
Fast upi calls to opial7 (OALL7) # 1 130 111
Fetch row (OFETCH) # 1 21 137
Close cursor (OCLOSE) # 1 17 11
New v8 bundled call (OALL8) # 0 !Keep Parse BEGI... 156 145
Send operation(TTIPFN) 51 16
Parse a statement (OSQL) # 1 SELECT ATTRIBUTE,... 186 100
Fast upi calls to opial7 (OALL7) # 1 246 111
Fetch row (OFETCH) # 1 21 126
Close cursor (OCLOSE) # 1 17 11
Send operation(TTIPFN) 36 16
Parse a statement (OSQL) # 1 SELECT CHAR_VALUE... 208 100
Fast upi calls to opial7 (OALL7) # 1 130 111
Fetch row (OFETCH) # 1 21 126
Close cursor (OCLOSE) # 1 17 11
Send operation(TTIPFN) 36 16
Fast upi calls to opial7 (OALL7) # 1 !Keep Parse BEGI... 183 41
Send operation(TTIRXD) 20 111
Close cursor (OCLOSE) # 1 17 11
New v8 bundled call (OALL8) # 0 Parse Fetch SELE... 165 278
Send operation(TTIPFN) 51 16
Parse a statement (OSQL) # 1 commit 31 100
Execute statement (OEXEC) # 1 number of rows: 1 25 100
Close cursor (OCLOSE) # 1 17 11
Send operation(TTIPFN) 36 16
Fast upi calls to opial7 (OALL7) # 1 !Keep Parse BEGI... 183 41
Send operation(TTIRXD) 60 111
Close cursor (OCLOSE) # 1 17 11
Send operation(TTIPFN) 36 16
Fast upi calls to opial7 (OALL7) # 1 !Keep Parse BEGI... 183 41
Send operation(TTIRXD) 20 111
Close cursor (OCLOSE) # 1 17 11
New v8 bundled call (OALL8) # 0 Parse Fetch sele... 144 383
New v8 bundled call (OALL8) # 1 !Keep Fetch 121 315
Logoff off of Oracle (OLOGOFF) 13 11
*************************************************************************
* Trace Assistant has completed *
*************************************************************************
Example 16-19 shows detailed TTC information from the -ot option.
Example 16-19 Detailed TTC Information from trcasst -ot Output
*************************************************************************
* Trace Assistant *
*************************************************************************
Set protocol (TTIPRO)
Operation 01 (con) Send protocol version=6
Originating platform: x86_64/Linux 2.4.xx
Set protocol (TTIPRO)
Operation 01 (con) Receive protocol version=6
Destination platform: x86_64/Linux 2.4.xx
Set datatypes (TTIDTY)
Set datatypes (TTIDTY)
Start of user function (TTIFUN)
Get the session key (OSESSKEY)
Return opi parameter (TTIRPA)
Start of user function (TTIFUN)
Generic authentication call (OAUTH)
Return opi parameter (TTIRPA)
Piggyback function follows (TTIPFN)
Start of user function (TTIFUN)
V8 session switching piggyback (O80SES)
Start of user function (TTIFUN)
Get Oracle version/date (OVERSION)
Return opi parameter (TTIRPA)
Oracle Database 23ai Enterprise Edition Release 23.4.0.0.0 - 64bit Production
Version 23.4.0.0.0
Start of user function (TTIFUN)
New v8 bundled call (OALL8) Cursor # 0
Parse Fetch
Describe information (TTIDCB)
Start of user function (TTIFUN)
Fetch row (OFETCH) Cursor # 3
ORACLE function complete (TTIOER)
ORA-01403: no data found
Piggyback function follows (TTIPFN)
Start of user function (TTIFUN)
Cursor Close All (OCCA)
Start of user function (TTIFUN)
New v8 bundled call (OALL8) Cursor # 0
Parse Fetch
Describe information (TTIDCB)
Piggyback function follows (TTIPFN)
Start of user function (TTIFUN)
Cursor Close All (OCCA)
Start of user function (TTIFUN)
New v8 bundled call (OALL8) Cursor # 0
Parse Fetch
Describe information (TTIDCB)
Piggyback function follows (TTIPFN)
Start of user function (TTIFUN)
Cursor Close All (OCCA)
Start of user function (TTIFUN)
New v8 bundled call (OALL8) Cursor # 0
!Keep Parse
Sending the I/O vector only for fast upi (TTIIOV)
Piggyback function follows (TTIPFN)
Start of user function (TTIFUN)
Cursor Close All (OCCA)
Start of user function (TTIFUN)
New v8 bundled call (OALL8) Cursor # 0
Parse Fetch
Describe information (TTIDCB)
Piggyback function follows (TTIPFN)
Start of user function (TTIFUN)
Cursor Close All (OCCA)
Start of user function (TTIFUN)
Commit (OCOMMIT)
V6 Oracle func complete (TTISTA)
Start of user function (TTIFUN)
Commit (OCOMMIT)
V6 Oracle func complete (TTISTA)
Start of user function (TTIFUN)
Logoff off of Oracle (OLOGOFF)
MAXIMUM OPEN CURSORS: 0
CURSORS NOT CLOSED: 0
V6 Oracle func complete (TTISTA)
Succeeded
*************************************************************************
* Trace Assistant has completed *
*************************************************************************
Example 16-20 shows detailed SQL information from the -ouq option. On each line of the output, the first item displayed is the actual request made. The second item shows on what cursor that operation has been performed. The third item is either a listing of the SQL command or flag that is being answered. The number of bytes sent and received are displayed at the far right. A flag can be one of the following:
-
!PL/SQL = Not a PL/SQL request
-
COM = Commit
-
IOV = Get I/O Vector
-
DEFN = Define
-
EXEC = Execute
-
FETCH = Fetch
-
CAN = Cancel
-
DESCSEL = Describe select
-
DESCBND = Describe Bind
-
BND = Bind
-
PARSE = Parse
-
EXACT = Exact
Example 16-20 Detailed SQL Information from trcasst -ouq Output
*************************************************************************
* Trace Assistant *
*************************************************************************
Bytes Bytes
Sent Rcvd
Send operation(TTIPRO) 32 140
Send operation(TTIDTY) 33 22
Get the session key (OSESSKEY) 229 145
Generic authentication call (OAUTH) 368 1001
Send operation(TTIPFN) 44 144
Send operation(TTIPFN) 36 16
Parse a statement (OSQL) # 1 47 100
SELECT USER FROM DUAL
Fast upi calls to opial7 (OALL7) # 1 130 111
Fetch row (OFETCH) # 1 21 137
Close cursor (OCLOSE) # 1 17 11
New v8 bundled call (OALL8) # 0 !Keep Parse 156 145
BEGIN DBMS_OUTPUT.DISABLE; END;
Send operation(TTIPFN) 51 16
Parse a statement (OSQL) # 1 186 100
SELECT ATTRIBUTE,SCOPE,NUMERIC_VALUE,CHAR_VALUE,DA
TE_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('S
QL*Plus') LIKE UPPER(PRODUCT)) AND (UPPER(USER) LI
KE USERID)
Fast upi calls to opial7 (OALL7) # 1 246 111
Fetch row (OFETCH) # 1 21 126
Close cursor (OCLOSE) # 1 17 11
Send operation(TTIPFN) 36 16
Parse a statement (OSQL) # 1 208 100
SELECT CHAR_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE
(UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND ((UPPE
R(USER) LIKE USERID) OR (USERID = 'PUBLIC')) AND (
UPPER(ATTRIBUTE) = 'ROLES')
Fast upi calls to opial7 (OALL7) # 1 130 111
Fetch row (OFETCH) # 1 21 126
Close cursor (OCLOSE) # 1 17 11
Send operation(TTIPFN) 36 16
Fast upi calls to opial7 (OALL7) # 1 !Keep Parse 183 41
BEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1,NULL); E
ND;
Send operation(TTIRXD) 20 111
Close cursor (OCLOSE) # 1 17 11
New v8 bundled call (OALL8) # 0 Parse Fetch 165 278
SELECT DECODE('A','A','1','2') FROM DUAL
Send operation(TTIPFN) 51 16
Parse a statement (OSQL) # 1 31 100
commit
Execute statement (OEXEC) # 1 number of rows: 1 25 100
Close cursor (OCLOSE) # 1 17 11
Send operation(TTIPFN) 36 16
Fast upi calls to opial7 (OALL7) # 1 !Keep Parse 183 41
BEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1,NULL); E
ND;
Send operation(TTIRXD) 60 111
Close cursor (OCLOSE) # 1 17 11
Send operation(TTIPFN) 36 16
Fast upi calls to opial7 (OALL7) # 1 !Keep Parse 183 41
BEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1,NULL); E
ND;
Send operation(TTIRXD) 20 111
Close cursor (OCLOSE) # 1 17 11
New v8 bundled call (OALL8) # 0 Parse Fetch 144 383
select * from dept
New v8 bundled call (OALL8) # 1 !Keep Fetch 121 315
Logoff off of Oracle (OLOGOFF) 13 11
*************************************************************************
* Trace Assistant has completed *
*************************************************************************
Parent topic: Using the Trace Assistant to Examine Trace Files