 |
|
Oracle Tips by Burleson |
Oracle 10g The Distribution of Convertible Data Per
Table Report
The distribution of convertible data per table
report section shows how Convertible, Truncation, and Lossy data is
distributed within the source database. This report can be quite
lengthy, since the statistics are reported by table. If the list
contains only a few rows, that is, it involves only a couple of
tables, then the Convertible data is localized. If the list contains
a bunch of rows, then the Convertible data is spread throughout the
database.
[Distribution
of Convertible and Exceptional Data per Table]
USER.TABLE
Convertible Truncation Lossy
------------------ ------------ ----------------
----------------
DMSYS.DM$PMML_DTD 1 0
0
SYS.METASTYLESHEET 80 0
0
SYS.RULE$ 4 0
0
SYS.SOURCE$ 0 0
1
------------------ ------------ ----------------
----------------
The next report section deals with the
distribution of convertible data per column.
The
Distribution of Convertible Data Per Column Report
This section shows how Convertible, Truncation,
and Lossy data are distributed within the database by table and
column. The statistics are reported by table and the column within
the table that contains the questionable data.
[Distribution
of Convertible and Exceptional Data per Column]
USER.TABLE|COLUMN Convertible Truncation
Lossy
-------------------- ---------------- ----------------
----------------DMSYS.DM$PMML_DTD|DTD 1
0 0
SYS.METASTYLESHEET|STYLESHEET 80
0 0
SYS.RULE$|CONDITION 4
0 0
SYS.SOURCE$|SOURCE 0
0 1
---------------------- ---------------- ----------------
----------------
The last report deals with indexes that may
have to be rebuilt because of the translation from one character set
to another.
Get the complete Oracle10g story:
To get the code instantly, click here:
|
|
|
Need an Oracle Health Check?
Does your boss blame you for an Oracle performance problem?
Need to prove that your database is properly optimized?
BC Oracle performance guru's can quickly verify every aspect of your
Oracle database and provide a complete certification that your database
is fully optimized. |
|
|
