Oracle Articles            By Burleson Consulting

Burleson Consulting is an altruistic company and we believe in sharing our Oracle extensive knowledge through publishing Oracle books and Oracle articles, video Oracle training, and one-on-one Oracle education courses.  BC pledges to help the Oracle community by publishing our tips, tricks and techniques and we hope that you find our tips informative.

Hot Oracle Articles & Content   BC Training Catalog Consulting Prices Oracle Grant Security Oracle Stored Procedures BC Oracle Tuning Book Oracle SQL Tuning Tips Tuning SQL with dbms_stats

Oracle Articles and RSS Feeds      DBA Oracle Blog RSS Feed     Oracle News RSS Feed                               Register for weekly Oracle Tips                               BC Oracle Webcasts                               Oracle Articles Archive                               Oracle Tips Archives                               Oracle Quick Tips

Our staff has unprecedented opportunity to see real-world Oracle database in-action and we share our experiences on this page of Oracle articles. 

Publish articles with BC

BC is a leading publisher of Oracle articles and we are affiliated with Rampant TechPress, the leading publisher of Oracle books.  If you want to publish an article or book, please call or e-mail BC today.

Oracle Article Index:

• Coming soon - Free Oracle 11g Reference Poster
• Don Burleson Blog!
• Fun News page!
• Burleson Humor Articles
• Burleson Opinion Articles
• Burleson Oracle Webcasts
• Burleson Oracle Articles Archive
• Steve Karam Oracle Articles
• Kent Crotty Articles
• Mike Ault Oracle Articles
• Robert Freeman Oracle Articles
• John Garmany Oracle Articles
• Rittman Oracle Articles
• Garmany App Server Tips Archive
• Burleson Oracle Tips Archive
• Freeman Oracle Tips Archive
• Quick Topic Tips
• Articles Quoting Mike Ault
• Oracle Concepts
• Easy Oracle Linux Commands
• Topica Oracle Newsletters
• Computer job interview tips - Upcoming book excerpts
• Golf Articles

Click here for Burleson reader comments.

Burleson Humor Articles:           For more opinionated nonsense, see the Don Burleson Blog!

• Is Oracle masculine or feminine? - April 30, 2008
• Funny Oracle Job Interview Questions - April 22, 2008
• Oracle's weirdest logo? - September 2007
• The redneck musician - September 2007
• Preventing Hippies - August 2007
• The next Greyhound of air travel - May 2007
• The first Oracle Magazine Cover? - March 2007
• Redneck Cuisine ideas - February 2007
• Stopping blog spam bots - January 2007
• Microsoft considers Automobile manufacturing - December 2006
• Computer Motivational Posters - August 2006
• Narcissistic personality disorders - June 2006
• Time for TSA Reform - June 2006
• Favorite Google Videos - July 2006
• Dumb computer jokes - April 2006
• Yum, cat milk - April 1, 2006
• Our most interesting meals - March 2006
• Ladies Handguns: Safety and fashion- December 2005
• Faces from history - May 2005
• Watch out for movie knock-offs - May 2005
• Shoes for Guide Horses - May 2005
• Understanding cultural differences - April 2005
• Burleson Horse Milk experiment - March 2005
• Rejected Computer Books - January 2005
• My first Tabloid article - December 2004
• Oracle headstone epitaph contest - August 2004
• What Type of DBA Are You? - DBAZine - May 2003
• Professional Dress Code
• User is a four-letter word. - DBAZine - June 2003
• Personal Appearance for Oracle Professionals - June 2004
• Oracle cartoons
• Make you own Deer Butt Alien - December 2006
• Mo' Possum, Dad, Mo' Possum - May 10th 2005
• Torn Between two worlds - May 10th 2005

Burleson IMHO Articles:            "Because you have the right to my opinion"   For more opinionated nonsense, see the Don Burleson Blog!

• Trapping wild Coyotes - January 12, 2008

• Dangerous Dilettantes Destroy Databases - September 28, 2007

• Evaluating personal history for moral turpitude - September 29, 2007

• Government licenses for computer professionals? - September 30, 2007

• Inside Oracle Sorting -  October 15, 2007

