你的数据库使用了哪些特性?
Oracle10g中增加了一张叫做DBA_FEATURE_USAGE_STATISTICS的视图，只要你使用过的一些特性都会记录下来，而且这些信息可能在一些trace文件比如RDA收集的结果中存在，没买license而使用了这些特性的要注意了。不过透过这个视图，也能了解到系统的很多情况，或许很多东西都是作为DBA的你都不曾注意到的吧，呵呵
SQL> select name,detected_usages as "usage",currently_used,first_usage_date,last_usage_date 2 from dba_feature_usage_statistics; NAME usage CURRE FIRST_USAGE_ LAST_USAGE_D -------------------------------------------------- ---------- ----- ------------ ------------ Protection Mode - Maximum Availability 0 FALSE Protection Mode - Maximum Performance 36 TRUE 04-FEB-08 06-OCT-08 Protection Mode - Maximum Protection 0 FALSE Protection Mode - Unprotected 0 FALSE Real Application Clusters (RAC) 0 FALSE Recovery Area 0 FALSE Recovery Manager (RMAN) 32 TRUE 03-MAR-08 06-OCT-08 RMAN - Disk Backup 32 TRUE 03-MAR-08 06-OCT-08 RMAN - Tape Backup 0 FALSE Resource Manager 0 FALSE Segment Advisor 34 TRUE 18-FEB-08 06-OCT-08 Server Parameter File 36 TRUE 04-FEB-08 06-OCT-08 Undo Advisor 0 FALSE Virtual Private Database (VPD) 0 FALSE Shared Server 0 FALSE Spatial 0 FALSE SQL Access Advisor 0 FALSE SQL Tuning Advisor 0 FALSE SQL Tuning Set 0 FALSE Standby Archival - LGWR 23 TRUE 17-MAR-08 06-OCT-08 Standby Archival - ARCH 9 FALSE 03-MAR-08 12-MAY-08 Standby Transmission 32 TRUE 03-MAR-08 06-OCT-08 Streams (system) 36 TRUE 04-FEB-08 06-OCT-08 Streams (user) 0 FALSE Transparent Gateway 0 FALSE Advanced Replication 0 FALSE Advanced Security 0 FALSE Audit Options 0 FALSE Automatic Database Diagnostic Monitor 0 FALSE Automatic Segment Space Management (system) 36 TRUE 04-FEB-08 06-OCT-08 Automatic Segment Space Management (user) 36 TRUE 04-FEB-08 06-OCT-08 Automatic SQL Execution Memory 36 TRUE 04-FEB-08 06-OCT-08 Automatic Storage Manager 0 FALSE Automatic Undo Management 36 TRUE 04-FEB-08 06-OCT-08 Automatic Workload Repository 0 FALSE Change-Aware Incremental Backup 0 FALSE Client Identifier 0 FALSE CSSCAN 0 FALSE Character Semantics 0 FALSE Character Set 36 TRUE 04-FEB-08 06-OCT-08 Data Guard 32 TRUE 03-MAR-08 06-OCT-08 Data Guard Broker 0 FALSE Data Mining 0 FALSE Dynamic SGA 0 FALSE File Mapping 0 FALSE Flashback Database 0 FALSE Internode Parallel Execution 0 FALSE Label Security 0 FALSE Locally Managed Tablespaces (system) 36 TRUE 04-FEB-08 06-OCT-08 Locally Managed Tablespaces (user) 36 TRUE 04-FEB-08 06-OCT-08 Messaging Gateway 0 FALSE MTTR Advisor 21 FALSE 04-FEB-08 23-JUN-08 Multiple Block Sizes 0 FALSE OLAP - Analytic Workspaces 0 FALSE OLAP - Cubes 0 FALSE Oracle Managed Files 0 FALSE Parallel SQL DDL Execution 2 FALSE 17-MAR-08 24-MAR-08 Parallel SQL DML Execution 0 FALSE Parallel SQL Query Execution 26 TRUE 14-APR-08 06-OCT-08 Partitioning (system) 36 TRUE 04-FEB-08 06-OCT-08 Partitioning (user) 32 TRUE 03-MAR-08 06-OCT-08 PL/SQL Native Compilation 0 FALSE SQL> select * from v$version; BANNER ---------------------------------------------------------------- Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi PL/SQL Release 10.2.0.3.0 - Production CORE 10.2.0.3.0 Production TNS for IBM/AIX RISC System/6000: Version 10.2.0.3.0 - Productio NLSRTL Version 10.2.0.3.0 - Production
Oracle10g新特性：Language and Character Set File Scanner(LCSSCAN)
Oracle10gR1引入了一个叫做Language and Character Set Detection (LCSD) 的新特性，可以快速高效的确定一个文件中的字符所适用的字符集。LCSD可以通过Oracle提供的GDK(Globalization Development Kit) java API接口调用。基于该特性，Oracle也提供了一个命令行工具LCSSCAN(Language and Character Set File Scanner)。从Oracle10gR2开始该工具还支持对HTML文件的扫描。
LCSSCAN的语法很简单，基本上一看就会使用：
D:\>lcsscan help
Language and Character Set File Scanner v2.1
(c) Copyright 2003, 2004 Oracle Corporation. All rights reserved.
You can control how LCSSCAN runs by entering the LCSSCAN command
followed by the required parameters. To specify parameters, you use
keywords:Example: LCSSCAN RESULTS=2 END=1000 FORMAT=HTML FILE=index.html
Keyword Description (Default)
——————————————————————–
RESULTS number of language and character set pairs to return (1)
BEGIN beginning byte offset of file (1)
END ending byte offset of file (end of file)
FORMAT file format TEXT, HTML or AUTO detect (TEXT)
FILE name of input file
HELP show help screen (this screen)
FILE就是要扫描的文件，BEGIN和END则指定只扫描文件的部分内容。RESULTS指明要返回几组可用的结果，因为一个文件可能兼容于多种字符集。FORMAT指明文件的类型。
D:\>lcsscan file=test.txt
Language and Character Set File Scanner v2.1
(c) Copyright 2003, 2004 Oracle Corporation. All rights reserved.
test.txt: SIMPLIFIED CHINESE ZHS16CGB231280;
