<<Previous Next>>
Oracle - What is tkprof and
how is it used? - Feb 07, 2010 at 14:20 PM by Shuchi
Gauri
What is tkprof and how is it
used?
tkprof is used for diagnosing performance
issues. It formats a trace file into a more readable format for
performance analysis. It is needed because trace file is a very
complicated file to be read as it contains minute details of program
execution.
Oracle - What
is tkprof and how is it used? - April 10, 2009
at 11:00 AM
What is tkprof and how is it
used?
- Tkprof is a performance diagnosing utility available to DBAs.
It formats a trace file into a more readable format for
performance analysis. So that the DBA can identify and resolve
performance issues like poor SQL, indexing, and wait events.
- When a user comes across problems related to the response time
in comparison to his previous weeks response time, Session tracing
and tkprof can be used to see exactly what is happening on the
database, enabling the DBA to take corrective action.
- At times, viewing SQL that is being executed for an
application will be the only mechanism a DBA will have. These
situations arrive during the execution of encrypted PL/SQL code on
the database or submission of SQL statements from third party
applications.
Also read
A data block is the smallest unit of logical storage for a
database object. As objects grow they take chunks of additional
storage that are composed of contiguous data blocks.............
Data pump export and import modes are used to determine the type
and portions of database to be exported and imported:...............
A Sequence is a user created database object. A sequence can be
shared by multiple users to generate unique integers. This object is
used to create a primary key value...............
Schema represents structure of the database. Database has two
main types of schemas partitioned : Physical schema: Describes the
database design at the physical level..............
|
