1600 PMP mock questions 1400 CAPM mock questions 800 SCJP 6 mock questions 600 OCAJP 7 mock questions 590 OCPJP 7 mock questions 556 SCWCD 5 mock questions 500 OCEJWCD 6 mock questions pdfDownload (java,struts, hibernet etc)

ORACLE Tutorials

Example steps of Bulk Bind profiler

Step 1

- command prompt
- sqlplus
- / as sysdba

Step 2
execute oracle/rdbms/admin/profload.sql

STEP 3

execute oracle/rdbms/admin/proftab.sql

STEP 4

create or replace procedure my_profile (p1 in varchar2, p2 in varchar2)
is
v1 number;
begin
v1 := dbms_profiler.start_profiler(p1,p2);
dbms_output.put_line('result from start ' ||v1);
y;
v1 := dbms_profiler.flush_data;
dbms_output.put_line('result from flush ' ||v1);
v1 := dbms_profiler.stop_profiler;
dbms_output.put_line('result from stop ' ||v1);
end;
/

STEP 5
set serveoutput on
execute my_profile ('benchmark :1', 'this is the first run');

STEP 6

select runid,run_owner,run_date,run_comment,run_comment1,
run_total_time from plsql_profiler_runs;


Reviews and Comments


PMP, CAPM, PMI is a registered certification mark of the Project Management Institute, Inc

Copyright © www.techfaq360.com 2016


About US | Contact US | Privacy Policy | Terms and Conditions  | Website disclaimer  | Cancellation and Refund Policy  | Shipping & Delivery Policy