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

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
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.

Articles

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



Comment and Contribute

 


(Maximum characters: 1200). You have characters left.