• Have decompilers become evil? - July 2007
• Old Southern sayings - June 2007
• Does familiarity breed contempt? - June 2007
• Intellectual Property Rights in a Global Market - June 2007
• Using Google as a back-end semantic database - May 6, 2007
• Inside the human revulsion instinct - March 17, 2007
• Google commands become the most popular Web integration glue
• Getting Credibility for Wikipedia - February 2007
• Tips for finishing your own rough cut hardwood Oak - February 2007
• Finishing your own Walnut lumber - November 20, 2007
• There's no such thing as a impenetrable question? - January 2007
• The Billionaire next door - December 2006
• Inappropriate corporate sponsorship of charities - December 2006
• Are you a "Man of the Year"? - October 2006
• Executive Perks for IT Professionals - September 2006
• Could Google control the Internet? - August 2006
• Meteor strikes can kill? - July 2006
• Are hacker guides illegal? - July 2006
• Is Bad Customer Service Good? - July 2006
• Burleson Consulting Travel Tips - June 2006
• DNA testing reveals racial groups - May 2006
• Deal or No Deal Probabilities - April 2006
• Do All Oracle Professional think alike? - November 2005
• Christmas shopping on eBay - October 2005
• Products that I buy for others - May 2005
• What do you collect? - May 2005
• Animal Manners - May 2005
• New Virus detected - April 1, 2004
• OK, what is this thing, and is it alive? - March 2004
• Understanding Redneck Theology - March 2004
• Oracle - What's in a name? - July 2003
• Don't steal someone's affection! - December 2006
• Increased earning income from bachelors, masters and doctoral (PhD) degrees - December 2006
• The "Yes Men" and Reburgering - June 2005
• Freedom of Speech vs. resources for criminals - June 2005
• Anthropomorphism in Marketing - June 2005
• Fake Military Heroes plague America - June 2005
• Business professionals attend auctioneering school - May 2005

Sports Tips

• The worlds hardest, most difficult sport - May 2007
• Golf etiquette for business professionals - June 2007
• Golf ball speed limits - June 2007

Burleson Consulting Oracle Articles        BC Oracle articles dating from 1999

• Finding database geniuses - May 1, 2008
• Don't let script kiddies play with Silver Bullets! - September 2007

• Oracle 11g Database Management for Business Intelligence

• Inside the 11g SQL Performance Advisor - September 2007

• Oracle 11g Data Compression Tips for the Database Administrator

• Oracle 11g function-based virtual columns

• Protecting your Oracle data against theft - May 2007
• Becoming an IT consultant - May 2007
• How to become an Oracle DBA - September 2006
• Oracle Biometrics Security - December 2005
• Oracle PGA pga_max_size undocumented parameter - SearchOracle - August 2005
• MetaBase scripting for the Oracle data warehouse DBA - SearchOracle, July 6, 2005
• How to be a successful computer professional - May 2005
• Evaluating Oracle credibility on the web - SearchOracle - April 2005
• Oracle10g SQL Time-series Tuning - DBAZine - February 2005
• Oracle 10g AWR SQL Tuning - OraFAQ - February 2005
• Inside Oracle 10g dynamic sampling - DBAZine - January 2005
• Can you have too much cache? - OraFAQ - December 2004
• Oracle 10g data warehousing - DBAZine - November 2004
• Database Auditing for Risk Management and Regulatory Compliance - Lumigent - November 2004
• Oracle features - Standard vs. enterprise edition - SearchOracle - November 2004
• Oracle first_rows optimization improvements - OraFAQ - November 2004
• Oracle 2020: A Glimpse into the Future of Database Management, Part 2 - DBAZine - Oct 2004
• Oracle 2020: A Glimpse into the Future of Database Management, Part 1 - DBAZine - Oct 2004
• The new Oracle10g Wait Event Tables - OraFAQ - Oct 2004
• Oracle tuning: Blocksize and index tree structures - SearchOracle - September 2004
• Extending Oracle10g AWR scripts - OraFAQ - September 2004
• Optimizer index caching - SearchOracle - September 2004
• Oracle Tuning Fallacies - SearchOracle - September 2004
• Busting the Oracle Myth Busters - DBAZine.com - September 2004
• 成本控制：Oracle 优化器内幕，第 2 部分
• 自动调整 Oracle9i Database：Oracle SGA
• STATSPACK을 이용한 오라클 데이타베이스 트랜드 분석
• STATSPACK을 이용한 오라클 데이타베이스 트렌드 분석
• Oracle 优化器内幕，第 2 部分（续
• Настольная книга по администрированию
• Автонастройка базы данных Oracle 10g:
• Russian RAM paging
• Источник: сайт Дональда Бурлесона, статья
• Основная таблица хранилища данных для Oracle8i
• 自调整 Oracle9i Database：Oracle SGA（续）
• I/O 대기 시간 분석을 통한 성능 향상
• Product Review - SQL*XL - OraFAQ - August 2004
• Oracle SQL tuning for full-table scans - OraFAQ - July 2004
• Inside the Oracle Buffer Cache - SearchOracle - July 2004
• Common Oracle Recovery Mistakes - OraFAQ - July 2004
• Always use direct I/O with Oracle - OraFAQ - June 2004
• Oracle Database Server Consolidation - DBAZine - June 2004
• Improved 10g management with EM - Orafaq - May 2004
• New Oracle10g SQL optimizer hints - Builder.com - April 26, 2004

