Listing 1: Prior Database Trace

(b965bc): PREPARE:
(b965bc): select * from employee  (1.980 MilliSeconds)
(b965bc): BIND SELECT OUTPUT BUFFER (DataWindow): (0.240 MilliSeconds)
(b965bc): ,len=44,type=LONG,pbt=22,dbt=0,ct=0,prec=0,scale=0
(b965bc): ,len=44,type=LONG,pbt=22,dbt=0,ct=0,prec=0,scale=0
(b965bc): ,len=22,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0
(b965bc): ,len=22,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0
(b965bc): ,len=44,type=LONG,pbt=22,dbt=0,ct=0,prec=0,scale=0
(b965bc): ,len=42,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0
(b965bc): ,len=22,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0
(b965bc): ,len=18,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0
(b965bc): ,len=12,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0
(b965bc): ,len=12,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0
(b965bc): ,len=4,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0
(b965bc): ,len=13,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0
(b965bc): ,len=88,type=DECIMAL,pbt=4,dbt=0,ct=0,prec=0,scale=3
(b965bc): ,len=30,type=DATE,pbt=7,dbt=0,ct=0,prec=0,scale=0
(b965bc): ,len=30,type=DATE,pbt=7,dbt=0,ct=0,prec=0,scale=0
(b965bc): ,len=30,type=DATE,pbt=7,dbt=0,ct=0,prec=0,scale=0
(b965bc): ,len=4,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0
(b965bc): ,len=4,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0
(b965bc): ,len=4,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0
(b965bc): ,len=4,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0
(b965bc): EXECUTE: (0.002 MilliSeconds)
(b965bc): FETCH NEXT: (5.385 MilliSeconds)
(b965bc): 	COLUMN=102	COLUMN=501	COLUMN=Fran	COLUMN=Whitney	COLUMN=100	COLUMN=9 East
Washington Street	COLUMN=Cornwall	COLUMN=NY	COLUMN=02192	COLUMN=6175553985	COLUMN=A
COLUMN=017349033	COLUMN=45700.000	COLUMN=08-28-1984 255:00:00:000000	COLUMN=NULL
COLUMN=06-05-1958 255:00:00:000000	COLUMN=Y	COLUMN=Y	COLUMN=N	COLUMN=F
(b965bc): FETCH NEXT: (0.028 MilliSeconds)


Listing 2: DBI Names

(3603c30): PREPARE:
(3603c30):   SELECT  "employee"."emp_id" , "employee"."manager_id" , "employee"."emp_fname" ,
"employee"."emp_lname" , "employee"."dept_id" , "employee"."street" , "employee"."city" ,
"employee"."state" , "employee"."zip_code" , "employee"."phone" ,
"employee"."status" , "employee"."ss_number" , "employee"."salary" ,
"employee"."start_date" , "employee"."termination_date" , "employee"."birth_date" ,
"employee"."bene_health_ins" , "employee"."bene_life_ins" ,
"employee"."bene_day_care" , "employee"."sex"
FROM "employee"    (DBI_PREPARE)
(3603c30): BIND SELECT OUTPUT BUFFER (DataWindow):(DBI_SELBIND)
(3603c30): EXECUTE:(DBI_DW_EXECUTE)
(3603c30): FETCH NEXT:(DBI_FETCHNEXT)
(3603c30): FETCH NEXT:(DBI_FETCHNEXT)
(3603c30): FETCH NEXT:(DBI_FETCHNEXT)



Listing 3: Timing

(3603c30): PREPARE:
(3603c30):   SELECT  "employee"."emp_id" , "employee"."manager_id" ,
"employee"."emp_fname" , "employee"."emp_lname" , "employee"."dept_id" ,
"employee"."street" , "employee"."city" , "employee"."state" ,
"employee"."zip_code" , "employee"."phone" , "employee"."status" ,
"employee"."ss_number" , "employee"."salary" , "employee"."start_date" ,
"employee"."termination_date" , "employee"."birth_date" ,
"employee"."bene_health_ins" , "employee"."bene_life_ins" ,
"employee"."bene_day_care" , "employee"."sex"
FROM "employee"     (9.217 MS)
(3603c30): BIND SELECT OUTPUT BUFFER (DataWindow): (0.175 MS)
(3603c30): EXECUTE: (0.001 MS)
(3603c30): FETCH NEXT: (3.164 MS)
(3603c30): FETCH NEXT: (0.008 MS)
(3603c30): FETCH NEXT: (0.008 MS)
(3603c30): FETCH NEXT: (0.007 MS)


Listing 4: Summary Timing

(3603c30): PREPARE:
(3603c30):   SELECT  "employee"."emp_id" , "employee"."manager_id" ,
"employee"."emp_fname" , "employee"."emp_lname" , "employee"."dept_id" ,
"employee"."street" , "employee"."city" , "employee"."state" ,
"employee"."zip_code" , "employee"."phone" , "employee"."status" ,
"employee"."ss_number" , "employee"."salary" , "employee"."start_date" ,
"employee"."termination_date" , "employee"."birth_date" ,
"employee"."bene_health_ins" , "employee"."bene_life_ins" ,
"employee"."bene_day_care" , "employee"."sex"
FROM "employee" (1384.571 MS)
(3603c30): BIND SELECT OUTPUT BUFFER (DataWindow): (1384.739 MS)
(3603c30): EXECUTE: (1384.740 MS)
(3603c30): FETCH NEXT: (1389.161 MS)
(3603c30): FETCH NEXT: (1389.170 MS)
(3603c30): FETCH NEXT: (1389.178 MS)
(3603c30): FETCH NEXT: (1389.185 MS)
(3603c30): FETCH NEXT: (1389.192 MS)


Listing 5: Bindings

