Parse 'sections' of the file and print

UNIX for Beginners Q & A
1

Hi,

This file is a trace/monitoring file generated by Oracle. Unfortunately, they do not have the tool to parse it 'properly' to get the information that I am after.

Basically, I am after the values of the variables in question. I have customer specific information from the attachment. The information that I am after are bind variables from a SQL statement run by the user.

For example, the SQL query below

INSERT INTO XYZ.XYZ_OMG_BUGSBUNNY (OHMYGOD_REF_NO,OHMYGOD_CREATION_DUCK_GMT,OHMYGOD_RCC,OHMYGOD_VERSION_NO,XYZ_ABC_ID,BUGSBUNNY_SEQ_NO,MICKEY_MESSAGE_DUCKTIME,PUBLISHER_MESSAGE_DUCKTIME,BUGSBUNNY_TYPE,BUGSBUNNY_PARTY_TYPE,BUGSBUNNY_TITLE,BUGSBUNNY_DONJUAN_STATUS,BUGSBUNNY_GIVEN_NAME,BUGSBUNNY_SURNAME,BUGSBUNNY_OTHER_NAMES,BUGSBUNNY_GROUP_NUMBER,CREATED_BY,DSS_CREATE_DUCKTIME)VALUES(:1 ,:2 ,:3 ,:4 ,:5 ,:6 ,:7 ,:8 ,:9 ,:10 ,:11 ,:12 ,:13 ,:14 ,:15 ,:16 ,:17 ,SYSDUCK)

The bind variables are :1 to :17. Somewhere in the trace files, information about this variables are in the section

----- Bind Info (kkscoacd) -----

and

----------------------------------------

.

Excerpts from the tracefile example below:

----- Bind Info (kkscoacd) -----
 Bind#0
  oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
  oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
  kxsbbbfp=7ff69bb095e8  bln=24  avl=05  flg=05
  value=61455379
 Bind#1
  oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
  oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
  kxsbbbfp=7ff69bb095b8  bln=24  avl=02  flg=05
  value=1


...
...
...




 Bind#35
  oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
  oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
  kxsbbbfp=7ff69bb09618  bln=24  avl=06  flg=05
  value=2179711620
 Frames pfr 0x7ff69bb08650 siz=30584 efr 0x7ff69bb08508 siz=30528
 Cursor frame dump
  enxt: 11.0x000005c0  enxt: 10.0x00000fd8  enxt: 9.0x00000fa0  enxt: 8.0x00000658
  enxt: 7.0x00000fd8  enxt: 6.0x00000fa0  enxt: 5.0x00000248  enxt: 4.0x00000fa0
  enxt: 3.0x00000638  enxt: 2.0x00000480  enxt: 1.0x00000f98
  pnxt: 1.0x00000038
 kxscphp=0x7ff69bb00cd0 siz=2792 inu=1024 nps=416
 kxscbhp=0x7ff69bb00f10 siz=10376 inu=10008 nps=8768

----------------------------------------

Don't know why I have up to Bind#35 but I do :(. Anyway, I need help on how to parse the tracefiles and print out the Bind#<nn>. I don't want to print all the information within the section, I just want the bind number, the oacdty and value?

Example output below:

Bind Values Set 1:

Bind#0 oacdty=02 value=61455379
Bind#1 oacdty=02 value=1
...
...
Bind#35 oacdty=02 value=2179711620


Bind Values Set 2:

Bind#0 oacdty=02 value=61455379
Bind#1 oacdty=02 value=1
...
...
Bind#35 oacdty=02 value=2179711620



and so on
2

Please post the script you have designed and written so far, to solve your problem.

Please put some effort into your own script and try; and when you post your best attempt, please post all sample input, output, error messages and your script.