Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Posted May 13, 2003

James Koopmann

By James Koopmann

James Koopmann has fourteen years of database design, development and performance tuning experience. In addition, he has extensive database administration experience in Oracle and other relational databases in production environments, specializing in performance tuning of database engines and SQL based applications.

Koopmann is an accomplished author with several technical papers in various Oracle related publications such as Oracle Magazine, Oracle Professional and SQL>UPDATE_RMOUG. He is a featured author and database expert for DatabaseJournal, a member of the editorial review committee for Select Journal (The Magazine for the International Oracle Users Group), an Oracle Certified Professional DBA and noted speaker at local Oracle User Groups around the country.

Current Articles

Finding Database Network Abusers with Netstat
Oracle Enterprise Manger and Real-Time Database Performance
Configuring Oracle for Automatic Database Monitoring in 3 Easy Steps
How to Monitor an Oracle Database Automatically
Finding performance problems using statistics
Database Performance Tuning: Statistical Gathering
14 Useful DBA Tasks for Solving Database Performance Problems
Top 5 Query Tactics Questions for the PL/SQL Developer Job Interview
Top 7 User Defined Encryption Questions for Your Next PL/SQL Job Interview
Top 6 Security Questions for a PL/SQL Developer Job Interview
Oracle Developer Job Interview: Top 10 PL/SQL Performance Questions
Procedures, Functions, and Packages: Acing that PL/SQL Developer Job Interview
Top 5 Oracle Database PL/SQL Job Interview Questions
Top 9 Database Object Tips You Need to Know for Your Next PLSQL Job Interview
Top 5 Basic Concept Job Interview Questions for Oracle Database PL/SQL Developers
Solve Database Performance Tuning Problems by Monitoring CPU Resource Consumption
Regain Control of Your Oracle Database with DBMS_METADATA_DIFF
Getting Oracle VM VirtualBox Ready for an Oracle Database
Little Known Uses for Oracle Database's Error Tool
Oracle Database's ADRCI: the Extended Commands
Oracle Database's ADRCI : Reading the Old Alert Log and Listener Log
Purging Oracle Database's Alert Log with ADRCI - Usage and Warning
Rotating Oracle Database's Alert Log with ADRCI
Alert Log Scraping with Oracle's ADRCI Utility
Eight Reasons Why Oracle's Acquisition of Sun isn't All Bad
Oracle Database Archive Logging -- Where are my archive logs?
Pay Attention to your Oracle Database Archive Logging Function
When Tuning Oracle is not an Option
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
Oracle Invisible Indexes and Index Usability
Getting Ready for Oracle Flashback Database
Oracle Flashback Version Query�Trick or Trap
Oracle's Flashback Query - TIMESTAMP or SCN?
Oracle's Flashback Query - Should you unset _in_memory_undo?
Failures within Your UNDO Tablespace-When do they occur?
Is Your UNDO Tablespace Prepared for Oracle's Flashback Technology?
Oracle Flash - What is it?
HiT Software's DBMoto 6.5
Inter-process communication with DBMS_ALERT
Modeling Oracle Time
Looking at your operating system with the help of Oracle's V$OSSTAT view
What Is Your Definition of Database Workload?
So what is an Oracle Nested Table?
Oracle Health Checks with Health Monitor; Using PL/SQL or ADR
Oracle's ADR Command Interpreter (ADRCI) - Part 3
DBA Call to Action: How You Do What You Do
Oracle's ADR Command Interpreter (ADRCI) - Part 2
Oracle's ADR Command Interpreter - Part 1
Looking at Memory Usage for Oracle Processes
Oracle Database 11g - Common Background Processes
Create your own reports with Oracle's Snapshot Information
Measuring Disk I/O--Oracle's ORION Tool
Measuring Disk I/O—A Vendor View
Measuring Disk I/O
Oracle Library Cache�Part II
Oracle Library Cache�Part I
Oracle's Transportable Automatic Workload Repository
RMAN Disk to Disk Backup Methods
Handling NULLS in SQL statements
Just SQL Part VII - Hierarchical Queries
Just SQL Part VI - Two Famous Pseudocolumns
Just SQL Part V - Counting with SQL
Just SQL Part IV - Joining Tables
Just SQL Part III - Where is it?
Just SQL Part II - The Simple SELECT
Just SQL Part I
A View of Creating an Oracle User - Part II
A View of Creating an Oracle User - Part I
The Globalization of Language in Oracle - Index Requirements
Oracle and Regular Expressions
The Globalization of Language in Oracle - And Case-Insensitivity
The Globalization of Language in Oracle - The NLS_LANG variable
The Globalization of Language in Oracle - The NLS_COMP and NLS_SORT variables
The Globalization of Language in Oracle - National Language Support
The Globalization of Language in Oracle - Terminology
Oracle Session Tracing Part VI
Oracle Session Tracing Part V
Oracle Session Tracing Part IV
Oracle Session Tracing Part III
Making a Connection from Oracle to SQL Server
Oracle Session Tracing Part II
Oracle Session Tracing Part I
Clustering for Indexes
Sending e-mail from within Oracle
Oracle 10g's Undo Advisor
DBA Call to Action: Get up and GO
Automate the Sizing of your SGA in Oracle 10g
Oracle 10g's Redo Logfile Sizing Advisor
Introduction to Oracle 10g's New SQLAccess Advisor
True Session Wait Activity in Oracle 10g
Introduction to Oracle 10g's New SQL Tuning Advisor
Watching SQL Execute on Oracle - Part II
Watching SQL Execute on Oracle - Part I
Instant Client in Oracle 10g
Executing External Programs From Within Oracle
New Features in Oracle 10g for SQL*Plus and iSQL*Plus
Multiple Temporary Tablespaces in Oracle 10g
Transferring Operating System Files from within Oracle
Data Modeling, Breaking & Fixing First Normal Form (1NF)
Working with VARRAYs in Oracle Part III
Working with VARRAYs in Oracle - Part II
Working with VARRAYs in Oracle Part I
DBA Call to Action: Zeroing in on Performance Problems
Storing Word Documents in Oracle
Manipulating Oracle Files with UTL_FILE
DBA Call to Action: New Year Resolutions
Oracle Technical Interview Questions Answered - Part2
Oracle Technical Interview Questions Answered - Part1
Creating a Database in PostgreSQL
Oracle9iR2 Segment Level Statistics
Oracle9iR2 Shared Pool Advisory
An instance by any other name is still an instance...or is it
Oracle's Default TEMPORARY Tablespaces
Oracle Technical Interview
DBA Call to Action: Oracle Database Integrity
Between the Software and the Database
Oracle Time Zone
What's In A Name - Naming and Idenifying Oracle Databases and Instances
PostgreSQL Software Installation
Tracking Data Access Patterns in Oracle
Oracle PL/SQL Built For Speed
Getting Started With PostgreSQL
A Comparison of Oracle's DATE and TIMESTAMP Datatypes
Oh Danny Boy, The DBMS_PIPES Are Calling
The Road from Oracle8i to Oracle9i Certification
Returning Rows Through a Table Function in Oracle
Altering Oracle's SQL*Plus Help Facility
So You Want to Use Oracle's SPFILE
DBA Call to Action: Make an Impact
James Koopmann
DDL Generation--Oracle's Answer to Save You Time and Money
Database Impact of Collecting Statistics in Oracle
Implications of Setting Oracle9iR2's Statistics Collection Level
Hold On There SYSter
Explain Away Your Troubles
DBA Call to Action: The Information Chase
Killing the Oracle DBMS_JOB
Oracle9i's Auto Segment Space Management Option
That Darn Alert Log
Database Performance and some Christmas Cheer
Remote Procedure Calls Will Get You the Cheese

Article Series

PL/SQL Job Interview

Oracle Database's ADRCI Utility

Oracle 11g Security

Oracle�s ADR Command Interpreter (ADRCI)

Measuring Disk I/O

Just SQL

The Globalization of Language in Oracle

Oracle Session Tracing

Working with VARRAYs in Oracle

Oracle Technical Interview