• Unconventional Oracle tuning techniques - OraFAQ - April 1, 2004

• Measuring Oracle disk I/O speed - Builder.com - March 1, 2004

• Optimizing Oracle optimizer statistics - OraFAQ - March 1, 2004

• Oracle 911 Emergency Support - DBAZine - February 26, 2004

• Database Optimization: Determine if the 64-bit architecture is right for your database - Builder.com - February 23, 2004

• Auditing and reporting Oracle user activity - Builder.com - February 9, 2004

• Oracle Disk Management - DBAZine - February 3, 2004

• Oracle Optimization - Tuning 3rd party vendor systems - Builder.com - February 2, 2004

• Oracle Data Loading Tips - OraFAQ - February 2004

• Oracle parameter tuning - OraFAQ - January 2004

• Tweaking Oracle SQL Parameters - Builder.com - Jan 26, 2003

• Oracle replication tuning - Builder.com - January 8, 2004

• Create a management environment for developing Oracle SQL - Builder.com - December 29, 2003

• Optimizing Oracle*Net Configuration - Builder.com - December 16, 2003

• Don Burleson's favorite Oracle10g features - SearchOracle - December 5, 2003

• Использование средств автоматической настройки баз данных Oracle9i

• Oracle Buffer Busy Waits - Builder.com - December 9, 2003

• Use Oracle referential integrity to enforce business rules - Builder.com - December 2, 2003

• Inside Oracle indexing - DBAZine, December 2003

• Optimize your Oracle Network Parameters (sdu tdu mtu) - Builder.com - November 18, 2003

• Extend STATSPACK for disk I/O - Builder.com - November 11, 2003

• Oracle SQL tuning with column histograms - Builder.com - October 31, 2003

• Optimize Oracle SQL by understanding clustering_factor - Builder.com - October 27, 2003

• What to expect when you migrate to Oracle9i - Builder.com - October 12, 2003

• UNISYS Road Show: Oracle 64-bit Technology - October 10, 2003

