|
About
911 TKO:
The 911 TKO
gives you unprecedented access to the internal structures of
your database. Written by a graduate of M.I.T. and a
former member of the Oracle Kernel Group, the 911 TKO copyrighted
technology within 911 TKO gives you insights into your Oracle
internal block structures for any table or index.
911 TKO allows database administrators and applications
developers the ability to view the actual on disk data
structures Oracle uses to store tables, clusters, indices, and
rollback segments. These structures can either be viewed via a
graphical browsing tool or the relevant data can be extracted
into meta-tables for further analysis via standard SQL queries.
By better understanding how Oracle stores information on disk,
database administrators can increase both application
performance as well as space efficiency.
911 TKO
Features
911 TKO is
designed especially for managing and repairing data blocks
within Oracle database environments.
Graphical Browsing
By using the .NET based graphical browsing tool on XP, users can
directly navigate and view important structures on disk such as
Row Chains.
You can also answer important DBA questions:
- At what column is the row fractured?
- Is the row fractured in the middle of a column?
- Would the row fit in a single block if it were deleted and
re-inserted?
Space Management
911 TKO
is give you a fast visual interface into your tablespace and
block structures allow you to answer important space management
questions:
- How much contiguous space is currently available in the block?
- How much space would be available is block was recompressed
and deleted rows removed?
- Is the block available for the insertion of new rows, that is,
is it on a free list?
Corrupt Block Checking
Users can determine if a block is corrupted, by comparing the
check value placed in the foot of the block with the values
recorded in the head of the block.
Direct Read from SGA or Data Files
Blocks can be read directly from the Oracle buffer cache or from
the data files on disk.
Field Level Display
Each of the fields can be cycled to display either the decimal
value, hexadecimal value, text value, or, if it is actual column
data stored in Oracle format, the tool will display the data
converted to a string via the appropriate data type converter.
Each of the fields also has a property sheet which contains,
among other things, a short description of the field as well as
a hyperlink into the extensive documentation explaining
precisely how Oracle uses the field.
Before and After Image
By using the graphical tool, the user can compare a before and
after image of a block after a known operation. For example, a
user can update a text column to contain a wider value than
before and use the before and after image comparison tool to
readily observe how Oracle handled the expansion of the row.
- Did the update cause the row to chain?
- Did the update cause Oracle to repack the entire block to allow
the larger row to fit?
- Did the update cause any gaps to occur in the row packing which
could lead to space inefficiency?
Meta-tables
Although Oracle’s data dictionary tables are quite extensive
they do not provide any meta-data, that is data on the data. For
example, we provide views that Oracle does not to answer
questions such as:
- select the sum of all space occupied by deleted rows
- select all blocks that are not on a free list with available
space greater than a particular threshold
- select all rowids that are chained where the total size of the
row is less than can fit in a block
- select the percentage of keys in an index that are at a level
greater than 3
These questions can help an administrator determine the amount
of space that may be recovered if the table were to be
recreated. They may also help determine if the recreation of an
unbalanced index might produce more consistent lookup times. In
a table with a moderate amount of update and delete activity, an
administrator could determine if space could be better utilized
by raising PCTUSED.
Meta-tables can
also be used to determine the
number of transaction table entries that are used on a per block
basis. If the object was going to be recreated, this can be
useful in determining the most appropriate values for INITTRANS
and MAXTRANS.
Extensive Documentation of Oracle Internals
911 TKO comes with extensive documentation on the internal
workings of the Oracle RDBMS not provided by any vendor
including Oracle. This document not only makes for educational
reading from top to bottom but also every field in the block
format is linked directly into the browsing tool for ready
access.
WARNING:
911 TKO is designed specifically for use by senior Oracle DBA tuning
professionals and is not suitable for beginners.
|
