Oracle Database 10g is the premiere Grid Computing enabled database.
It enables us in monitoring normal transactions recovered by SMON. It also provides the facility of viewing the historical information about transaction recovery and transaction rollback. Also, Oracle 10g pre-configures objects for maximum concurrency
The configuration of shared servers and their connected dispatchers has been made dynamic..
To aid self-management and auto tuning of the database, Oracle supports a persistent store called automatic workload repository (AWR), which collects memory statistics, and the automatic database diagnostic monitor (ADDM). It monitors and analyzes statistics and provides advisory services. Simplified Statistics Collection The 10g version provides the facility of analyzing both the real and fixed dictionary tables, in order to get better performance. There are several new procedures that have been introduced to streamline and simplify the compute statistics operation of dictionary objects. Response File Creation during Database Installation With Oracle Database 10g we get the benefit of true silent capability. When running OUI in silent mode on a character mode console, we no longer need to specify an X-server or set the Display environment variable on UNIX. No GUI classes are instantiated.