Oracle Automated Shared Memory Management is a new feature introduced in Oracle 10g Databases. In 10g you specify SGA_TARGET instead of the older methods of setting the initialization parameters such as SHARED_POOL_SIZE, DB_CACHE_SIZE. This allows for Automatic Database Performance tuning in Oracle Databases

Oracle 10g provides a multitude of new features that allow better performance monitoring and management. The content below give you a high level overview of the Performance Management Features and we will cover each of them in detail in the coming weeks

Oracle recently announced 10G express database edition with a lot of fanfare. This edition of Oracle 10g (Oracle Database XE) is an entry-level, small-footprint database based on the Oracle Database 10g Release 2 code base that's free to develop, deploy, and distribute.There are no database license costs associated with developing applications for Oracle Database XE which offers the complete integrated set of Oracle Database programming interfaces including SQL, PL/SQL, Java, C, and PHP, Windows .Net, Oracle HTML DB, C++, ODBC, OLE DB

Introduction of Oracle Table Compression since Oracle 9i has allowed the compression of Tables, Partitions and Materialized views. This feature targeted at OLAP and Warehousing applications allows for drastic reduction in disk space and memory requirements when used appropriately.

Oracle 10g introduces a lighter weight database client called Oracle Instant Client. Oracle Instant client allows you to get away from the standard Oracle Client installation for running applications from desktops or Servers. All applications that need OCI, Pro*C, ODBC, and JDBC will work without any issues and this client takes significantly less disk space than a full 10g client.