Mike Ault eBooks

Setting Up for Use of Outlines,Installing OUTLN Schema 'After the Fact'. Script to Install OUTLN Schema, General Facts about OUTLN Schema, Requirements for OUTLINE Use.Some General Usage Notes:Views Used With OUTLINES,Packages Used with OUTLINEs,Plan Stability, Creation of a OUTLINE object.Altering a OUTLINE. Dropping an OUTLINE. Use of the OUTLN_PKG To Manage SQL Stored Outlines. DROP_UNUSED. DROP_BY_CAT. UPDATE_BY_CAT. New Procedures for Oracle9i:Manually Editing Plans, Using DML and Packages to Edit Outlines.A Detailed Example: Using DBMS_OUTLN_EDIT.GENERATE_SIGNATURE,Replacing a Non-Hinted Outline,Technique. Example. Moving OUTLINES from One DB to Another....

Invoking Oradebug Using Debug Monitoring the Current Session With the oradebug setmypid Using DUMP Commands not requiring SPID to be set Using Oradebug for System Hangs: Getting a PROCESSTATE DUMP Getting a ERRORSTACKS DUMP Using ORADEBUG to Trace A Sessions SQL How to Find the Right PID for oradebug setospid Tracing Errors Using ORADEBUG Using ORADEBUG to Find Semaphore and Memory Segments Finding Parallel SQL Processes Using ORADEBUG Tracking down ORA-04030 errors Using Oradebug to Debug Spinning Processes Oracle IDLM and ORADEBUG How to determine the Events Set in a System Using ORADEBUG to Release DDL locks How to Trace Trigger Actions Using Oradebug Checking on Temporary Segment Usage with Oradebug Suspending a process...

Many times the Oracle DBA is hired once the database becomes to much to handle without one, inherits the position or is appointed to it since they are so good with computers. In any case, the usually gen an undocumented system that follows no conventions and holds many traps for the unwary DBA....

Database Administration has grown over the years from the mere management of a few tables and indexes to a complex interlocking set of responsibilities ranging from managing database objects to participating in enterprise wide decisions on hardware, software and development tools. In order to fully perform these functions the modern Oracle DBA needs a large skill set. Over the next few hours we will discuss the skills needed and specifically how they apply to an Oracle DBA....

This fantastic eBook discusses how to tune data warehouse applications and includes a discussion of the dbms_summary package, bitmap indexes, and other critical data warehouse techniques....