Globalization Development Kit
The Globalization Development Kit (GDK) makes it easier to develop multilingual applications.
Accent- and case-insensitive queries
Oracle Database 10g supports queries that ignore accent marks and/or case.
Increased CLOB size
A CLOB or NCLOB can now hold up to 128 terabytes of data.
SCN pseudocolumn
A new pseudocolumn, ORA_ROWSCN, holds the System Change Number (SCN) for the last transaction that changed the row.
Expression filter
This filter allows a complex expression to be stored as part of a row. You can use the EVALUATE function to evaluate the expression and to limit rows returned in queries based on the evaluation.
No recompilation of PL/SQL needed for synonym changes
If you change the location referenced by a synonym, you no longer have to recompile PL/SQL procedures that use the synonym.
Sorted hash clusters
These clusters save information in a hash cluster in the order it was added.
Automatic statistics collection
In Oracle Database 10g, statistics collection for the cost-based optimizer can be automated.
Rule-based optimizer de-supported
The rule-based optimizer is no longer supported in Oracle Database 10g.
I/O statistics
The cost-based optimizer now uses CPU and I/O statistics.
SQL Tuning Advisor
This tool collects additional statistics, which are then stored and used by the cost-based optimizer to create a better execution plan.