oracle的字符集檢查工具CSSCAN(二)
SCAN.TXT 檔案的內容：
Database Scan Summary Report
Time Started : 2011-03-14 12:22:16
Time Completed: 2011-03-14 12:22:59
Process ID Time Started Time Completed
---------- -------------------- --------------------
1 2011-03-14 12:22:47 2011-03-14 12:22:58
2 2011-03-14 12:22:48 2011-03-14 12:22:58
---------- -------------------- --------------------
[Database Size]
Tablespace Used Free Total Expansion
------------------------- --------------- --------------- --------------- ---------------
SYSTEM 750.50M 419.50M 1,170.00M .00K
SYSAUX 629.81M 32.06M 661.88M .00K
UNDOTBS1 56.31M 23.69M 80.00M .00K
TEMP .00K .00K .00K .00K
USERS 508.00M 723.25M 1,231.25M 3.00K
EXAMPLE 77.69M 222.31M 300.00M .00K
------------------------- --------------- --------------- --------------- ---------------
Total 2,022.31M 1,420.81M 3,443.13M 3.00K
[Database Scan Parameters]
Parameter Value
------------------------------ ------------------------------------------------
CSSCAN Version v2.1
Instance Name oracl
Database Version 11.1.0.6.0
Scan type User tables
User name yang
Scan CHAR data? YES
Database character set ZHS16GBK
FROMCHAR ZHS16GBK
TOCHAR al32utf8
Scan NCHAR data? NO
Array fetch buffer size 104000
Number of processes 2
Capture convertible data? NO
------------------------------ ------------------------------------------------
[Scan Summary]
Some character type application data are not convertible to the new character set
[Data Dictionary Conversion Summary]
Data Dictionary Tables:
Datatype Changeless Convertible Truncation Lossy
--------------------- ---------------- ---------------- ---------------- ----------------
VARCHAR2 0 0 0 0
CHAR 0 0 0 0
LONG 0 0 0 0
CLOB 0 0 0 0
VARRAY 0 0 0 0
--------------------- ---------------- ---------------- ---------------- ----------------
Total 0 0 0 0
Total in percentage 0.000% 0.000% 0.000% 0.000%
XML CSX Dictionary Tables:
Datatype Changeless Convertible Truncation Lossy
--------------------- ---------------- ---------------- ---------------- ----------------
VARCHAR2 0 0 0 0
CHAR 0 0 0 0
LONG 0 0 0 0
CLOB 0 0 0 0
VARRAY 0 0 0 0
--------------------- ---------------- ---------------- ---------------- ----------------
Total 0 0 0 0
Total in percentage 0.000% 0.000% 0.000% 0.000%
[Application Data Conversion Summary]
Datatype Changeless Convertible Truncation Lossy
--------------------- ---------------- ---------------- ---------------- ----------------
VARCHAR2 43,502,802 51 0 0
CHAR 747 0 499 0
LONG 0 0 0 0
CLOB 0 0 0 0
VARRAY 0 0 0 0
--------------------- ---------------- ---------------- ---------------- ----------------
Total 43,503,549 51 499 0
Total in percentage 99.999% 0.000% 0.001% 0.000%
[Distribution of Convertible, Truncated and Lossy Data by Table]
Data Dictionary Tables:
USER.TABLE Convertible Truncation Lossy
-------------------------------------------------- ---------------- ---------------- ----------------
-------------------------------------------------- ---------------- ---------------- ----------------
XML CSX Dictionary Tables:
USER.TABLE Convertible Truncation Lossy
-------------------------------------------------- ---------------- ---------------- ----------------
-------------------------------------------------- ---------------- ---------------- ----------------
Application Data:
USER.TABLE Convertible Truncation Lossy
-------------------------------------------------- ---------------- ---------------- ----------------
YANG.A 1 0 0
YANG.FIXED 0 499 0
YANG.TCHAR 49 0 0
YANG.TEST_CHAR 1 0 0
-------------------------------------------------- ---------------- ---------------- ----------------
[Distribution of Convertible, Truncated and Lossy Data by Column]
Data Dictionary Tables:
USER.TABLE|COLUMN Convertible Truncation Lossy
-------------------------------------------------- ---------------- ---------------- ----------------
-------------------------------------------------- ---------------- ---------------- ----------------
XML CSX Dictionary Tables:
USER.TABLE|COLUMN Convertible Truncation Lossy
-------------------------------------------------- ---------------- ---------------- ----------------
-------------------------------------------------- ---------------- ---------------- ----------------
Application Data:
USER.TABLE|COLUMN Convertible Truncation Lossy
-------------------------------------------------- ---------------- ---------------- ----------------
YANG.A|VAL 1 0 0
YANG.FIXED|VAL2 0 499 0
YANG.TCHAR|VAL 49 0 0
YANG.TEST_CHAR|V 1 0 0
-------------------------------------------------- ---------------- ---------------- ----------------
[Indexes to be Rebuilt]
USER.INDEX on USER.TABLE(COLUMN)
-----------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------
[Truncation due to codepoint semantic]
USER.TABLE|COLUMN Truncation
-------------------------------------------------- ----------------
YANG.TEST_CHAR|V 1
-------------------------------------------------- ----------------
Database Scan Summary Report
Time Started : 2011-03-14 12:22:16
Time Completed: 2011-03-14 12:22:59
Process ID Time Started Time Completed
---------- -------------------- --------------------
1 2011-03-14 12:22:47 2011-03-14 12:22:58
2 2011-03-14 12:22:48 2011-03-14 12:22:58
---------- -------------------- --------------------
[Database Size]
Tablespace Used Free Total Expansion
------------------------- --------------- --------------- --------------- ---------------
SYSTEM 750.50M 419.50M 1,170.00M .00K
SYSAUX 629.81M 32.06M 661.88M .00K
UNDOTBS1 56.31M 23.69M 80.00M .00K
TEMP .00K .00K .00K .00K
USERS 508.00M 723.25M 1,231.25M 3.00K
EXAMPLE 77.69M 222.31M 300.00M .00K
------------------------- --------------- --------------- --------------- ---------------
Total 2,022.31M 1,420.81M 3,443.13M 3.00K
[Database Scan Parameters]
Parameter Value
------------------------------ ------------------------------------------------
CSSCAN Version v2.1
Instance Name oracl
Database Version 11.1.0.6.0
Scan type User tables
User name yang
Scan CHAR data? YES
Database character set ZHS16GBK
FROMCHAR ZHS16GBK
TOCHAR al32utf8
Scan NCHAR data? NO
Array fetch buffer size 104000
Number of processes 2
Capture convertible data? NO
------------------------------ ------------------------------------------------
[Scan Summary]
Some character type application data are not convertible to the new character set
[Data Dictionary Conversion Summary]
Data Dictionary Tables:
Datatype Changeless Convertible Truncation Lossy
--------------------- ---------------- ---------------- ---------------- ----------------
VARCHAR2 0 0 0 0
CHAR 0 0 0 0
LONG 0 0 0 0
CLOB 0 0 0 0
VARRAY 0 0 0 0
--------------------- ---------------- ---------------- ---------------- ----------------
Total 0 0 0 0
Total in percentage 0.000% 0.000% 0.000% 0.000%
XML CSX Dictionary Tables:
Datatype Changeless Convertible Truncation Lossy
--------------------- ---------------- ---------------- ---------------- ----------------
VARCHAR2 0 0 0 0
CHAR 0 0 0 0
LONG 0 0 0 0
CLOB 0 0 0 0
VARRAY 0 0 0 0
--------------------- ---------------- ---------------- ---------------- ----------------
Total 0 0 0 0
Total in percentage 0.000% 0.000% 0.000% 0.000%
[Application Data Conversion Summary]
Datatype Changeless Convertible Truncation Lossy
--------------------- ---------------- ---------------- ---------------- ----------------
VARCHAR2 43,502,802 51 0 0
CHAR 747 0 499 0
LONG 0 0 0 0
CLOB 0 0 0 0
VARRAY 0 0 0 0
--------------------- ---------------- ---------------- ---------------- ----------------
Total 43,503,549 51 499 0
Total in percentage 99.999% 0.000% 0.001% 0.000%
[Distribution of Convertible, Truncated and Lossy Data by Table]
Data Dictionary Tables:
USER.TABLE Convertible Truncation Lossy
-------------------------------------------------- ---------------- ---------------- ----------------
-------------------------------------------------- ---------------- ---------------- ----------------
XML CSX Dictionary Tables:
USER.TABLE Convertible Truncation Lossy
-------------------------------------------------- ---------------- ---------------- ----------------
-------------------------------------------------- ---------------- ---------------- ----------------
Application Data:
USER.TABLE Convertible Truncation Lossy
-------------------------------------------------- ---------------- ---------------- ----------------
YANG.A 1 0 0
YANG.FIXED 0 499 0
YANG.TCHAR 49 0 0
YANG.TEST_CHAR 1 0 0
-------------------------------------------------- ---------------- ---------------- ----------------
[Distribution of Convertible, Truncated and Lossy Data by Column]
Data Dictionary Tables:
USER.TABLE|COLUMN Convertible Truncation Lossy
-------------------------------------------------- ---------------- ---------------- ----------------
-------------------------------------------------- ---------------- ---------------- ----------------
XML CSX Dictionary Tables:
USER.TABLE|COLUMN Convertible Truncation Lossy
-------------------------------------------------- ---------------- ---------------- ----------------
-------------------------------------------------- ---------------- ---------------- ----------------
Application Data:
USER.TABLE|COLUMN Convertible Truncation Lossy
-------------------------------------------------- ---------------- ---------------- ----------------
YANG.A|VAL 1 0 0
YANG.FIXED|VAL2 0 499 0
YANG.TCHAR|VAL 49 0 0
YANG.TEST_CHAR|V 1 0 0
-------------------------------------------------- ---------------- ---------------- ----------------
[Indexes to be Rebuilt]
USER.INDEX on USER.TABLE(COLUMN)
-----------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------
[Truncation due to codepoint semantic]
USER.TABLE|COLUMN Truncation
-------------------------------------------------- ----------------
YANG.TEST_CHAR|V 1
-------------------------------------------------- ----------------
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/22664653/viewspace-689376/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- 【TUNE_ORACLE】Oracle檢查點（二）檢查點效能Oracle
- 【TUNE_ORACLE】Oracle健康檢查基礎專案（二）專案檢查步驟概述其一Oracle
- 【TUNE_ORACLE】Oracle健康檢查基礎專案（三）專案檢查步驟概述其二Oracle
- Oracle 檢查點涉及的SCNOracle
- 【TUNE_ORACLE】Oracle檢查點（一）檢查點（Checkpoint）概念介紹Oracle
- Oracle 字符集修改Oracle
- Oracle完全檢查點和增量檢查點詳解Oracle
- oracle資料庫sql查詢檢視第二次查詢很慢Oracle資料庫SQL
- 【TUNE_ORACLE】Oracle檢查點（五）建立並利用Statspack定位檢查點故障Oracle
- 【BUILD_ORACLE】Oracle 19c RAC搭建（二）作業系統檢查與配置UIOracle作業系統
- 【SQL】Oracle SQL共享池檢查SQLOracle
- Oracle SCN健康狀態檢查Oracle
- Oracle物化檢視的建立及使用（二）Oracle
- 【TUNE_ORACLE】Oracle檢查點（三）增量檢查點四個關鍵引數介紹Oracle
- 【BAK_ORACLE】Oracle DB Cloud上的備份檢查命令合集OracleCloud
- 【PDB】Oracle跨PDB檢視查詢Oracle
- 【SCN】Oracle檢查scn值指令碼Oracle指令碼
- 【TUNE_ORACLE】Oracle健康檢查基礎專案（四）專案檢查步驟概述其三Oracle
- JS程式碼檢查工具ESLintJSEsLint
- CSS程式碼檢查工具stylelintCSS
- MySQL檢視和修改字符集的方法MySql
- 【TUNE_ORACLE】Oracle檢查點（四）檢查點對redo日誌的影響和redo日誌大小設定建議Oracle
- android 程式碼質量檢查工具Android
- java 程式碼編譯檢查工具Java編譯
- Oracle RAC一鍵部署002(引數檢查)Oracle
- 10 Oracle跑批慢常用檢查手冊Oracle
- [JVM工具(1)] 堆疊檢查利器jstat的使用JVMJS
- 修改Oracle資料庫字符集(zt)Oracle資料庫
- 【SQL】Oracle查詢轉換之物化檢視查詢重寫SQLOracle
- python程式碼檢查工具(靜態程式碼審查)Python
- 【TUNE_ORACLE】Oracle健康檢查基礎專案（一）專案列表Oracle
- 覆蓋率檢查工具：JaCoCo 食用指南
- Invisor for Mac(媒體檔案檢查工具)Mac
- Invisor for Mac媒體檔案檢查工具Mac
- Oracle OCP(14)：使用子查詢檢索資料Oracle
- 【CHECKPOINT】Oracle檢查點優化與故障處理Oracle優化
- 【SQL】Oracle查詢轉換之檢視合併SQLOracle
- ABAP的許可權檢查跟蹤(Authorization trace)工具
- 健康檢查，檢查啥，怎麼檢查？