• CEO Ellison reveals the Oracle10g vision of enterprise grid computing - Builder.com - October 10, 2003
• Oracle Undocumented Parameters - Part 2 - SearchOracle - October 10, 2003
• Using Hidden Oracle Utilities - Part 1 - SearchOracle - 18 September, 2003
• Audit design with Oracle fine-grained auditing - Builder.com - September 22, 2003
• Ellison's vision of Oracle10g - DBAZine - September 26, 2003
• Choose the proper Oracle design for auditing - Builder.com - September 8, 2003
• Hoe werkt de bitmap join index - September 2003
• Auto-Tuning Oracle Database 10g: Oracle SGA - OTN - September 6, 2003
• Track CPU and I/O cost with Oracle9i -Builder.com - September 2, 2003
• System Validation & Estimation - From Physical Database Design
• Expert offers tips on Oracle Security - SearchOracle.com - July 15, 2003
• Establish security policy with Oracle virtual private database - Builder.com - August 25, 2003
• 虚拟私有数据库 - ZDNet China
• Achieve faster SQL performance with dbms_stats - Builder.com - August 19, 2003
• Is your Oracle system compliant with Federal Law? - SELECT Journal, 2003
• Achieve better control with Oracle's grant execute security model - Builder.com - August 13,2003
• Get Oracle schema syntax the easy way - Builder.com - August 5, 2003
• 让我们进一步看看CPU的数量是如何 - ZDNET - China
• 成本控制：Oracle 优化器内幕，第 2 部分 - OTN - July 2003
• Cost control - Inside the Oracle Optimizer - OTN - July 2003
• Oracle Dynamic Grid computing - DBAZine.com - July 2003
• Control Access with Oracle grant Security - Builder.com - July 28, 2003
• A four-phase approach to procedural multimaster replication - DBAZine
• Oracle Linux vs. Oracle Windows - July 22, 2003
• Oracle Design Security from the ground-up - Builder.com - July 14, 2003
• Use multiple CPU with Oracle Parallel Query - Builder.com - July 9, 2003
• Oracle blocksize and index tree structures - DBAZine
• Burleson Webcast - Introduction to Oracle Tuning - DBAZine - June 10, 2003
• Book sheds light on performance tuning in Oracle9i - Builder.com - May 2003
• Analyzing real-time physical I/O waits - OTN - May 2003
• Check the efficiency of Oracle caching with this report (v$bh) - Builder.com - April 22, 2003
• Oracle9i Data Security Internals - DBAZine.com - April 2003
• How to get an Oracle DBA job - searchDatabase.com -  April 09, 2003
• Tweak Oracle data buffer parameters to cache entire databases - Builder.com - April 8th,, 2003
• Three ways to speed up SQL execution in Oracle - Builder.com - March 25, 2003
• Introducing Database Area Networks - DBAZine - March 17, 2003
• Proactively monitor Oracle9i performance via scripts and queries - Builder.com - March 11, 2003
• How Oracle9i supports dynamic reconfiguration - Builder.com - Feb 25, 2003
• 结论. Oracle materialized view的引入大大改善了处理复杂SQL - ZDNET China
• Inside Oracle9i Tablespace Management - DBAZine - February 20, 2003
• Boost Oracle Performance with Intelligent optimizer parameters - Builder.com - Feb 11, 2003
• An Enterprise Security Primer - DBAZine - Jan 23, 2003
• Oracle9i's ASSM improves segment storage internals - Builder.com - Jan 13, 2003
• Using Oracle9i to Create Custom Web Content - DBAZine - January 8th, 2003
• Space management in Oracle9i - TechProGuild - Dec 26, 2002
• Webinar - Oracle Expert Tuning Tips - Searchdatabase.com - Dec 14, 2002
• Oracle9i index full scans - Builder.com - Nov 25, 2002
• Oracle9i parameters reduce downtime - TechProGuild - Nov 25, 2002
• Using Oracle9i cache advice - Builder.com - November 18, 2002
• Steps you can take to optimizer your Oracle server - TechProGuild - November 18, 2002
• How to use Oracle9i bitmap join indexes - Builder.com - November 12, 2002
• Optimizing Oracle RAM usage - DBAZine - November 2002
• Oracle Web Hacker Tricks - Oracle Internals
• Auditing Oracle9i security - Oracle Internals
• Self-tuning in Oracle9i - Searchdatabase Webcast
• Using Oracle9i RAC and TAF for continuous availability - Searchdatabase Webcast
• Oracle9i provides enhanced views into RAM usage - Builder.com - October 18, 2002
• Oracle Wait Analysis Techniques - DBAZine - October 2002
• Creating tablespaces with multiple blocksizes - Builder.com - September 23, 2002
• Lock down database security for web-enabled apps - Builder.com, September 20, 2002
• Dynamic adjustment of the Oracle9i SGA - Builder.com, September 16, 2002
• Measure Oracle database server performance with vmstat - Tech Pro Guild - September 16, 2002
• Tablespace creation is a snap with Oracle Managed Files - Builder.com - September 5, 2002
• Extending Oracle for system event auditing - DBAZine - September 2002
• Introducing DAN - A New Database Architecture - Builder.com, August 13, 2002
• Oracle9i Scalar subqueries simplify complex SQL - TechRepublic, Aug 13, 2002
• Database Benchmark Wars: What you need to know - TechRepublic, Aug 8, 2002
• Oracle9i Simplifies SQL Syntax -TechRepublic - Aug 2, 2002
• Oracle Expert Tuning Secrets - Part 2 - DBAZine, July, 2002
• Using Spreadsheets as Oracle Tables - TechRepublic - July 22, 2002
• Accessing Flat Files with Oracle SQL - TechRepublic - July 1, 2002
• Oracle Expert Tuning Secrets - DBAZine, June, 2002
• Cleaning house - Tips for firing IT personnel - May 16, 2002
• Leveraging your IT skills in a tough job market - May 16, 2002
• Becoming an IT Management Superstar - May 16, 2002
• Costs and Benefits for High Availability Oracle9i - DBAzine, May, 2002
• Real 24/7 - Using Oracle9i RAF and TAF to guarantee availability - Oracle Magazine - May/June 2002
• Four questions you should ask a DBA job candidate - TechRepublic, April 30, 2002
• Oracle9i Data Model Extensions - TechRepublic - April 24, 2002
• Oracle认证的专家之见（第二部分）- ZDNet China

