(Alf Pedersen) Oracle indexes : Proper database indexing is a crucial factor for the database performance. Most Oracle databases have hundreds or even thousands of indexes. This large number of indexes and their complexity make index tuning and monitoring a difficult task for the DBA.

(Patrick Sinke) Assume you have a table with contaminated data (in this example: non-unique values on col1 and col2), for instance because no unique key was implemented.

(Lydia Parziale, Kathryn Arrell, Dennis Dutcavich, Terry Elliott, Bruce Frank and Erik Kane) This IBM Redbook describes experiences gained while installing and testing several Oracle solutions, such as: – Single Instance of Oracle Database 10gR2 – Including sharing ORACLE_HOME and Cloning Oracle

(David Baum) In a new vision for business intelligence (BI), all employees in an organization become potential decision-makers, whether they work in customer service, shipping, manufacturing, finance, human resources, or just about any other department. Companies with this vision are delivering anal

(Sam Alapati) Oracle Application Server 10g provides support for Java 2 Platform, Enterprise Edition (J2EE) applications, and support for J2EE is a crucial and integral part of Oracle Application Server 10g. This chapter is devoted to explaining how J2EE applications work and how the OracleAS compon

(Mark Brunelli) The new version of Oracle’s TimesTen embeddable database is designed to give enterprises in financial, telecommunications and other high-volume markets quicker throughput and speedier response times. (R)

(Bob Watkins) One thing that Oracle DBAs know for a fact is that a transaction isn’t committed until it is written to the online redo log files. If a COMMIT statement in an application completes, the application can trust that the data is protected against instance failure, and can be recovered by ”

(Roger Schrag) When a sort operation is too large to fit in memory, Oracle allocates space in a temporary tablespace in order to write data off to disk. Temporary space is a resource shared by multiple sessions on the database, and quotas cannot be set to limit how much temporary space can be used b

(Brian Peasland) We want to plan an incremental backup on Oracle 9i with RMAN. How can I detemine the levels of incremental backups? In other words, when do I use level 2 or 3 or 4 or 000 or 9? (R)

Information Security has changed radically in the last decade, and is more important today than it has ever been in the past. Security has become more visible as a business issue across all industries and affecting organizations of all sizes. In the current environment a security breach has the pote