Oracle Essentials [Electronic resources] : Oracle Database 10g, 3rd Edition نسخه متنی

A.4 Chapter 4, Data Structures

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.