David Fitzjarrell

Monday Nov 7th 2011 by DatabaseJournal.com Staff
Share:

David Fitzjarrell

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.

Articles

- 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 11.2.0.4
- 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 11.2.0.1 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 11.2.0.3
- 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

Share:
Home
Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved