ELF��4Xo4 ($!44�4��������@�@�@�������@������((�(� Q�td/lib/ld-linux.so.2GNU%?9;:>3(5&=-8+)%,'*<1.7  # "$ / !6402 (�v�=(O����X,n,,��,�R���,�,�F�j�X� �� 6�TcP��(<7^�F ��{r�W P���Tj��a4\6l�x�� ��jE�:~4���(��P���������x����C�,�2���3�L�T��Ĵ�4�� ,'�3 libclntsh.so.11.1OCIThreadProcessInitOCISessionPoolCreateOCIDescriptorFree_DYNAMICOCISessionPoolDestroyOCIThreadHndInitOCIThreadIdDestroyOCITransCommitOCILobGetLengthOCILobReadOCIThreadIdInitOCIThreadJoinOCIDefineByPosOCISessionGet_initOCIStmtPrepare2OCIStmtFetchOCIHandleFreeOCIStmtExecuteOCIHandleAllocOCIBindByNameOCIEnvCreateOCIAttrSetOCIErrorGet_finiOCIAttrGet_GLOBAL_OFFSET_TABLE_OCIThreadHndDestroyOCIDescriptorAllocOCISessionReleaseOCIBindByPosOCIThreadCreateOCIStmtRelease_Jv_RegisterClassesOCIThreadCloseOCILobWrite__gmon_start__libpthread.so.0libc.so.6printfstdoutgetopt_longfeofsleepoptargfflushabortcallocrand_rfreadgettimeofdaymemsettimefcloseexitfopenatoi_IO_stdin_used__libc_start_mainstrlenfree_edata__bss_start_endGLIBC_2.1GLIBC_2.0Rii ii (��>P�T�7���������������� �� �� �� �� ����������������������� ��� �!�" �#$�$(�&,�'0�(4�)8�*<�+@�,D�/H�1L�2P�3T�4X�5\�6`�9d�:h�<l�=U����a�� (���5���%���%��h������%��h������%��h������%��h�����%��h �����%��h(�����%��h0�����%��h8�p����%��h@�`����%��hH�P����%��hP�@����%��hX�0����%��h`� ����%��hh�����%��hp�����%��hx������%��h�������%��h�������%��h�������%��h������%��h������%��h������%�h������%�h��p����%�h��`����% �h��P����%�h��@����%�h��0����%�h�� ����%�h������% �h������%$�h�������%(�h������%,�h������%0�h������%4�h�����%8�h �����%<�h(�����%@�h0�����%D�h8�p����%H�h@�`����%L�hH�P����%P�hP�@����%T�hX�0����%X�h`� ����%\�hh�����%`�hp�����%d�hx������%h�h�������%l�h������1�^����PTRh4�h�QVhT��������U��S�[���AR��������t��X[�Ð��U����=X�t��v������ҡ�����u��X��É�U��������t���t�� h���Ѓ��v�Ð�U����=t�t�� h������������jjjj�5��������P�5���u �E�P�u�������,Pj�u �+������jjjjjjjj�E�p,j�u �E�P�u��y����� :EMPNO order by empnodemonstrating array fetching :EMPNOarray fetch successful empno=%d, ename=%s BEGIN RAISE_SALARY(:emp_id,:sal_increase, :new_salary); END;demonstrating using PLSQL inside OCI program :emp_id:sal_increase:new_salaryresults: emp_id=%d, salary_increase=%d new_salary=%d begin emp_demo_pkg.open_cur(:myrefcursor, :emp_id); end;demonstrating using PLSQL Ref cursor inside OCI program :myrefcursorref cursor fetch successful INSERT INTO lob_table VALUES ( :mylobid, EMPTY_CLOB()) returning lobcol into :myclobdemonstrating LOB Write inside OCI program :mylobid:myclobrocidemolb.datCannot open file for reading Write_to_loc error : OCILobWrite Write Successful Written %d bytes into Locator Successfully. select lobcol from lob_table where lobid = :1demonstrating LOB Read inside OCI program Reading %d bytes from Locator Read %d bytes from Locator stage5: Demonstrating client resultset cache %d%%Y@�����A@*@Y@��.AError - %.*s Error - OCI_SUCCESS_WITH_INFO Error - OCI_NEED_DATA Error - OCI_NODATA Error - OCI_ERROR NULL handle Unable to extract detailed diagnostic information Error - OCI_INVALID_HANDLE Error - OCI_STILL_EXECUTE Error - OCI_CONTINUE helpverboseiterationthreadnumupdatenumthinktimehi:t:u:vw:usage: %s [-t threadnum] [-w thinktime] [-i iteration] [-u updatenum] [-v] [-h] Description: An OCI sample code to update, query and fetch -t, --thread The number of threads, the default is 20 threads -w, --thinktime think time in seconds between units of workload the default is 0 second -i, --iteration The number of units of workload in each thread the default iteration is 60 -u, --updatenum number of updates in a unit of workload the default number of updates is 80 -v, --verbose print detailed information -h, --help print this help info This application will spawn %d threads Each thread will perform %d units of workload Each unit of workload will include %d updates Think time between two units of workload is %d seconds The application takes %f seconds to update records The application takes %f seconds for single row queries The application takes %f seconds for multi-row fetch Each thread takes %f seconds average to update records Each thread takes %f seconds average for single row queries Each thread takes %f seconds average for multi-row fetch �?@��.A��������BR X� ��H�І�� 2 ���Ȋ�����o�����o���o�����������ƌ֌�����&�6�F�V�f�v���������ƍ֍�����&�6�F�V�f�v���������Ǝ֎�����&�6�F�V�f�v�������ȴϴ״شT���|�ĹxPĻhɻvѻiۻt�u�wGCC: (GNU) 3.4.6 20060404 (Red Hat 3.4.6-9)GCC: (GNU) 3.4.6 20060404 (Red Hat 3.4.6-9)GCC: (GNU) 3.4.6 20060404 (Red Hat 3.4.6-10.0.1)GCC: (GNU) 3.4.6 20060404 (Red Hat 3.4.6-10.0.1)GCC: (GNU) 3.4.6 20060404 (Red Hat 3.4.6-10.0.1)GCC: (GNU) 3.4.6 20060404 (Red Hat 3.4.6-10.0.1)GCC: (GNU) 3.4.6 20060404 (Red Hat 3.4.6-9)H�6X�� �6 update_salary�query_salary�multirow_fetchx plsql_exec- plsql_refcursor� lob_write lob_readAdo_workload�mainthread_function�envhp�MY_PLSQL�MY_LOBQUERYMY_LOBQUERY2�6O�random_input:printerrmsg�checkerr0parse_options�spawn_threads�verbose_flag�waittimeiterationupdate_num5thread_num2V�H�GNU C 3.4.6 20060404 (Red Hat 3.4.6-10.0.1)stage7.c/ade/b/3050220379/oracle/tklocal/oowsize_tՁWunsigned charshort unsigned intlong unsigned intsigned charshort intintlong long intlong long unsigned int__quad_t;�__off_t�1long int__off64_t�W__time_t�1__suseconds_t�1�charFILE.��._flags �#_IO_read_ptrz#_IO_read_endz#_IO_read_basez# _IO_write_basez#_IO_write_ptrz#_IO_write_endz#_IO_buf_basez#_IO_buf_endz# _IO_save_basez#$_IO_backup_basez#(_IO_save_endz#,_markersb#0_chain h#4_fileno"�#8_flags2&�#<_old_offset("#@_cur_column,�#D_vtable_offset-�#F_shortbuf.n#G_lock2~#H_offset;=#L__pad1D#T__pad2E#X__pad3F#\__pad4G#`__pad5Hs#d_modeJ�#h_unused2L�#l _IO_lock_t� b_IO_marker � _next�b# _sbuf�h# _pos��#� ~� N �� N'� �timeval F tv_sec GU# tv_usec He#ub1�ub2G�sb2H�ub4n�sb4o�oraub8��ub8�oratext��text�boolean��sword��OCIEnv% dOCIEnv& yt' �tOCIStmt( �OCIStmtOCIBind) �OCIBindd* �dB- �B94 �9�5 �+< +-���U� str_thdata4 thread_no�# updatetime# querytime# fetchtime# seed�# emp_id�# !�#$ multirow_fetch_id�#( salaries�#, id�#0thdataC�update_salaryFH���nE���E��E��bndp1G%�tbndp2G%�pH=�liI��hm�query_salaryw��d�,nv���v��v��bndp1x%�ldefhp1y1�hdefhp2y1�ddefhp3y1�`z=�\!{��Xregion_name|���~num_rows}���~ �� Nc multirow_fetch�d���Xn�����������=�tbndp�%�p2 multirow_fetch_from_emp���\��nި��=��ޮ�ߴ� defhp1�1�ldefhp2�1�hempid�2 �Pempid_ind�B �@lname�R ��~lname_ind�B ��~lname_len�h ��~done�9��~rows����~i����~status����~ B � N R � N h � N N x � N- plsql_exec*\���n)���)��)��raise+H�tnew_sal+H�p-=�lbnd1p.%�hbnd2p/%�dbnd3p0%�`� plsql_refcursore����nd���d��d��plscallf�th=�pstmthp2i=�lbnd1pj%�hbnd2pk%�d� lob_write���(�n����������M��� lobp�� �l�=�hbnd1p�%�dbnd2p�%�`fp�� �\buf�� ��woffset����wamtp����wlenp����werr����wmylobid����w � �NAlob_read(�8�4n�������M�� lobp� �l=�hbndp%�ddfnhp1�`fp� �\buf� ��woffset���wamtp���wlenp���werr���wmylobid���wdone9��wstatus H��w�do_workload�8�T�`n����������M��� start���`finish���Xmain��T�f��argc���argv������tz�thread_function�f�U��ptr������ti���pusrhp_svc���ldefault_lobprefetch_size���hͤ3�n���d� �create_session_poolU�V��envhp7����~�poolNameLenp+� stmt_cachesize ��tmin!��pmax"��lincrement#��h!stdout�h!verbose_flag1�!waittime2�"M3�!update_num4�!thread_num5�#envhp37\�username0��apppassword1��connstr2z��authp4X`��spoolhp5sd��~6zh�poolNameLen7�l�MY_DMLBz��MY_SELECTpz��MY_SELECT2�z��$MY_PLSQL%��$MY_LOBQUERY���$MY_LOBQUERY2��K �߳X�GNU C 3.4.6 20060404 (Red Hat 3.4.6-10.0.1)helper.c/ade/b/3050220379/oracle/tklocal/oow�unsigned charshort unsigned intlong unsigned intsigned charshort intintlong long intlong long unsigned intlong int�char-8D%� �optionk namel'# has_argo�# flagpD# valq�# ub4ns sb4o� oraub8�� ub8�� oratext�z text�� sword�� �& � ���  ��� � �str_thdata4 thread_no�#��#��# ��# seeds# emp_id�# region_id�#$ multirow_fetch_id�#( salariesD#, idD#0 thdata#4random_inputX�y�pthdata4�i:��l��printerrmsgHy�ҩ<handleG%�htypeG��errbufJ���oerrcodeK���o���checkerr0hҩ�hhandleg%�htypeg��statusg���parse_options��ƭ�argc���argv���errhp���tc���poption_index���l+�l�long_options������J�spawn_threads�ƭ߳�envhp�%�errhp���thread_fun�2�error���l�سi���h����`���X���Ptidp��Lthdhpp��HpData4�DpInputD�@��optarg;verbose_flag�t�waittime�p�iteration���update_num���thread_num���% : ; I$ > $ >  I : ;  : ;I8  : ;  : ; : ; I8 I !I/ : ;I< : ;I<  : ; I8 .? : ; ' @: ; I 4: ; I 4: ; I .: ; ' @.? : ;' @: ;I 4: ;I 4: ;I !I/.? : ;' I@: ;I   .: ;' @!4: ; I? < "4: ; I? < #4: ; I?  $4: ;I?  % $ > $ >  I &I' I  : ; : ; I8 : ; I : ;I < : ; I : ; I8 .? : ; ' @: ; I 4: ; I I!I/ !I/ 4: ; I 4: ;I 4: ;I 4: ; I? < 4: ; I?  ��� /ade/b/3050220379/oracle/rdbms/public/usr/include/usr/include/bits/usr/lib/gcc/i386-redhat-linux/3.4.6/includestage7.coci.hhelper.horatypes.hstdio.hlibio.htypes.hstddef.htime.hH��h�� C>>3(�� +���� CD/58,��(2g��CD/;��(2����7B��e���2���; �V�+grrv�� CDtAA/��(/durv�� =,AD/<�� +�r q+,��CDA/(��X��K�:�.��K���,�X��1�ry�+�� C?,5/*�X,�W��;;J��-/�#(0���:�a:�k;;;;;�a��s�� 2/�0AA�X�,�,d��-V0drrrv/Wt G,s/<(`�[�(�d�/dy*2��t~}�� /ade/b/3050220379/oracle/rdbms/public/usr/includehelper.chelper.horatypes.hoci.hgetopt.hoci1.hX�rGKKW�X �u��(�+eo�W�W�W�d.����-�/duq"dWeH�����������������VXVXVX�XV\YVVVY/�rW����VVY�W�(((D,@$,W$,.fI��wW(((��w� �BBBVVV:::;����| �8H�TA�B T.\. Y.0N.p.@N.p.@N.e.0N.Z. N.D���A�B a.\. Y.0N.v.@N.a.0N.g.0N.j.0N.^. N.}. N.4d�,A�B T.\. Y.0N.v.@N.a.0N.G. N.(���A�B E.0N.t.0N.d. m.@\��A�B i.\. Y.0N.v.@N.z.@N.s.@N.a.0N.|. N.8��A�B i.Y. V.0N.^. N.s.@N.v.@N.a.0N.L��lA�B U. N.u. Y.0N.v.@N.s.@N.a.0N.Z. N.�.0p.j. N.T(�A�B Z.\. Y.0N.q.@N.^. N.g.0N.a.0N.W. r.^. N.w.0~._. N. 8�A�B F���F.8T�A�B h.r.0Q.^. Q.z. Q.\. e.\. e.4f��A�B u. Q.V.@N.^. N.h. N.n. N.0U�A�B ^. N.d. N.F. a.0a.@N.����| ��X�!A�B E��T.�y�YA�B p. \.�ҩEA�B z.$���A�B h. �.�.S.(�ƭA�B H��N.f. }.stmthp_IO_FILEpthdataOCIErrorregion_idOCILobLocatorOCISPoolOCISessioniterationunsigned intOCIDefinesvchpOCISvcCtxpoolNameOCIAuthInfoerrhpquerytimeOCIThreadIdOCIErrorunsigned intfetchtimeupdatetimeOCIThreadHandlettTuTUtUWtWuttHuHItIKtKutt�u��t��t�t ut u tu w tw � u� � t� � t� �u��t��t� u  t tut!t! u ttutt!u!"t"$t$zuz{t{}t}�u��t��t�nunotoqtq� u.symtab.strtab.shstrtab.interp.note.ABI-tag.hash.dynsym.dynstr.gnu.version.gnu.version_r.rel.dyn.rel.plt.init.text.fini.rodata.eh_frame.ctors.dtors.jcr.dynamic.got.got.plt.data.bss.comment.debug_aranges.debug_pubnames.debug_info.debug_abbrev.debug_line.debug_frame.debug_str.debug_loc�#(�( 1H�H�7 ����?І�2G���o� ~T���o��� 0c ��� l Ȋ� � uX�X pp�p 0{����$����4����4� ����@����@����@����@����@�����A����A�����B� �P�PC(�PCO��D@��D��yF��^a_b-�f�)@j�4*k�n?�tP #B H�(�H���І�����Ȋ X� p� �� �� ������������������P� !"#ď ����*��8��E��IX�U� k� ��w������������x� �������������`��d��h����������� 2l�>U� R��[��pj H�T �\�� ������(� �ҩE ���\����� �(�����,,.��8,K��l U��\��gyX�! �,������d�, ����4�B �R���,�, Fj(X� .�>6K\��h�� xT�P���<�^���� ���� �� r�� *W<����O�R _P���kT� pj}�������8� �4��� �6����� ��t�E':?4J����^�n(~��P����p������������x����ƭ �C�f�� ,2-�?3PL]����pT��Ĵ�4�y�Y ������ �,������� call_gmon_startcrtstuff.c__CTOR_LIST____DTOR_LIST____JCR_LIST__p.0completed.1__do_global_dtors_auxframe_dummy__CTOR_END____DTOR_END____FRAME_END____JCR_END____do_global_ctors_auxstage7.cusernameapppasswordconnstrauthpspoolhppoolNameMY_DMLMY_SELECTMY_SELECT2multirow_fetch_from_emppoolNameLencreate_session_poolhelper.clong_options.0OCIThreadProcessInitupdate_salaryplsql_execOCISessionPoolCreateMY_PLSQLlob_readcheckerr0feof@@GLIBC_2.0envhpquery_salaryOCIDescriptorFree_DYNAMICOCISessionPoolDestroyOCIThreadHndInititerationOCIThreadIdDestroylob_write_fp_hwupdate_numfflush@@GLIBC_2.0random_inputOCITransCommit__fini_array_endmultirow_fetch__dso_handle__libc_csu_finiOCILobGetLengthOCILobReadOCIThreadIdInitOCIThreadJoinOCIDefineByPosOCISessionGet_initOCIStmtPrepare2OCIStmtFetchfread@@GLIBC_2.0MY_LOBQUERYplsql_refcursorOCIHandleFreestdout@@GLIBC_2.0abort@@GLIBC_2.0OCIStmtExecuteOCIHandleAlloctime@@GLIBC_2.0_startMY_LOBQUERY2OCIBindByNamestrlen@@GLIBC_2.0sleep@@GLIBC_2.0parse_optionsrand_r@@GLIBC_2.0__fini_array_start__libc_csu_init__bss_startmainOCIEnvCreate__libc_start_main@@GLIBC_2.0__init_array_enddo_workloadOCIAttrSetdata_startprintf@@GLIBC_2.0OCIErrorGet_finifclose@@GLIBC_2.1verbose_flaggetopt_long@@GLIBC_2.0gettimeofday@@GLIBC_2.0OCIAttrGet__preinit_array_endexit@@GLIBC_2.0atoi@@GLIBC_2.0calloc@@GLIBC_2.0_edatawaittimethread_num_GLOBAL_OFFSET_TABLE_free@@GLIBC_2.0_endspawn_threadsmemset@@GLIBC_2.0thread_functionOCIThreadHndDestroyOCIDescriptorAllocOCISessionReleasefopen@@GLIBC_2.1OCIBindByPos__init_array_startoptarg@@GLIBC_2.0_IO_stdin_usedOCIThreadCreateprinterrmsg__data_startOCIStmtRelease_Jv_RegisterClassesOCIThreadCloseOCILobWrite__preinit_array_start__gmon_start__