[ANN] OCISPY - free ORACLE OCI client side tracing and monitoring utility

From: Sergey Sikorskiy <sergey_sikorsky_at_comcast.net>
Date: Tue, 09 Apr 2002 04:08:13 GMT
Message-ID: <NOts8.50023$l7.4923371@bin7.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 Sikorsky

Received on Mon Apr 08 2002 - 23:08:13 CDT