• の検索結果… 売れている順, 価格の高い順, 価格の安い順, 発売日最新順, 商品名昇順, 商品名降順

• OracleハイパフォーマンスチューニングSQL編 [商品詳細]
• An insider's guide to Oracle certification - Part 2 - TechRepublic - April 19, 2002
• Configuring your Oracle9i database for Materialized Views - TechRepublic - April 9, 2002
• Oracle architectural design tips offered - ZDNET - Australia - April 8, 2002
• Oracle Architectural Design Tips - TechRepublic -April 5, 2002
• Dynamically create complex objects with Oracle materialized views - TechRepublic - April 2, 2002
• An insider's guide to Oracle certification - TechRepublic - March 29, 2002
• Turbocharge SQL with advanced Oracle9i indexing - TechRepublic - March 26, 2002
• Migrating from Windows to UNIX - TechRepublic - March 25, 2002
• Using Oracle9i Real Application Clusters for Continuous Availability - DBAzine - March 2002
• Data structure denormalization in Oracle9i - TechRepublic - March 19, 2002
• Cost factors driving highly available systems - TechRepublic - March 2002
• Techniques for increasing Oracle scalability - TechRepublic - March 2002
• Oracle RAC: The answer for continuous availability? - TechRepublic - March 2002
• Self Tuning in Oracle9i - A Webinar by SearchDatabase.com - February 2002
• Take steps to Retain your IT Superstars - TechRepublic - February, 2002
• Using Multiple Block Sizes in Oracle9i - DBAzine - February, 2002
• Using the Dynamic SGA Features of Oracle9i - DBAzine - February, 2002
• Guard against performance issues when using Oracle hints and views - TechRepublic - January, 2002
• An insiders view of selecting an ERP Vendor - TechRepublic - September, 2001
• Four Factors that shape the cost of ERP - TechRepublic - August, 2001
• Selecting an ERP System: Build or Buy - TechRepublic - August, 2001
• Managing Web Development in Oracle - TechRepublic - August, 2001
• Oracle Tuning: Tuning individual SQL statements - TechRepublic - May 2001
• Oracle tuning: Working with individual objects - TechRepublic - April 2001
• What is your Oracle SQL Optimizer Philosophy? - TechRepublic - April 2001
• Remote DBA Offers an attractive outsourcing option - TechRepublic - April, 2001
• Using STATSPACK to monitor Oracle performance - TechRepublic - April, 2001
• Boost performance by tweaking global instance parameters - TechRepublic - March, 2001
• Oracle Tuning - Examining the Oracle Instance - TechRepublic - March, 2001
• Oracle Tuning - Monitoring hardware with UNIX tools - TechRepublic - March, 2001
• Oracle Tuning - Start by looking at the big picture - TechRepublic - February 2001
• Optimizing e-commerce database
  systems using parallel Oracle - TechRepublic - February 2001
• Using parallel Oracle for high-speed e-commerce systems - TechRepublic - February 2002
• Hierarchical Attribute Design for an Oracle8i Warehouse - TechRepublic - January 2001
• Reorganizacja tabel w bazach
   danych Oracle w celu przyspieszenia
   dyskowych operacji wejscia / wyjscia - Javasoft.pl, sroda, 7 lutego, 2001