(3603c30): PREPARE:
(3603c30):   SELECT  "employee"."emp_id" , "employee"."manager_id" ,
"employee"."emp_fname" , "employee"."emp_lname" , "employee"."dept_id" ,
"employee"."street" , "employee"."city" , "employee"."state" ,
"employee"."zip_code" , "employee"."phone" , "employee"."status" ,
"employee"."ss_number" , "employee"."salary" , "employee"."start_date" ,
"employee"."termination_date" , "employee"."birth_date" ,
"employee"."bene_health_ins" , "employee"."bene_life_ins" ,
"employee"."bene_day_care" , "employee"."sex"
FROM "employee"
(3603c30): BIND SELECT OUTPUT BUFFER (DataWindow):
(3603c30): ,len=80,type=LONG,pbt=22,dbt=0,ct=0,prec=0,scale=0
(3603c30): ,len=80,type=LONG,pbt=22,dbt=0,ct=0,prec=0,scale=0
(3603c30): ,len=22,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0
(3603c30): ,len=22,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0
(3603c30): ,len=80,type=LONG,pbt=22,dbt=0,ct=0,prec=0,scale=0
(3603c30): ,len=42,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0
(3603c30): ,len=22,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0
(3603c30): ,len=6,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0
(3603c30): ,len=11,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0
(3603c30): ,len=12,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0
(3603c30): ,len=3,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0
(3603c30): ,len=13,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0
(3603c30): ,len=160,type=DECIMAL,pbt=4,dbt=0,ct=0,prec=0,scale=3
(3603c30): ,len=30,type=DATE,pbt=7,dbt=0,ct=0,prec=0,scale=0
(3603c30): ,len=30,type=DATE,pbt=7,dbt=0,ct=0,prec=0,scale=0
(3603c30): ,len=30,type=DATE,pbt=7,dbt=0,ct=0,prec=0,scale=0
(3603c30): ,len=3,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0
(3603c30): ,len=3,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0
(3603c30): ,len=3,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0
(3603c30): ,len=3,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0
(3603c30): EXECUTE:
(3603c30): FETCH NEXT:
(3603c30): FETCH NEXT:
(3603c30): FETCH NEXT:


Listing 6: Fetch Buffers

(3603c30):   SELECT  "employee"."emp_id" , "employee"."manager_id" ,
"employee"."emp_fname" , "employee"."emp_lname" , "employee"."dept_id" ,
"employee"."street" , "employee"."city" , "employee"."state" ,
"employee"."zip_code" , "employee"."phone" , "employee"."status" ,
"employee"."ss_number" , "employee"."salary" , "employee"."start_date" ,
"employee"."termination_date" , "employee"."birth_date" ,
"employee"."bene_health_ins" , "employee"."bene_life_ins" ,
"employee"."bene_day_care" , "employee"."sex"
FROM "employee"
(3603c30): BIND SELECT OUTPUT BUFFER (DataWindow):
(3603c30): EXECUTE:
(3603c30): FETCH NEXT:
(3603c30): 	COLUMN=102	COLUMN=501	COLUMN=Fran	COLUMN=Whitney
COLUMN=100	COLUMN=49 East
Washington Street	COLUMN=Needham	COLUMN=MA	COLUMN=02192
COLUMN=6175553985
COLUMN=A	COLUMN=017349033	COLUMN=45700.000	COLUMN=02-26-1990 255:00:00:000000
COLUMN=NULL	COLUMN=06-05-1962 255:00:00:000000	COLUMN=Y	COLUMN=Y	COLUMN=N
COLUMN=F (3603c30): FETCH NEXT:
(3603c30): 	COLUMN=105	COLUMN=501	COLUMN=Matthew	COLUMN=Cobb	COLUMN=100
COLUMN=77 Pleasant Street	COLUMN=Waltham	COLUMN=MA	COLUMN=02154
COLUMN=6175553840	COLUMN=A	COLUMN=052345739	COLUMN=62000.000
COLUMN=07-02-1990 255:00:00:000000	COLUMN=NULL	COLUMN=12-04-1964
255:00:00:000000	COLUMN=Y	COLUMN=Y	COLUMN=N	COLUMN=M
(3603c30): FETCH NEXT:
(3603c30): 	COLUMN=129	COLUMN=902	COLUMN=Philip	COLUMN=Chin
COLUMN=200	COLUMN=59 Pond Street	COLUMN=Atlanta	COLUMN=GA
COLUMN=30339    	COLUMN=4045552341	COLUMN=A
COLUMN=024608923	COLUMN=38500.000	COLUMN=08-04-2001
255:00:00:000000	COLUMN=NULL	COLUMN=10-30-1970
255:00:00:000000	COLUMN=Y	COLUMN=Y	COLUMN=N	COLUMN=M
(3603c30): FETCH NEXT:


Listing 7: Statement Level Trace

(1d53028): CONNECT TO TRS ODB:
DBPARM=ConnectString='DSN=EAS Demo DB V105;UID=dba;PWD=sql'  SERVER=EASDemoDB105
(1d53028): Using timestamp from DBMS server. (2/9/2006  21:06:32.547)
(1d53028): PREPARE:  (2/9/2006  21:06:32.608)   SELECT  "employee"."emp_id" ,
"employee"."manager_id" , "employee"."emp_fname" , "employee"."emp_lname",
"employee"."dept_id" , "employee"."street" , "employee"."city" , "employee"."state" ,
"employee"."zip_code" , "employee"."phone" , "employee"."status" , "employee"."ss_number" ,
"employee"."salary" , "employee"."start_date" , "employee"."termination_date" ,
"employee"."birth_date" , "employee"."bene_health_ins" ,  "employee"."bene_life_ins" ,
"employee"."bene_day_care" , "employee"."sex" FROM "employee"