[ANN] OCISPY - free ORACLE OCI client side tracing and monitoring utility.
Date: Tue, 09 Apr 2002 04:04:47 GMT
Message-ID: <zLts8.50502$r7.4603507_at_bin8.nnrp.aus1.giganews.com>
Free non-gui utility for tracing of ORACLE client side OCI calls (like Solaris truss or Linux strace).
Windows and Linux versions (Solaris Intel is planed). Easy to install, easy to use.
Easy to watch a password your application sends to a server :-/
Example of an output:
OCIHandleFree type: OCI_HTYPE_ERROR
OCIHandleAlloc type: OCI_HTYPE_ERROR OCIHandleAlloc type: OCI_HTYPE_ERROR OCIHandleAlloc type: OCI_HTYPE_SERVER OCIHandleAlloc type: OCI_HTYPE_SVCCTX OCIHandleAlloc type: OCI_HTYPE_SESSION OCIHandleAlloc type: OCI_HTYPE_SESSION OCIAttrGet handle type: OCI_HTYPE_SERVER, attr name: OCI_ATTR_STATEMENT OCIServerAttach dblink: 'db817a'
OCIAttrSet handle type: OCI_HTYPE_SVCCTX, attr name: OCI_ATTR_SERVER OCIAttrSet handle type: OCI_HTYPE_SESSION, attr name: OCI_ATTR_USERNAME attr val: 'system'
OCIAttrSet handle type: OCI_HTYPE_SESSION, attr name: OCI_ATTR_PASSWORD attr val: 'manager'
OCIAttrSet handle type: OCI_HTYPE_SVCCTX, attr name: OCI_ATTR_SESSION OCISessionBegin credential: OCI_CRED_RDBMS, mode: OCI_DEFAULT OCIHandleAlloc type: OCI_HTYPE_STMT
OCIStmtPrepare lang: OCI_NTV_SYNTAX, mode: OCI_DEFAULT stmt: [BEGIN DBMS_OUTPUT.DISABLE; END;] OCIStmtExecute iters: 1, mode: OCI_DEFAULT OCIAttrGet handle type: OCI_HTYPE_STMT, attr name: OCI_ATTR_SQLFNCODE attr val: 34
OCIAttrGet handle type: OCI_HTYPE_SESSION, attr name: OCI_ATTR_SESSLANG OCIHandleFree type: OCI_HTYPE_STMT
OCIAttrGet handle type: OCI_HTYPE_SESSION, attr name: OCI_ATTR_SESSLANG OCIHandleAlloc type: OCI_HTYPE_STMT
OCIStmtPrepare lang: OCI_NTV_SYNTAX, mode: OCI_DEFAULT stmt: [SELECT DECODE('A','A','1','2') FROM DUAL] OCIDefineByPos pos: 1 type: SQLT_NUM mode: OCI_DEFAULT OCIHandleAlloc type: OCI_HTYPE_DEFINE
OCIStmtExecute iters: 1, mode: OCI_DEFAULT OCIHandleFree type: OCI_HTYPE_STMT
OCIHandleAlloc type: OCI_HTYPE_STMT
OCIStmtPrepare lang: OCI_NTV_SYNTAX, mode: OCI_DEFAULT stmt: [select * from dual
]
OCIStmtGetBindInfo
OCIStmtExecute iters: 0, mode: OCI_DEFAULT
OCIAttrGet handle type: OCI_HTYPE_STMT, attr name: OCI_ATTR_SQLFNCODE attr
val: 4
OCIAttrGet handle type: OCI_HTYPE_STMT, attr name: OCI_ATTR_PARAM_COUNT attr
val: 1
OCIParamGet
OCIDescriptorAlloc type: OCI_DTYPE_PARAM
OCIAttrGet descriptor type: OCI_DTYPE_PARAM, attr name: OCI_ATTR_DATA_TYPE
(the SQL type of the column/argument)
OCIAttrGet descriptor type: OCI_DTYPE_PARAM, attr name:
OCI_ATTR_CHARSET_FORM (Character Set Form)
OCIAttrGet descriptor type: OCI_DTYPE_PARAM, attr name: OCI_ATTR_CHARSET_ID
(Character Set ID)
OCIAttrGet descriptor type: OCI_DTYPE_PARAM, attr name: OCI_ATTR_DATA_SIZE
(maximum size of the data)
OCIAttrGet descriptor type: OCI_DTYPE_PARAM, attr name: OCI_ATTR_NAME (the
name of the column/argument)
OCIAttrGet descriptor type: OCI_DTYPE_PARAM, attr name: OCI_ATTR_DISP_SIZE
(the display size)
OCIDefineByPos pos: 1 type: SQLT_STR mode: OCI_DEFAULT
OCIHandleAlloc type: OCI_HTYPE_DEFINE
OCIAttrSet handle type: OCI_HTYPE_DEFINE, attr name: OCI_ATTR_CHARSET_FORM
attr val: 1
OCIStmtFetch nrows: 15
OCIAttrGet handle type: OCI_HTYPE_STMT, attr name: OCI_ATTR_ROW_COUNT attr
val: 1
OCIHandleFree type: OCI_HTYPE_STMT
OCISessionEnd
-- Sergey SikorskyReceived on Tue Apr 09 2002 - 06:04:47 CEST