• Organizing classification attributes for Oracle8i data warehouses - TechRepublic - January 2001
• What's new in Oracle9i? - TechRepublic - December 2000
• Oracle9i offers some interesting enhancements - TechRepublic - December 2000
• Taking Advantage of Object Partitioning in Oracle8i - TechRepublic - November 2000
• Oracle Database Trend Analysis Using STATSPACK - Oracle Magazine - November/December, 2000
• Mining Gold from the Library - Oracle Magazine - November/December, 2000
• The Object-Relational Features of Oracle8 - TechRepublic - October, 2000
• Faster Performance Using Oracle8 Stored Procedures - SELECT Magazine, October, 2000
• Setting PCTFREE and PCTUSED based on Average Row Length - SELECT Magazine, June, 2000
• Get acquainted with Oracle's Certified Professional Program - TechRepublic - May, 2000
• Speed Oracle database queries with parallel features - TechRepublic - January, 2000
• Kick it up a notch! Faster Oracle queries using parallel features - TechRepublic - January, 2000
• Turning the Tables on Disk I/O - Oracle Magazine - January, 2000
• Tuning Disk I/O in Oracle8 - Oracle Magazine - November, 1999
• Automating Oracle Tuning - Oracle Magazine - July, 1996
• Tips for Using Oracle Stored Procedures - Oracle Magazine - May 1996
• Identifying which Indexes to Rebuild - Embarcadero - July 1999
• How Oracle 8 Will Change Your Life - OReview Magazine - March, 1997
• Developing Effective Oracle Data Warehouse and OLAP Applications - OReview Magazine - July, 1996
• Using SQL*Net in a Distributed Database Environment - Oreview Magazine - April, 1996
• Patrol Version 3.0.15 - DBMS Magazine - April, 1996
• Object-Oriented Primer: An Oracle8 Preview - Oreview Magazine - November, 1996
• Legacy bumps slow trip to relational - Software Magazine, March 1995
• Objects, Objects, Everywhere - Computerworld Magazine - March, 1994
• Can you cope? - Computerworld Magazine - February, 1994
• Neophytes - Computerworld Magazine - February, 1994
• Design and Implementation of a Decision Support System for Academic Scheduling - Information & Management - September 1986
  

Oracle Articles by BC consultants

The following articles are published by the BC team of top-notch Oracle experts.

• Oracle patching secrets with $ORACLE_HOME cloning - John Palinski - April 7, 2007
• Monitoring Oracle9i for Windows - Terry Clark - June, 2003
• Inside the Oracle concurrent Manager - Terry Oakes - DBAZine, January, 2003
• Using Oracle system triggers to audit user activity - John Lavender - November, 2002
• Can database models take all types? - Don Burleson - Software Magazine, Dec, 1995

Oracle articles quoting Donald Burleson

• Oracle free migration tools SQL Server & MySQL - Computerworld - January 2007
• Admins grapple with latest Oracle patch puzzle - SearchSecurity - October 2005
• British Bug Hunter Finds 34 Flaws in Oracle Apps - Computerworld - Aug 2004
• Brit find 34 Oracle security holes - Computerworld - August 2004
• Expert offers tips on securing Oracle - SearchOracle - June 15, 2004
• Getting a look at 10g - SearchOracle - February 10, 2004
• Burleson offers advice for getting an Oracle DBA job - SearchOracle
• DBAs advance with Burleson's Oracle9i Tips - Searchdatabase - November 22, 2002
• Experts offer tips on securing Oracle databases - SearchOracle
• How to get a DBA job - SearchOracle
  

 John Garmany Articles

• The Power of Indexing - February 2007
• OracleAS 10.1.3 & multicast communications
• Oracle application server virtualization - January 2007
• Constrained Server Topography with Oracle’s Application Server 10g - DBAZine - October 2004
• Oracle9i Application Server Release 2 - DBAZine.com - October 2004
• Oracle Application Server 10g: Creating the Metadata Repository in an Existing Oracle Database - DBAZine - October 2004
• Creating an Oracle Forms Response Time Monitor - DBAZine.com - John  Garmany - March 2004
• Bulk Loading Users for Single Sign-on - John Garmany - DBAZine.com - April 2004
• Capturing Forms server performance data  - John Garmany - Oracle Internals, October 2002
• OracleWorld 2002 Report - John Garmany - Builder.com.com - January 2003

