home‎ > ‎instance‎ > ‎

infx sqltrace

Use this command to manage and view sql tracing information.

 func  description 
 func=gloablon  turn on global sql tracing
 func=gloabloff   turn off global sql tracing
 func=useron   turn on user sql tracing
 func=useroff   turn of user sql tracing
 func=userclear   clear user sql tracing data
 func=history   show sql tracing history information
 func=explain   generate sql eplain for statement

func=globalon

Turn on global sql tracing

infx sqltrace func=globalon traces tracesize [ mode=global|user scope=low|medium|high ]
     turn on gloabl sql tracing
       required:
         traces - the number of traces to store
         tracesize - the size in kb of storage for each trace
       optional:
         mode - mode to be set
         scope - the scope of the tracing

func=globaloff

Turn off global sql tracing

infx sqltrace func=globaloff
     turn off global sql tracing

func=useron

Turn on user sql tracing

infx sqltrace func=useron sid
     turn on user sql tracing
       required:
         sid - database session id

func=useroff

Turn off user sql tracing

infx sqltrace func=useroff sid
     turn off user sql tracing
       required:
         sid - database session id

func=userclear

Clean user sql tracing data

infx sqltrace func=userclear sid
     clear user sql tracing cache
       required:
         sid - database session id

func=history

Show history information about this sql statement

infx sqltrace func=history stmt
     show sql tracing history
       required:
         stmt - the sql statement to view

func=explain

Generate sql explain output for this query.

infx sqltrace func=explain stmt db
     show sql explain
       required:
         stmt - the sql statement to view
         db - select database