Illustrates the term tkprof and its used
Illustrates the term tkprof and how is this used?
Expert
tkprof tool:
It is a tuning tool utilized to find out CPU and execution times for SQL statements. Here we use this by first setting timed_statistics to true within the initialization file and after that turning upon tracing for either the whole database through the sql_trace parameter or for the session by using the ALTER SESSION command. When the trace file is generated us run the tkprof tool in opposition to the trace file after that look at the output from the tkprof tool. It can also be used to produce describe plan output.
Write down the differentiation between lookup and filter transformation?
Name the methods and types of Collision Resolution Techniques used in each of the type?
Describe in brief about the Sybase group?
Which member function places a new node on the end of the linked list? Answer: appendNode(): This member function places a new node on the end of t
Write about the term APT_CONFIG within the data stage?
Write about stage administrator and manager?
Explain offline /online modes in the Designer?
Briefly describe the reason of synchronization function offered in Analysis Services 2005 ?
What are two types of implementation as a centrally located logical architecture? Answer: There two types of implementation are as follows: firstly gives a single ve
What is the archtetype or instance pattern?
18,76,764
1935985 Asked
3,689
Active Tutors
1461230
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!