Articles by Robert Freeman

• So you want to be a DBA... - SearchOracle.com - April 2005
• Understanding HTML-DB concurrency management - June 2005
• The Oracle Database Advisors, Part 2 - DBAZine
• Oracle Database 10g New Features:
   The Oracle Database Advisors - DBAZine
• Using Oracle Enterprise Manager
  Database Console 10g: A Convert’s (almost) Story - DBAZine
• Oracle 10g database advisors - Robert Freeman - DBAZine
• Multi-Master Replication Conflict Avoidance and Resolution - SELECT Magazine
• Dynamic Memory Allocation in Oracle9i - Quest Pipelines
• Portable DBA: Oracle - This handy, affordable reference is ideal for on-the-job DBAs in need of quick access to administrative commands, error resolutions, and best practices.
• Oracle Database 10g New Features - Oracle Database 10g New Features provides a convenient overview of all the cutting-edge features of Oracle's latest database product for those looking to upgrade to this database version or migrate from another product platform.
• Oracle Replication - The only book that describes the intricacies of Oracle multimaster replication and provides working code examples of complex multimaster replication. Includes a section on replication tuning and monitoring.
• Oracle9i New Features - You'll find that Freeman is concise and knowledgeable
• How do you recognize a good Oracle DBA? - Robert G. Freeman

Articles by Steve Karam, OCM, Oracle ACE

• Slowly changing dimensions modeling tips
• Oracle Standard Edition One (SEO) strategy
• Oracle Universal Installer OUI patching tips
• Introduction to Oracle Scalability Features
• Oracle APEX (HTML-DB) and AJAX
• Oracle disk and the "personal petabyte"
• Deciding to implement Oracle RAC
• Using the advanced features of ApEx HTML-DB
• Using ApEx (HTML-DB) with AJAX
• Oracle user security management - OraFAQ
• Oracle user security management - OraFAQ
• Oracle IP address blocking in sqlnet.ora - OraFAQ
• Oracle network security guidelines - OraFAQ
• Oracle ANYDATA token tips - September 2006
• Copying Oracle Users - September 2006
• Oracle dbms_xlmgen tips - September 2006
• Oracle Streams Replication Propagation - November 2006
• GQLPlus for Oracle - November 2006

Articles by Kent Crotty, OCP

• PL/SQL Bulk Collect performance tests
• PL/SQL forall operator speeds 30x faster for table inserts
• PL/SQL fetches data 8x faster than SQL

Articles by Mike Ault

• 打破oracle数据库树立的种种神话
• Why disks are obsolete
• Oracle WHERE 1=2 Parallel
• Adjusting Array Size in Oracle SQL*Plus
• Understand Oracle null values - March 2006
• Oracle object wait statistics v$segment_statistics - December 2005
• Creating a Cross Tab Report - June 2005
• Using a HASH Signature in Data Warehouses - October 2005
• Oracle Myths Revisited - May 2005
• On the Demise of DBAs - September 2005
• Generating random test data with dbms_random - September 2005
• The hazards of Oracle Science - April 2005
• Going Solid - April 2005
• 9i RAC vs. 10g RAC - April 2005
• Understand the Oracle “proof” Myth - June 2005
• Advanced PL/SQL Code Tuning - DBAZine March 2005
• Rules for setting large Oracle blocksizes - May 2005
• Tune Oracle for Concurrent disk I/O - March 2005
• Understand Oracle I/O profiles - March 2005
• A Shootout Between Sun E4500 and a Linux Redhat3.0 AS Cluster Using Oracle10g - DBAZine.com - January 2005
• Improving Application Performance - OTN - January 2005
• Initialization Parameters in Oracle 10g - DBAZine - November 2004
• What is Automated Storage Management? - SearchOracle - November 2004
• Utilities for Starting and Stopping Databases DBAZine.com - October 2004
• A Comparison of Solid State Drives to Serial ATA (SATA) Drive Arrays for Use with Oracle - Mile Ault - DBAZine.com - October 2004
• New Cross-Platform Transportable Tablespaces - Mike Ault - September 2004
• Temporary Tablespace - Mike Ault - DBAZine.com
• Database disk Architectures - Mike Ault - DBAZine.com - January 2004
• Oracle 10g OLAP Enhancements - DBAZine - May 2004
• Oracle customized parameters users triggers - Mike Ault - July 2005
   

