James Koopmann

Eight Reasons Why Oracle's Acquisition of Sun isn't All Bad - March 10, 2010
Oracle Database Archive Logging -- Where are my archive logs? - March 4, 2010
Pay Attention to your Oracle Database Archive Logging Function - February 16, 2010
When Tuning Oracle is not an Option - February 4, 2010
Oracle Invisible Indexes and Index Usability - August 6, 2009
Getting Ready for Oracle Flashback Database - July 14, 2009
Oracle Flashback Version Query—Trick or Trap - July 2, 2009
Oracle’s Flashback Query - TIMESTAMP or SCN? - June 18, 2009
Oracle’s Flashback Query – Should you unset _in_memory_undo? - June 4, 2009
Failures within Your UNDO Tablespace-When do they occur? - May 19, 2009
Is Your UNDO Tablespace Prepared for Oracle’s Flashback Technology? - May 7, 2009
Oracle Flash – What is it? - April 2, 2009
HiT Software’s DBMoto 6.5 - March 19, 2009
Inter-process communication with DBMS_ALERT - March 17, 2009
Modeling Oracle Time - March 5, 2009
Looking at your operating system with the help of Oracle's V$OSSTAT view - February 5, 2009
What Is Your Definition of Database Workload? - January 8, 2009
So what is an Oracle Nested Table? - December 4, 2008
DBA Call to Action: How You Do What You Do - September 10, 2008
Looking at Memory Usage for Oracle Processes - July 3, 2008
Oracle Database 11g – Common Background Processes - June 5, 2008
Create your own reports with Oracle’s Snapshot Information - May 1, 2008
Oracle Library Cache—Part II - January 3, 2008
Oracle Library Cache—Part I - December 20, 2007
Oracle’s Transportable Automatic Workload Repository - September 13, 2007
RMAN Disk to Disk Backup Methods - July 30, 2007
Handling NULLS in SQL statements - July 6, 2007
A View of Creating an Oracle User - Part II - June 16, 2005
A View of Creating an Oracle User - Part I - June 2, 2005
Oracle and Regular Expressions - May 5, 2005
Making a Connection from Oracle to SQL Server - December 3, 2004
Clustering for Indexes - November 4, 2004
Sending e-mail from within Oracle - October 21, 2004
Oracle 10g's Undo Advisor - October 7, 2004
DBA Call to Action: Get up and GO - September 10, 2004
Automate the Sizing of your SGA in Oracle 10g - September 2, 2004
Oracle 10g's Redo Logfile Sizing Advisor - August 24, 2004
Introduction to Oracle 10g's New SQLAccess Advisor - August 13, 2004
True Session Wait Activity in Oracle 10g - August 5, 2004
Introduction to Oracle 10g's New SQL Tuning Advisor - July 29, 2004
Watching SQL Execute on Oracle - Part II - July 9, 2004
Watching SQL Execute on Oracle - Part I - July 1, 2004
Instant Client in Oracle 10g - June 29, 2004
Executing External Programs From Within Oracle - June 11, 2004
New Features in Oracle 10g for SQL*Plus and iSQL*Plus - June 3, 2004
Multiple Temporary Tablespaces in Oracle 10g - May 14, 2004
Transferring Operating System Files from within Oracle - May 6, 2004
Data Modeling, Breaking & Fixing First Normal Form (1NF) - April 9, 2004
DBA Call to Action: Zeroing in on Performance Problems - February 13, 2004
Storing Word Documents in Oracle - February 5, 2004
Manipulating Oracle Files with UTL_FILE - January 9, 2004
DBA Call to Action: New Year Resolutions - January 2, 2004
Creating a Database in PostgreSQL - November 25, 2003
Oracle9iR2 Segment Level Statistics - November 14, 2003
Oracle9iR2 Shared Pool Advisory - November 6, 2003
An instance by any other name is still an instance...or is it - October 29, 2003
Oracle's Default TEMPORARY Tablespaces - October 10, 2003
DBA Call to Action: Oracle Database Integrity - September 25, 2003
Between the Software and the Database - September 23, 2003
Oracle Time Zone - September 12, 2003
What's In A Name - Naming and Idenifying Oracle Databases and Instances - September 4, 2003
PostgreSQL Software Installation - August 21, 2003
Tracking Data Access Patterns in Oracle - August 8, 2003
Oracle PL/SQL Built For Speed - August 7, 2003
Getting Started With PostgreSQL - July 18, 2003
A Comparison of Oracle's DATE and TIMESTAMP Datatypes - July 14, 2003
Oh Danny Boy, The DBMS_PIPES Are Calling - July 10, 2003
The Road from Oracle8i to Oracle9i Certification - July 3, 2003
Returning Rows Through a Table Function in Oracle - June 19, 2003
Altering Oracle's SQL*Plus Help Facility - June 4, 2003
So You Want to Use Oracle's SPFILE - May 30, 2003
DBA Call to Action: Make an Impact - May 15, 2003
DDL Generation--Oracle's Answer to Save You Time and Money - May 1, 2003
Database Impact of Collecting Statistics in Oracle - April 11, 2003
Implications of Setting Oracle9iR2's Statistics Collection Level - April 2, 2003
Hold On There SYSter - March 19, 2003
Explain Away Your Troubles - March 6, 2003
DBA Call to Action: The Information Chase - February 21, 2003
Killing the Oracle DBMS_JOB - February 6, 2003
Oracle9i's Auto Segment Space Management Option - January 30, 2003
That Darn Alert Log - January 23, 2003
Database Performance and some Christmas Cheer - January 2, 2003
Remote Procedure Calls Will Get You the Cheese - December 10, 2002

Oracle 11g Security – Guidelines for Auditing
Creating a standard audit trail in Oracle Database 11g
Setting default auditing as recommended by Oracle
Getting started with standard auditing in Oracle Database 11g
Secure Sockets Layer and Oracle 11g Security
Securing Client Connections: OS Authentication
Securing Oracle Database Client Connections
Explicit GRANTs and ROLES in Oracle Database 11g
Oracle 11g Object privileges and synonym usage
Oracle 11g Security – The Power of PROFILES
Oracle 11g Security – Those Pesky Predefined Accounts
Oracle 11g Security – Securing the Data Dictionary
Oracle 11g Security – Enabling default security settings

Part 4 - Oracle Health Checks with Health Monitor; Using PL/SQL or ADR
Part 3
Part II
Part I

Measuring Disk I/O—Oracle’s ORION Tool
Measuring Disk I/O—A Vendor View
Measuring Disk I/O