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 Nov 7, 2011

David Fitzjarrell

By DatabaseJournal.com Staff

David Fitzjarrell

David Fitzjarrell has more than 20 years of administration experience with various releases of the Oracle DBMS. He has installed the Oracle software on many platforms, including UNIX, Windows and Linux, and monitored and tuned performance in those environments. He is knowledgeable in the traditional tools for performance tuning – the Oracle Wait Interface, Statspack, event 10046 and 10053 traces, tkprof, explain plan and autotrace – and has used these to great advantage at the U.S. Postal Service, American Airlines/SABRE, ConocoPhilips and SiriusXM Radio, among others, to increase throughput and improve the quality of the production system. He has also set up scripts to regularly monitor available space and set thresholds to notify DBAs of impending space shortages before they affect the production environment. These scripts generate data which can also used to trend database growth over time, aiding in capacity planning.

He has used RMAN, Streams, RAC and Data Guard in Oracle installations to ensure full recoverability and failover capabilities as well as high availability, and has configured a 'cascading' set of DR databases using the primary DR databases as the source, managing the archivelog transfers manually and montoring, through scripts, the health of these secondary DR databases. He has also used ASM, ASMM and ASSM to improve performance and manage storage and shared memory.


Delaying Standby Database Recovery
TYPE Definition Change in Oracle 21c
Is COUNT(rowid) Faster Than COUNT(*)?
A Look at the Oracle Group-by Bug
Addressing the Drop Column Bug in Oracle 18c and 19c
Monitoring Table Change in Oracle
Don't Let the Streams Pool Fool You
Using LogMiner To Find Current Changes
Foreign Keys and Multi-Table Inserts in Oracle
What is the Latch Event and Why Does It Occur?
Understanding the Odd Behavior for Timestamp with Time Zone Columns in Oracle
Oracle's Native JSON Changes May Present a Surprise
The Horror of NOLOGGING in Oracle
Single-column Primary Keys and Histograms in Oracle
Trouble with Oracle's DBA_TABLESPACE_USAGE_METRICS For The UNDO Tablespace
Oracle's Automatic Memory Management and the SPFILE
Oracle's Interesting Treatment of IN-LISTS
Is UNION The Best Choice When Joining Result Sets?
Handling Disaster Recovery When Using Oracle Managed Files
Choosing Between Oracle's Bitmap and Function-based Indexes
Improvements in Oracle's Join Elimination
A GUI Might Not Be An Oracle DBA's Best Friend
Hybrid Histograms in Oracle 18
Oracle OEM Agent 13c and Perl
Oracle Network Encryption
Tuning Oracle Queries with an Optimizer Trace
Oracle's ddl_lock_timeout in Version
Oracle's Transparent Data Encryption
Oracle's 'cursor_sharing = force' May Not Behave as Expected
Oracle's ASCIISTR() and Unicode Characters
Using Oracle VM to Create Dev and Test Environments
Creating an Oracle Patching Strategy
Moving from Oracle Solaris to x86
Oracle's Conventional Export (exp) May Cause Problems
Pseudonymization Of Personal Data With Oracle
Does Your Oracle Table Really Need 255 or More Columns?
Put Your Oracle Database In the Oracle Cloud
Backup to the Oracle Cloud
Oracle 12cR2 Upgrade and the Alert Log
Using Oracle's DBMS_PROFILER to tune PL/SQL
Oracle's Unified Auditing, Part II
Static Registration and the Oracle 12.2 Listener
Oracle's UNDO Tablespace and Autoextend
Oracle's Bulk Collect and Limit Can Be A Problem
Monitoring Oracle's Temp Usage
Oracle Upgrades to
Oracle's Automatic Big Table Caching
Oracle's TEMP Tablespace
Tracking Rollback Progress in Oracle
Oracle's Newest PL/SQL Feature 'ACCESSIBLE BY'
Oracle's 'Parallel Query Allocate Buffer' Latch
Oracle's Autotrace Can Lie to You
Oracle Transaction En-queue Waits and Locked Objects
Oracle Mutexes
Oracle Latches
Indexing In Oracle 12c When Extended String Length is Configured
Oracle's Histograms: Bane or Boon?
Oracle B-Tree Index On A BLOB
Using the optimizer_index_cost_adj Parameter in Oracle
Does NOLOGGING In Oracle Really Save Time?
Setting A Logon Security Message In Oracle
Unified Audit Trail in Oracle 12c
Is Oracle Enabling Compulsive Tuning Disorder?
Using Index-Organized Tables in Oracle
Calculating Elapsed Time For Queries In Oracle
Oracle's pga_max_size and _pga_max_size Control Two Different Areas
Oracle’s Automatic Listener Registration
Is Oracle’s SYS_GUID A Good Choice For A Primary Key?
Storing Numbers As Strings In An Oracle Database
Little-Known Exceptions in  Oracle’s PL/SQL
Oracle 12c In-memory Column Store Has An Unexpected Surprise
A New Way To Pattern Match In Oracle 12c
Hybrid Histograms in Oracle 12c
The Oracle Bug That Could Bite You Has No Teeth
This Oracle Bug Could Bite You
Index Sanity in Oracle
Is Your Oracle Invisible Index REALLY Invisible?
Returning The Actual DOP When Using Oracle’s Auto Degree Of Parallelism
Oracle’s REMAINDER Function: The Result Isn’t Always Correct
Oracle's Calibrate_io Procedure: Why You Should Use It
Mutating Table Error In Oracle: Why It Happens And What You Can Do About It
Oracle SRVCTL Issue in
Re-thinking SQL Queries Using Sets in Oracle
Deletes In Oracle: More 'Costly' Than You Think
Oracle 12c Table Point-in-time Recovery
Partition Limits In Oracle
The One 'Security' Feature in Oracle You Probably Shouldn't Use
Unique Records In Oracle
Oracle's ANSI Join Syntax Can Result In Wrong Results
Memory Leak in on AIX: Shared Cursors Are Not Behaving
Function-based Index on LOB Columns and Oracle's SQL*Loader
Oracle's utlrp.sql Script and Edition-based Redefinition
Oracle Error When Importing An Interval Partitioned Table
Tivoli and RMAN in Oracle
Extended Statistics and Oracle 12c
The Oracle PL/SQL Results Cache
Automatic UNDO in Oracle
Oracle's Hakan Factor
Is My Oracle Index Being Used?
Deciding On A Primary Key In Oracle
Delayed Block Cleanout in Oracle
Demystifying Oracle's Clustering Factor
A Brief History of Oracle Backup and Recovery
Monitoring Tablespace Usage in Oracle
Stoptimizing Oracle
Bulk Exceptions in Oracle
Cartesian Joins in Oracle: The Nullable Column Problem
More Than Oracle Knows What To Do With
Hitting The Oracle Target
CBO, Analytic functions and Cardinalities in Oracle 11.2
My Oracle Cup Overflows
Oracle: MERGE 'Monkey-business'
Oracle: The Nuts And Bolts Of Basic Compression
Oracle: Too Much Time On Your Hands?
Problem Solving, Oracle-Style
Do You Really Need Oracle Optimizer_index_cost_adj Set?
Oracle: Can Adaptive Cursor Sharing Plans Depend On Execution Order?
Oracle: Deferred Segment Creation And Tablespace Restrictions
Oracle In-Memory Database: The Bloom Filter Example Re-visited
Skipping Schema DML in an Oracle 11.2 Logical Standby Database
Oracle: Can a NULL sql_id Use CPU?
Oracle Bloom Filters
Oracle: Is Parallel Really Necessary?
Oracle: Getting The Starting Date Of A Week Using Week Number
Understanding Hugepages in Oracle Database
Exadata: When A Smart Scan Isn't
Performance -- It May Not Be The Database
"The Chain Gang", a Riveting Tale of Chained and Migrated Rows in Oracle
Are There Safeguards to Prevent the DBA from Dropping a Table?
Modifying a Primary Key Index in Oracle 11.2.0.x
Oracle 11.2 Outer Join And Index Issue
Oracle Parallel Processing: 'New' and Improved
Oracle 11g and Index Access
Using Collections In Oracle
Oracle Exadata: DMA or DBA
Compression and Advanced Compression in Oracle 11.2
Are You Better at Enforcing Referential Integrity than Oracle?
Oracle Exadata Basics
Oracle: Sorting Out Constraints
Monitoring Smart Flash Cache Activity on Oracle Exadata
Oracle Hybrid Columnar Compression in Exadata
How to Pivot Data in Oracle 11g
The Oracle Database Auditing Options
Monitoring Smart Scans in Oracle Exadata
Parallel Processing -- Bane or Boon
A Tale of Two Indexes
Exadata Survival Guide
The Exadata Feature You Need to Know About
Oracle 12c New Features
An Exadata Primer
Using Non-unique Indexes for Primary Keys -- A Case Study
Improvements in Automatic SGA Management from 9.2 Through 11.2
Compound Triggers in Oracle 11g
Using Adaptive Thresholds to Monitor Oracle Database Performance
How Statistics Have Improved from Oracle 10gR2 to 11gR2
Using Application Editions To Make Upgrades Less Painful
Oracle's Ever Increasing Index
Oracle Invisible Indexes
Archiving Oracle Databases
Using Autoextend to Increase Oracle Database File Sizes
PGA and Memory Management in Oracle
Monitoring Index Usage in Oracle Databases