Articles Quoting Mike Ault

• Oracle customized parameters users triggers - Mike Ault
• Saving lives with Oracle Medical Informatics - Dr. Carolyn Hamm

Oracle error tips:

• ORA-00020: maximum number of processes (%s) exceeded
• ORA-00103: invalid network protocol; reserved for use by dispatchers tips
• ORA-00221: error on write to control file tips
• ORA-00302: limit of string logs exceeded tips
• ORA-00304: requested instance_number is busy tips
• ORA-00306: limit of string instances in this database tips
• ORA-00313: open failed for members of log group string of thread string tips
• ORA-00320: cannot read file header from log string of thread string tips
• ORA-00382: %s not a valid block size, valid range[string..string] tips
• ORA-00402: database changes by release string cannot be used by release string tips
• ORA-00439: feature not enabled: STRING tips
• ORA-00904: "DROP_SEGMENTS": invalid identifier
• ORA-00904: STRING: invalid identifier tips
• ORA-00905: missing keyword tips
• ORA-00917: missing comma tips
• ORA-00918: column ambiguously defined tips
• ORA-00920: invalid relational operator tips
• ORA-00922: missing or invalid option tips
• ORA-00923: FROM keyword not found where expected tips
• ORA-00933: SQL command not properly ended
• ORA-00934:
• ORA-00955: name is already being used by existing object tips
• ORA-00979: not a GROUP BY expression tips
• ORA-00984: Column Not Allowed Here Tips
• ORA-01001: invalid cursor tips
• ORA-01002: fetch out of sequence tips
• ORA-01007: variable not in select list tips
• ORA-01013: user requested cancel of current operation tips
• ORA-01019: unable to allocate memory in the user side tips
• ORA-01033: ORACLE initialization or shutdown in progress
• ORA-01092: ORACLE instance terminated
• ORA-01341: LogMiner out-of-memory error
• ORA-01400: Unhandled Exception error
• ORA-01439: column to be modified must be empty to change datatype
• ORA-01483: invalid length for DATE or NUMBER bind variable
• ORA-01555 Snapshot Too Old
• ORA-01752: cannot delete from view without exactly one key-preserved table
• ORA-01858: a non-numeric character was found where a numeric was expected
• ORA-02019 : connection description for remote database not found
• ORA-03113: end-of-file on communication channel
• ORA-04030: out of process memory when trying to allocate nn bytes
• ORA-04063 - Re-compiling PL/SQL procedures and packages
• ORA-06502: PL/SQL: numeric or value error
• ORA-06512: EXECUTE DBMS_SPACE is granted to PUBLIC
• ORA-06550 tips
• ORA-02014: cannot select FOR UPDATE from view
• ORA-12005: may not schedule automatic refresh for times in the past
• ORA-12154: TNS:could not resolve service name
• ORA-12162 TNS:net service name is incorrectly specified
• ora-12500 listener error
• ORA-12514: TNS: listener could not resolve SERVICE_NAME
• ORA-12538: TNS: no such protocol adapter
• ORA-12541: TNS: no listener
• ORA-12545 tips
• ORA-12560:TNS:protocol adapter error
• ORA-14004: missing PARTITION keyword
• ORA-14019: partition bound element must be one of: string, datetime or interval literal, number, or MAXVALUE
• ORA-20000: Insufficient privileges undefined dba_tab_monitoring
• ORA-23375: feature is incompatible with database version
• ORA-25228 Error
• ORA-27054 tips
• ORA-27070: skgfdisp: async read/write failed error
• ORA-29341: The transportable set is not self-contained
• Oracle ORA-01017 tips
• Locks and ORA-00054 error
• ORA-01026: multiple buffers of size>4000in the bind list tips
• ORA-01031: insufficient privileges tips
• ORA-01041: internal error. hostdef extension doesn't exist tips
• ORA-01078: failure in processing systems parameters tips
• ORA-01089: immediate shutdown in progress-no operations are permitted tips
• ORA-01102: cannot mount database in exclusive mode tips
• ORA-01110: data file string: "string" tips
• ORA-01113: file string needs media recovery tips