prabhatsahu

How to use TK-Proof in Oracle

This article explains how to use the Tk-prof utility in Oracle.  TK-Proof in Oracle TK-Prof is a utility by Oracle database to trace the performance of query within PL/SQL block. Steps to use TK-Prof: alter session set tracefile_identifier =’cur_for_loop’; alter session set timed_statistics=true; EXECUTE DBMS_SESSION.SESSION_TRACE_ENABLE(WAITS=>TRUE, BINDS=>TRUE); set serveroutput on; — —————————————————————————— — Populating the data …

How to use TK-Proof in Oracle Read More »

How to use Data Pump in Oracle:

This article explains how to use Data Pump in Oracle to export/import data to/from the Oracle cluster. Data pump is a Utility provided by Oracle to Export(EXPDP)/Import(IMPDP) the data to/from the new/old Oracle cluster started from Oracle 10g(10.1), which are performance-wise better as compared to the original Export(EXP) and Import(IMP) utilities. It supports different modes …

How to use Data Pump in Oracle: Read More »

Twitter
YouTube
Pinterest
LinkedIn