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/font>                               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:

• 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
• Oracle DBMS Package Tips

&n 

Click here for Burleson reader comments.font>

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

• Oracle correlates with Global Warming! - August 2015

• Everybody loves a fireman - April 2015

• How to become desensitized to gross nauseating revolting things - February 2015

• Unborn cloned meat products coming to a restaurant near you - December 2009

• That's despicable! Teaching children how to despise others - December 2009

• The self loathing obese! - December 2009

• Why dogs hate Halloween! -  October 2008

• Fake Indians invade Europe! -  October 2008

• The best Halloween Pumpkins! - October 2008

• America's best redneck cuisine - June 22, 2008
• A visual guide to Oracle concepts - June 18, 2008
• 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!

• Fake Indian pan flute bands invade America & Europe! - October 20, 2008
  
• 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
• 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
• Measuring Oracle Segment I/O - DBAZine - John Weeg
• Datafile Resizing Tips - DBAZine - John Weeg
• Measuring Data Segment Statistics - DBAZINE - Arup Nanda
• Optimizing Oracle Physical Design - DBAZine - Dave Ensor
  

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

• Popular RAC Storage Options in 11g
• Steve Karam expert systems, decision support systems and AI experience
• 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-00997 Illegal use of long datatype 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
• ORA-01114: IO error writing block to file string (block # string) tips
• ORA-01157: cannot identify/lock data file string-see DBWR trace file tips
• ORA-01405: fetched column value is NULL tips
• ORA-01406: fetched column value was truncated tips
• ORA-01407: cannot update (string) to NULL tips
• ORA-01410: invalid ROWID tips
• ORA-01417: a table may be outer joined to at most one other table tips
• ORA-01427: single-row subquery returns more than one row tips
• ORA-01438: value larger than specified precision allowed for this column tips
• ORA-01455: converting column overflow integer datatype tips
• ORA-01458: invalid length inside variable character string tips
• ORA-01460: unimplemented or unreasonable conversion requested tips
• ORA-01461: can bind a LONG value only for insert into a LONG column tips
• ORA-01480: trailing null missing from STR bind value tips
• ORA-01402: index or partition of such index is in usable state tips
• ORA-01536: space quota exceeded for tablespace "string" tips
• ORA-01552: cannot use system rollback segment for non-system tablespace "string" tips
• ORA-01591: lock held by in-doubt distributed transaction tips
• ORA-01653: unable to extend table in tablespace tips
• ORA-01704: string literal too long tips
• ORA-01747 tips
• ORA-01779: cannot modify a column which maps to a non key-preserved table tips
• ORA-01795: maximum number of expressions in a list is 1000 tips
• ORA-01810: format code appears twice tips
• ORA-01840: input value not long enough for date format tips
• ORA-01841: (full) year must be between -4713 and +9999, and not be 0 tips
• ORA-01843: not a valid month tips
• ORA-01847: day of month must be between 1 and last day of month tips
• ORA-01861: literal does not match format string tips
• ORA-01925: maximum of string enabled roles exceeded tips
• ORA-01950: no privileges on tablespace tips
• ORA-02063: preceding string tips
• ORA-02068: following sever error tips
• ORA-02085: database link string connect to string tips
• ORA-02289: sequence does not exist tips
• ORA-02291: integrity constraint violated-parent key not found tips
• ORA-24338: statement handle not executed tips
• ORA-00600: internal error code, arguments string string string string string string string tips
• ORA-03120: two-task conversion routine: integer overflow tips
• ORA-04020: deadlock detected while trying to lock object stringstringstringstringstring tips
• ORA-04021: timeout occurred while waiting a lock object stringstringstringstringstring tips
• ORA-04052: error occurred when looking up remote object stringstringstringstringstring tips
• ORA-04062: string of string has been changed tips
• ORA-04088: error during execution of trigger 'string.string' tips
• ORA-06000: NETASY: port open failure tips
• ORA-06401: NETCMN: invalid driver designator tips
• ORA-06413: connection not open tips
• ORA-06508: PL/SQL: could not find program unit being called tips
• ORA-08103: object no longer exists tips
• ORA-12535: TNS: operation timed out tips
• ORA-12540: TNS: internal limit restriction exceeded tips
• ORA-12546: TNS: permission denied tips
• ORA-12547: TNS: lost contact tips
• ORA-12571: TNS: packet writer failure tips
• ORA-12638: credential retrieval failed tips
• ORA-14551: cannot perform a DML operation inside a query tips
• ORA-24323: value not allowed tips
• ORA-24324: service handle not initialized tips
• ORA-24338: statement handle not executed tips
• ORA-13199: Internal error tips
• ORA-25153: temporary tablespace is empty tips
• ORA-27100: shared memory realm already exists tips
• ORA-27102: out of memory tips
• ORA-28547: connection to server failed, probable Oracle Net admin error tips
• ORA-29280: invalid directory path tips
• ORA-29283: invalid file operation tips
• ORA-29532: java call terminated by uncaught java exception: string tips
• ORA-29807: specified operator does not exist tips
• ORA-30926: unable to get a stable set of rows in the source tables tips
• ORA-3113: end-of-file on communication channel tips
• ORA-6502: PL/SQL: numeric or value error tips

Oracle Articles by Mark Rittman

• OLAP query equivalence
• Oracle10g Rewrite_or_Error Hint
• SQL Access Advisor
• Bjørn Engsig On Bind Variables, Cursor Sharing And Oracle 9i - June 2004
• Naeem Hashmi On Embedding Real-Time Analytics - June 2004
• Richard Byrom's Oracle Applications Blog - June 2004
• Integrating Mapping and Spatial Data
• Oracle ETL with pipelined table functions
• Using External Tables
• Oracle Merge Command
• Data Warehouse Builder
• Web Services, BPEL And Oracle Data Warehousing
• OWB 10g Now Available For Windows
• Using HTMLDB For Oracle Reporting
• Integrating Web Services With Oracle BI Beans
• Having Discoverer Worksheets Write-Back To The Database
• Using A Model-Driven Approach For BI Projects
• Oracle Portal Wins Editor's Choice Award
• Jim Dilanni On The Future Of Oracle Certification - February 2004
• Twelve Silver Bullets For Oracle Performance Tuning - February 2004
• Arup Nanda On Building Firewalls Using Oracle Net - February 2004
• Don Burleson's Questions To Ask Your Applications Vendor - February 2004
• Online Interview With Matthew Symonds, Author Of "Softwar" - February 2004
• Has Anyone Got TOra 1.2.4 On Linux Working Against Oracle Database 10g? - February 2004
• Peter Walzer On Ensuring The Success Of BI Projects - February 2004
• Inline Views And Outer Joins - February 2004
• OWB 9.2.0.4 Patchset Now Available - February 2004
• New Oracle Security Alerts Page - February 2004
• Oracle 10g, 10gAS Now Available For Linux, Unix - February 2004
• Passed My Final Oracle 9i DBA OCP Exam - February 2004
• Speaker Details For The UKOUG Reporting Tools & BIW Special Event - February 2004
• Rajesh Gadodia On Tactical Vs. Strategic Data Warehousing - February 2004
• IT Managers' Journal On Oracle Licensing & Support - February 2004
• GFS, OCFS, and GPFS - Which Filesystem for Oracle? - February 2004
• Joe Celko On "Thinking In Aggregates" - February 2004
• Slashdot On The Squabble Between Sun And Eclipse - January 2004
• Oracle News From The KOMTAR, Penang - February 2004
• Agile Development Methodologies For DBAs - February 2004
• Thoughts on Matthew Symonds "Softwar" - February 2004
• Don Burleson On Speeding Up Oracle Data Loads - February 2004
• Philip Russom On The Decline Of The ODS - February 2004
• New OTN Paper On Oracle 10g Support For SQL 2003 - February 2004
• Notes On Sizing The Redo Log Buffer - February 2004
• Guide To Integrating OWB9.2 And Oracle Workflow - February 2004
• Using Bulk Binds And FORALL - January 2004
• Why Does Discoverer Create Two Dedicated Connections? - January 2004
• Joe Luedke On BI Barriers For Small & Medium Size Businesses - January 2004
• Improving PL/SQL Performance By Using Collections - January 2004
• Collections, Cursors, Bulk Binds and FORALL - January 2004
• Margy Ross On The Habits Of Effective Business Sponsors - January 2004
• Should Business Intelligence Be 'Real-Time'? - January 2004
• News On Next Version Of E-Business Suite - January 2004
• The Effect Of Eclipse And The JTC On BI Applications - January 2004
• Using Oracle 9i Table Compression For Star Schemas - January 2004
• Brian Duff's New Orablogs.com Site - January 2004
• Using Advanced Security And OID To Create A Database SSO Environment - January 2004
• Thomas Kurian On The Evolution Of App Server, Database - January 2004
• Ralph Kimball's "Data Warehouse Dining Experience" - January 2004
• News On Qubeview's "Plugin Architecture" - January 2004

Oracle Application Server Articles         OracleAS, Oracle 10gAS & Oracle9iAS

• Free Oracle Database 10g XE - November 2005
• Regular Expressions Everywhere - August 2005
• Securing Access to a Linux Server. - June 2005
• Putting Your Web Cache To Work: Cache Invalidation using PL/SQL - April 2005
• Integrating HTML DB with Oracle AS10g - March 2005
• Migrating Express Server Databases To 10g And Discoverer "Drake" - February 2005
• Compressed Composites Oracle 10g Compression Explained - February 2005
• BI Dashboards Using Discoverer "Drake" And BI Beans - February 2005
• Taking A First Look At Application Server 10g Release 2 - Mark Rittman - January 2005
• Fixing Startup Failures After A Server Crash - John Garmany - January 2005
• Application Server Release 2 - John Garmany - January 2005
• More Great Presentation from Oracle Open World - John Garmany - December 2004
• The Future of Forms - John Garmany - December 2004
• Oracle Open World 2004 - AS 10g Release 2 Announced - John Garmany - December 2004
• Application Server 10g Standard Edition One Announced - John Garmany - November 2004
• Roll Your Own STATSPACK with DMSTool - John Garmany - November 2004
• Harness the Power of Oracle's Web Cache - John Garmany - Oct 20, 2004
• Supercharge Dispersed Offices with a Remote Web Cache - John Garmany - Oct 13, 2004
• Application Server 10g Backup and Recovery Tool - John Garmany - Oct 6, 2004
• Windows Service Not Starting Your Database? - John Garmany - Sept 29, 2004
• Hosting Multiple Web Sites - John Garmany - Sept 22, 2004
• Automating Deployments from JDeveloper to AS10g - John Garmany - Sept 15, 2004
• Cookbooks For Oracle On Linux - John Garmany - Sept 8,2004
• Security Patch Released - John Garmany - Sept 1,2004
• Using a Remote Web Cache with Application Server 10g - John Garmany - Aug 25,2004
• Deploying an HTML Web Site on Application Server 10 - John Garmany - Aug 18,2004
• Installing the AS 10g and the 10g Database on Fedora Core 2 - John Garmany - Aug 11,2004
• 34 Oracle Security Flaws Just Discovered - John Garmany - Aug 4th, 2004
• Oracle Internet Files System Desupport Notice - John Garmany - July 28, 2004
• New Pricing Scheme for Oracle AS10g and Certification Stalls  - John Garmany - July 21, 2004
• Take the Oracle Web Development Quiz - John Garmany - July 14th,2004
• Building OracleAS Portlets Using Apache Struts - Mark Rittman - July, 2004
• Placing the Metadata Repository in an Existing Database - John Garmany - July 7, 2004
• Alert - Oracle Announces End of Support Date For 9iAS - John Garmany - June 23, 2004
• Oracle AS10g Start Failure on Windows - John Garmany - June 16th, 2004
• Alert - Serious Oracle Vulnerability Patch - John Garmany - June 9th, 2004
• Oracle's Support For AMD 64bit Opteron Processors - John Garmany - June 2nd, 2004
• Logs, Logs Everywhere - John Garmany - May 26th, 2004
• What is an ETL process - John Garmany - May 21, 2004
• Oracle Streams and ETL - John Garmany - May 21, 2004
• Oracle10g and Data Change Capture - John Garmany - May 21, 2004
• Red Hat Advanced Server Clones - John Garmany - May 12, 2004
• Free Oracle10g poster released - April 12, 2004
• Restarting after Oracle9iAS application server crash - John Garmany - April 7, 2004
• Security patch for Oracle web cache - John Garmany - March 24, 2004
• Over-installing Oracle Application Server - John Garmany - March 24, 2004
• Free Oracle App Server tuning Webcast - March 17, 2004
• Setting the UNIX path for app server - John Garmany
• Enabling SSO Support For Discoverer 9iAS - Mark Rittman
• Oracle Application Server 10g Features - Mark Rittman
• Web Services With Oracle BI - Mark Rittman
• Securing Data Warehouse with Advanced Security and OID - Mark Rittman
• Building Portal Applications Using Remote Database Links - Mark Rittman
• Using The OWB Design Browser With The Standalone OC4J Instance - Mark Rittman
• Integrating Discoverer 9iAS SSO Logins With 9i Database Logins - Mark Rittman
• Troubleshooting Oracle Portal - Mark Rittman
• Tips for installing 9.0.4 on United Linux - Mark Rittman
• Authenticating Discoverer 9iAS Against A Non-Oracle LDAP Server - Mark Rittman
• Using advanced security and OID to create SSO database - Mark Rittman
• Standard UNIX profile for Oracle App Server users - February 25, 2004
• Connecting with mod_osso - January 23, 204
• Overview of Oracle9iAS tuning - November 25, 2003
• Oracle9iAS monitoring - December 3, 2003

Oracle Articles tip Archive         Oracle articles from the major portals

• Oracle Software saving lives - January 2006
• Oracle10g release 2 sorting improvements - 10g sort performance - December 2005
• Oracle Systems threatened by Patent Infringement Lawsuits - December 2005
• Oracle multi-master replication with Oracle Streams - November 2005
• Oracle OS watcher OSWatcher utility - November 2005
• Oracle Worm may evolve into a threat - November 2005
• Oracle 10g release 2 load balancing features - August 2005
• New sources for Oracle 10g scripts - June 2005
• Inside Oracle Wait Time Tuning - June 2005
• Inside distributed Oracle Parallel query - October 2005
• Understand your responsibilities in technical blogs and forums - June 2005
• Oracle exposures and Google Hacking - June 2005
• Do your indexes suffer from sparse blocks? - May 2005
• Beware of using RAC with a data warehouse - June 2005
• Hot tip for Oracle cardinality errors - May 2005
• Oracle Silver Bullets Book is now ready - May 2005
• Clusters and cohort groups - June 2005
• Amazing Oracle 10g benchmark with a terabyte of RAM - September 2005
• Oracle SQL optimizer cost model - April 2005
• All about beer and diapers - August 2005
• For Managers Only – Conducting the Programmer Job Interview - August 2005
• Undocumented parms for using CPU-based SQL optimization - August 2005
• College equivalencies interview nightmares - March 2005
• Oracle users rave over multiple buffer caches - July 2005
• College Degree (or equivalent experience) required - July 2005
• Tuning multi-block I/O in Oracle - July 2005
• New Amazon SIP helps you search Oracle Books - June 2005
• Indexes - Rebuilding and using multiple blocksizes - May 2005
• The importance of clustering_factor in multi-block I/O - May 2005
• Are you wrong to schedule table and index reorganizations? - May 2005
• Oracle Offshoring a Failure for Many Companies - April 2005
• Intelligent Oracle 10g DBA Maintenance - April 2005
• Prove that index rebuilds and table reorgs improve performance - February 2005
• How does hardware affect Oracle performance? - April 2005
• Oracle SQL Developer
• Oracle certification tips
• Tuning Oracle Parallel Query Execution - March 2005
• Oracle Performance Bug – Check your cpu_count setting - March 2005
• Optimize Oracle backup time duration - March 2005
• Are all scientists created equal? - February 2005
• Predictive modeling in Oracle 10gr2 - February 2005
• A peek at Oracle 10g Release 2 - January 2005

• Oracle Third-party tuning tools - January 2005

• A peek at Oracle 10g Release 2 - March 2005

• Hypercharge complex Oracle LIKE searches with text indexes - March 2005

• Hypercharge ETL with Oracle Data Warehouse "exchange partition" functionality - March 2005

• Oracle DBA job skills - February 2005

• Reduce I/O with Oracle cluster tables - February 2005

• Improve performance with multiple blocksizes - December 2004

• Burleson webcast on 64-bit Oracle for Windows & Linux - December 2004

• Internals of Oracle redo log management - January 2005

• Robert Freeman joins Burleson Consulting - January 2005

• Oracle bitmap index tricks - January 2005

• Oracle Virtual Indexes - December 2004

• Oracle University tips

• Oracle enhancements & new features by Oracle release - December 2004

• Oracle8i to Oracle10g migration a popular option - December 2004

• Gartner Group Concerned about Oracle Security Patch Number 68 - November 2004

• Oracle10g wait event tuning book published - November 2004

• New Oracle publisher dominates market - November 2004

• Why does Oracle performance go bad after a migration? - December 2004
• Google Print boom for Oracle Professionals - December 2004
• Oracle Fraud Alert - November 2004
• New insights into SQL resource usage - November 2004
• New redo log sizing advisor in Oracle10g - November 2004
• SQL WHERE clause order can be important to performance! - November 2004
• Oracle Linux (UNIX) or Oracle Windows? - November 2004
• Oracle Disk Load Capacity - October 2004
• world's most widely-read security security expert speaks on Oracle server hacking - November 2004
• Disks and Oracle  - October 2004
• Oracle Professionals plan for the Future. . . Winners announced!  - October 2004
• File System Mount Options and Oracle - October 2004
• Oracle Failover Options - October 2004
• Oracle and RAID Usage - October 2004
• Don't waste RAM on 32-bit Oracle Windows servers - October 2004
• The Importance of Join Order - October 2004
• Oracle terms with multiple meanings - October 2004
• Microsoft announces new shell programming language - September 2004
• Index Column Order Does Matter - September 2004
• Oracle Professionals plan for the Future - September 2004
• Fixing Corrupt System Managed Undo Segments - September 2004
• Oracle on Windows makes inroads - September 2004
• Detecting Oracle Overload - September 2004
• The changing role of the DBA - September 2004
• Oracle issues critical technical alert on 8/31 - September 2004
• Oracle10g Intel itaniun 64-bit windows -  August 2004
• Fast Guide: Solving common Oracle errors - SearchOracle.com - August 2004
• Some words on tuning the Apache server - August 2004
• Creating A Cascade Update Set of Tables - August 2004
• 34 Oracle PL/SQL security exposures found - August 2004
• Tune sub-optimal SQL with function based indexes - August 2004
• Oracle SQL query monitor index use - August 2004
• The best Oracle DBA forum - September 2004
• Easy Oracle export/import with Excel Spreadsheet - August 2004

• Oracle gurus answer your Oracle questions - September 2004

• Oracle10g Intel itaniun 64-bit windows - Oracle 10g - August 2004

• PCTFREE and PCTUSED - August 2004

• INITRANS, MAXTRANS, FREELISTS and FREELIST GROUPS - July 2004

• Check your Oracle license compliance - July 2004

• Oracle10g PL/SQL speed improvements - July 2004

• Format HTML output from SQL*Plus - July 2004

• Intel threatens to change Oracle OS platforms - July 2004

• Free Oracle SQL Tuning Secrets Webcast - June 2004
• Oracle Windows AWE Data Buffer Size - July 1, 2004
• New ORA-600 error message lookup on MOSC - June 2004
• Mike Ault on 10g RBO tips - June 2004
• Use direct I/O with all Oracle databases - May 2004
• Choose the right disk configuration for Oracle - May 2004
• Migrate to CBO - May 2004
• New SQL tracing utility - May 2004
• Oracle10g new features Webcast - June 8, 2004
• UNISYS and Rampant offer free Oracle10g reference poster - April 2004
• Setting AWR data retention thresholds - April 8, 2004
• Oracle announces controversial 2-day DBA training - April 6, 2004
• Important costs for 10g diagnostic and tuning packs - March 2004
• Speeding up Oracle logical I/O - March 30, 2004
• Benchmarks using large data buffer cache and multiple blocksizes - March 29, 2004
• Proving Oracle behavior - March 23, 2004
• Try-out Oracle10g Windows on your PC today - March 23, 2004
• Free Oracle9iAS tuning Webinar - March 18, 2004
• Track I/O for specific Oracle tables & Indexes - March 16, 2003
• Oracle10g new utl_mail PL/SQL e-mail package - March 12, 2004
• Oracle10g beats SQL Server - March 9, 2004
• Get your OCP fast to avoid training requirement - March 2, 2004
• Get 250.000 TPM with Oracle10g on Windows - February 25, 2004
• Which OS is right for you? - February 19, 2004
• Oracle Headline News Announced - February 5, 2004
• Linux NFS configuration services - February 3, 2004
• New Oracle-L - February 10, 2004
• Super fast database copying - February 24, 2004
• New rules for Oracle10g Grid data buffer management - February 19, 2004
• Hypercharge Oracle table inserts - February 17, 2004
• Should we re-analyze our schema? - February 12, 2004
• Oracle10g New Features Book downloads available - February 10, 2004
• DBA unemployment tops 6% - February 10, 2004
• Super-size RAM with _smm_max_size parameter - February 5, 2004
• Sequence for using dbms_stats - February 3, 2004
• Oracle10g now available - February 3, 2004
• Rewrite Oracle SQL sub-queries for faster performance - January 29, 2004
• Super fast Oracle with SSD - January 27, 2004
• Court decision may effect millions of Oracle web applications - January 20, 2004
• Oracle10g breaks record for speed - January 15, 2004
• Document Oracle Performance Changes - January 13, 2004
• Oracle physical Security - January 8, 2004
• Recover from lost root password - January 6, 2004
• Insist your your rights with vendor systems - December 30, 2003
• Oracle features and prices - December 25, 2003
• Oracle failover options - December 23, 2003
• Report excessive chained row fetches - December 18, 2003
• Automatic Histogram detection with dbms_stats - December, 16, 2003
• Beware of small-table full-table scans - December 11, 2003
• Battle Against any RAID-5 for Oracle - December 9, 2003
• Oracle Standard Edition( SE) features vs. Oracle Enterprise Edition (EE) - December 2, 2003
• Oracle Standard Edition One - October 21, 2003
• Oracle Structures and How They Affect Installation - October, 2003
• Cold Backups - October, 2003
• Free Oracle Goodies - November 7, 2003
• Index on NULL index columns - November 4, 2003
• Mike Ault releases his Oracle scripts - November 3, 2003

• OracleWorld 2003 presentations downloads free on OTN - September 18, 2003

• Ellison speaks out on Oracle10g Grid Computing - September 19, 2003

• Update on RBO in Oracle10g - September 10, 2003

• Rule-based SQL optimization de-supported in Oracle10g - September 5, 2003

• OracleWorld 2003 Update - September 5, 2003

• Performance Tuning Webcast, Part 3 - September 3, 2003

• Oracle9i XML Security Exposure Patch - August 24, 2003

• Performance Tuning Webcast, Part 2- August 26, 2003

• Performance Tuning Webcast, Part 1- August 21, 2003

• Justify your Oracle partitioning project - July 22, 2003

• Inside the Oracle SGA regions - July 31, 2003

• Oracle9i sorting enhancements - July 29, 2003

• Find top Oracle sessions - July 24, 2003

• Examine Oracle global I/O - July 22, 2003
• Find Oracle physical database design flaws - July 17, 2003
• Find sub-optimal Oracle SQL - July 15, 2003
• Proper size your PGA with PGA advice utility - July 10, 2003
• Oracle Performance Checklist - July 8, 2003
• Oracle9i RAC - Cluster file system & raw devices - July 3, 2003
• Hypercharge Oracle SQL*Loader and imp speed - July 1, 2003
• Automatically assign Oracle tables & indexes to the KEEP pool - June 26, 2003
• At last, Oracle humor articles! - June 19, 2003
• Oracle v$shared_pool_advice shared pool advisory utility - June 24, 2003
• Improve Oracle indexes - build faster, smaller & better balanced indexes - June 16, 2003
• Oracle vs. SQL Server comparison - June 10, 2003
• New Oracle Certification Program being offered - June 6, 2003
• Free Webinar Thursday June 5, 2003 - June 4, 2003
• Proof that Large Index Blocksizes Reduce I/O - May 26, 2003
• Find the exact block causing a hung session - May 18, 2003
• Automate histogram analysis with dbms_stats - May 14, 2003
• Quickly improve SQL performance with dbms_stats - May 6, 2003
• Using dbms_metadata. get_ddl to punch Oracle table & index syntax - May 6, 2003
• How to predict I/O reduction from a larger data cache - May 2, 2003
• Ted Codd, father of the relational database, dead at 79 - April 22, 2003
• Oracle and Oracle9iAS developers must comply with the ADA - April 19, 2003
• Oracle9i WebDAV to compete with Microsoft - April 17, 2003
• Your Oracle cpu_count is important - April 12, 2003
• Freelists vs. Freelist groups - April 9, 2003
• Oracle Linux vs. Oracle Windows - March 29, 2003
• Optimize your Oracle PGA Regions - March 24, 2003
• Don't use the OPTIMAL parameter in RBS - March 18, 2003
• Is your Oracle system in compliance with the ADA? - Pending
• Oracle SQL test for OCP is now un-proctored - March 9, 2003
• Control optimizer permutations with _optimizer_search_limit - February 26, 2003
• Are you hiring the right Oracle Professional? - February 22, 2003
• Setting optimizer_index_cost_adj - February 9, 2003
• Migrating to the cost-based SQL optimizer, part 1 - January 31, 2003
• Slammer virus cripples Oracle web traffic - January 25, 2003
• Oracle8i de-supported in 2003 - January 23, 2003
• STATSPACK now required for some iTars - January 19, 2003
• New Oracle Trace Analyzer from Carlos @oracle.com  - January 16, 2003
• Great new Oracle Corporation Oracle SQL utility - January 14, 2003

Freeman Oracle Tips Archive

• Oracle read-only tablespaces and performance - June 2005

Oracle Articles & quick tips

Donald K. Burleson holds a BA degree in Psychology and a Masters Degree in Business Administration with a concentration in Information Technology from the University of New Mexico.  Burleson has published numerous articles in academic journals including "Information and Management" and has authored more than 30 books on database technology with McGraw-Hill, Wiley Publishing, CRC Press, O'Reilly and Rampant TechPress.  Burleson is considered an expert in information systems architecture and database management and has published more than 100 articles in major IT trade publications and periodicals.

·         "host" command Tips - 21 February 2014

·         _adaptive_direct_read tips - 7 June 2015

·         _awr_flush_threshold_metrics tips -  21 November 2015

·         _close_cached_open_cursors tips - 20 February 2014

·         _convert_set_to_join tips - 8 April 2014

·         _db_block_cache_protect tips -  21 November 2015

·         _index_prefetch_factor Tips -  11 March 2014

·         _optimizer_better_inlist_costing Tips - 19 July 2015

·         _optimizer_cost_based_transformation tips - October 26, 2007

·         _optimizer_extend_jppd_view_types tips -  27 January 2015

·         _optimizer_group_by_placement tips -  27 January 2015

·         _serial_direct_read tips - 7 June 2015

·         _sys_logon_delay tips - 3 March 2014

·         _very_large_object_threshold tips - 7 June 2015

·         10g new features

·         11g Cube-organized Materialized View tips -   November 14, 2007

·         11g extended optimizer statistics - December 13, 2007

·         11g new features peek

·         11g SQL execution plan management tips - December 13, 2007

·         11g SQL Plan baseline tips - January 16, 2008

·         2007 trends in Oracle web security management - December 10, 2007

·         A brief history of database disk storage - October 28, 2007

·         A brief history of database RAM storage - October 28, 2007

·         A Top Linux command book

·         Access alert log with SQL

·         Access Violation in ora80-5.dll from SQL*Forms 6i

·         access.sql script to see execution plan details

·         Accessing Trace Records

·         Activate Oracle Client Caching for OCI Applications - 9 August 2015

·         Add a bucket to a frequency histogram - 14 May 2015

·         Add Constraint Oracle

·         Add space to Oracle tablespace - 29 April 2015

·         Add Streams replication to new server node - 11 January 2015

·         Adding animated pictures to PowerPoint Presentations

·         Adjusting STATSPACK Collection levels

·         Aegis Oracle Tips

·         afiedt.buf Tips - 21 February 2014

·         After Oracle 10g - What comes next?

·         Ahmed Baraks's summary of oracle 10g features

·         AIX: 32-bit or 64-bit? - November 12, 2007

·         Alert log shows no standby redo logfiles tips

·         alert log tips - 3 March 2014

·         All Oracle 8i hidden parameters

·         alter database move datafile <number> tips - 4 January 2015

·         Alter Oracle for autoextend on

·         Alter table column from LONG to CLOB Tips -  11 November 2015

·         alter table monitoring Tips -  7 March 2014

·         Alter Tablespace Add Datafile

·         Alter User Oracle

·         alter_database_tab_monitoring

·         alter_schema_tab_monitoring

·         Alteration of Databases

·         Altering Oracle sequences

·         AMM resize scripts - 26  October 2015

·         and-equal data access method

·      Anonymous Block Tips

·         ApEx (HTML-DB) release 3 new features

·         Application Page to use a JavaScript multi-level menu list

·         aq_tm_processes Tips -  15 March 2014

·         Archiving Oracle Data in easily restorable non-Oracle structures

·         Archiving Oracle table audit data with partitioned tablespaces

·         Are Podcasting and RSS considered Broadcasting?

·         Array, TAF & load/unload features of DBI/DBD::Oracle

·         ASM add volume command -  28 May 2015

·         ASM Template Tips -  29 January 2015

·         ASM vs filesystems   - 13 November 2015

·         asmcmd tips

·         Assigning Oracle user security roles

·         Assigning weights for a multi-column Oracle text index - January 18, 2008

·         ASSM, freelists and PCTFREE

·         AU size and stripe size tips - 21 December 2015

·         audit_file_dest adump tips - 14 February 2014

·         Audit_trail parameter tips - 21 May 2015

·         auditing concepts webcast

·         Auditing Oracle eBusiness Suite Financials

·         Ault & Burleson to give Predictive Modeling Seminar

·         authid & definer rights tips - 5 January 2015

·         authid & invoker rights - 5 January 2015

·         Automated Storage Management ASM configuration

·         Automatic speech/voice recognition software for the Oracle professional - January 19, 2008

·         Automating Oracle Data cleansing approaches

·         Autonomous Transaction

·         AWR and SQL Tuning

·         AWR Report CPU Analysis - 20 February 2015

·         AWR report for RAC Tips - 17 December 2015

·         AWR Top 5 foreground events script - 10 November 2015

·         Backup Oracle tips - 26 March 2014

·         Backup VLDB tips - 26 March 2014

·         bash .profile for Oracle  - 28 April 2015

·         BC Oracle cruise

·         BC Oracle data security policy

·         Becoming an Oracle expert

·         Best Oracle Security Book

·         best webserver hardware configuration tips

·         Beware of Oracle's ease of use! -  November 13, 2007

·         Beware of profiteer database users groups

·         Bi-directional Streams replication

·         Bigfile and Smallfile Performance - 3 October 2015

·         bind_aware hint tips - 12 February 2015

·         Biometric fingerprint scanners planned for credit card authentication

·         Bizgres tips

·         Black Arabian Stallion

·         Blocking Oracle access by IP Addresses

·         blockrecover command tips  -  10 July 2015

·         British Bloggers face journalist standards when web publishing

·         Buffer busy waits and I/O contention

·         buffer pins Tips - 14 March 2014

·         Burleson scuba divers

·         caching dual table

·         Calculating Oracle average row length

·         Camera interfaces with Oracle

·         Can Discoverer "Drake" Replace Discoverer Desktop?

·         Can you do Oracle data warehousing on Standard Edition?

·         Cannot allocate new log - Private strand flush not complete - October 19, 2007

·         catio.sql io_per_object sample_io

·         Cemutlo tips - 20 December 2015

·         Chain together Oracle jobs - 29 April 2015

·         chained rows by session Tips - 21 March 2014

·         Change column order within Oracle table -  23 May 2015

·         change current directory from SQL*Plus - 29 January 2014

·         Change long raw datatype to character column - 14 December 2015

·         Change nls_date_format at login time - 29 January 2014

·         Change Oracle environment in UNIX/Linux - 28 April 2015

·         Change Oracle IP and Domain DNS Tips

·         Change system date on Oracle server Tips -  9 March 2014

·         Change the SQL*Plus Default Display Width

·         Changing hidden characters with UNIX vi

·         Changing remote login passwordfile September 6th, 2007

·         Changing table index maxextents unlimited

·         Check & verify Oracle windows services

·         Clandestine Oracle support for OCP's

·         Cleanout job script to remove archived redo logs trace & dump files

·         clonedb utility Tips - WIP

·         Cloning a large terabyte RAC database

·         Cloning an Oracle user

·         Cloning ORACLE_HOME Tips - 21 March 2015

·         coe_xfr_sql_profile.sql tips - 23 March 2014

·         ColdFusion Oracle PL/SQL in cfset tag

·         Command to count Oracle databases on a server

·         Common Linux command line alias settings for Oracle

·         Common Oracle performance problems

·         Communications skills for Oracle professionals

·         Compare Oracle Database Tips - 4 November 2015

·         Composite partitioning tips - 17 February 2014

·         Composite partitioning tips - 17 February 2014

·         Compress Oracle tablespaces - 26 March 2015

·         Compressing Oracle backups and data files

·         Compute Oracle index statistics

·         Computer book authors agencies and computer book agents

·         Computing Oracle percent (%) used for tablespaces

·         Concepts and goals of Oracle data scrubbing

·         concsub utility tips - 3 March 2014

·         Concurrent manager job scheduling utility

·         Configuring oracle network

·         Connect Oracle to SQL Server

·         Connecting to a hung database with the -prelim option - 29 March 2014

·         Connecting to Oracle with the Perl DBI

·         Consolidation of Oracle Audit Data sources

·         control_management_pack_access Tips  - 12 March 2014

·         Convert BLOB to CLOB script - 21 November 2015

·         Convert excel files into Oracle Tables - 8 May 2015

·         Convert Oracle BLOB to XML Type -  7 March 2014

·         Convert Oracle dmp file -  23 March 2015

·         Convert VARCHAR2 to CLOB Tips - 8 May 2015

·         Converting Oracle rows to columns

·         copy Oracle table into MySQL database

·         copy Oracle tables between schemas - 6 June 2015

·         Corporate e-mail spam rules

·         Corporate Information Technology (IT) budget planning

·         Count all SQL accessing a schema - 14 June 2015

·         count trace files - 14 July 2015

·         counterintelligence-scope CI polygraph

·         Counting Oracle tables

·         CQL tips - 30 June 2015

·         Create Database Link Oracle

·         Create index Performance Speed Tips -  8 March 2014

·         Create or Replace Procedure

·         Create Schema

·         create table using CTAS tips - 31 March 2014

·         Creating an Oracle Data Cleansing Architecture

·         Criminals offer shilling bidding service for eBay

·         crsctl modify resource tips  - 16 February 2014

·         CTAS table reorg

·         ctx_indexes tips - 8 July 2015

·         current trace file Tips - 17 November 2015

·         current_schema Tips - 5 May 2015

·         cursor: pin S wait on X Tips - 1 May 2015

·         Custom SQL*Plus prompt tips - 17 March 2014

·         Data buffer hit ratio for multiple data buffer pools - 7 November 2015

·         Data Dictionary catalog scripts

·         Data format validation with Oracle regular expressions

·         Data Guard FastSync Tips - 15 March 2014

·         Data guard switchover with dgmgrl

·         Data Guard: archive log target fix

·         Data Masking Pack tips - 31 March 2014

·         Data Pump "where" clause Tips - 7 October 2015

·         Data Pump Import/export parallel tips - 17 December 2015

·         data pump transform tips - 21 August 2015

·         Data Pump version option tips - 3 April 2014

·        
Data redaction tips

·         Data Unification & Cleansing with Oracle

·         data warehouse features by release

·         Database benchmarking tips

·         Database Consultant

·         Database Consultants

·         Database link from Oracle to SQL Server

·         database security auditing

·         Database size by day tips - 21 December 2015

·         Database size by month tips - 21 December 2015

·         Database sizing for Oracle tips - 2 March 2014

·         database_trace_enable tips - 22 February 2014

·         dateline adoption scams fraud

·         db_cache_size

·         db_file_multiblock_read_count

·         db_file_noncontig_mblock_read_count Tips -  11 March 2014

·         db_writer_processes Tips -  25 April 2015

·         DBA job title hierarchy tips - 12 February 2014

·         dba_advisor_findings procedure

·         dba_autotask_client tips - 13 September 2015

·         dba_dml_locks Tips - 10 December 2015

·         dba_editioning_views tips - 4 April 2014

·         dba_extents scripts tips - 7 July 2015

·         dba_hist_resource_limit Tips - 7 December 2015

·         dba_hist_service_wait_class Tips - 7 November 2015

·         dba_hist_sysstat tips - 14 July 2015

·         dba_hist_wr_control tips -  17 March 2014

·         dba_tab_subpartitions tips - 3 April 2014

·         DBCA database name display Tips - 3 January 2015

·         DBGSQL Tips - 4 February 2015

·         DBI and Oracle

·         dbms_aqadm.create_queue example - 24 March 2014

·         dbms_aqadm.create_queue_table example - 24 March 2014

·         dbms_auto_task_admin tips

·         dbms_backup_restore tips - November 6, 2007

·         dbms_datapump name_expr tips - 24 February 2014

·         dbms_datapump name_list tips - 23 February 2014

·         dbms_ijob Tips - 21 March 2014

·         dbms_job vs. dbms_scheduler

·         dbms_job.broken tips

·         dbms_job.remove tips

·         dbms_job.submit Tips - 10 November 2015

·         dbms_lob.converttoclob Tips -  7 March 2014

·         dbms_lob.writeappend to join BLOB columns

·         dbms_metadata tips

·         dbms_mtune

·         dbms_outfut.put_line

·         dbms_parallel_execute tips - 11 February 2014

·         DBMS_QOPATCH Tips - 16 March 2014

·         dbms_scheduler replaces cron for shell scripts

·         dbms_shared_pool.keep

·         dbms_shared_pool.markhot tips - 24 March 2014

·         dbms_stats collection frequency scripts - 22 September 2015

·         dbms_stats.gather_fixed_objects_stats tips

·         dbms_stats.gather_system_stats and SQL optimizer behavior

·         dbms_stats.report_stats_operations tips - 21 August 2015

·         dbms_stats.set_system_stats -  7 March 2014

·         dbms_sys_sql Tips - 21 March 2014

·         dbms_warning usage tips

·         dbms_xmlquery vs. dbms_xmlgen

·         dbnewid tips - 13 February 2014

·         DBWR Tuning Tips

·         DDL over a db link tips - 5 November 2015

·         Decompiling Oracle Java decompiler

·         Decreasing log file sync waits

·         Dedicating CPU processors - Oracle affinity

·         default ORACLE_HOME location on Windows - 21 March 2015

·         Defending against web content theft

·         Definition: Ya Boo Sucks to you

·         Delete archived redo logs scripts - 26 March 2014

·         Delete duplicate rows - Deletion from Oracle tables

·         Delete multiple duplicate rows - 8 February 2014

·         descending index tips - 25 March 2014

·         Designing object-oriented type hierarchies in Oracle tables

·         Detecting duplicate Oracle indexes

·         Diagnosing the ORA-12537: TNS: connection closed error

·         Dictionary queries have very poor performance

·         Dictionary query to display function-based index function

·         Difference between Oracle Applications 11i and 12

·         Difference between Oracle DBA and Oracle Apps DBA - 31 December 2015

·         Difference between Oracle DBA and Oracle Apps DBA -  29 December 2015

·         Difference between rman and Oracle Secure Backup -  29 January 2015

·         Difficulty with Host Credentials in Linux September 10th, 2007

·         Dimensionless Star Schema (Bitmap Star)

·         direct export to remote database tips - 4 August 2015

·         disable Oracle 10g statistics collection

·         Disable Oracle Dynamic Sampling

·         Disable Oracle job Tips -  26 May 2015

·         disable table lock tips - 7 April 2014

·         Disabling AWR data purging - 25 March 2015

·         Disabling hash joins - 21 February 2014

·         Disabling sort merge and hash joins tips - 8 April 2014

·         Discoverer "Not all rows have been retrieved. Data may be inaccurate" tips

·         Discoverer: The server is running low on virtual memory tips

·         Disk Average Failure Rate (AFR)

·         Disk to LUN I/O performance on SAN and NAS

·         display composite indexes Tips - 8 November 2015

·         Display current directory from SQL*Plus - 29 January 2014

·         Display database links tips -  3 February 2014

·         Display Oracle concurrent manager processes

·         Display Oracle locks - locked rows for a user

·         Display Oracle SQL output rows on one single line

·         Display ORACLE_HOME tips - 30 June 2015

·         Display RAC Interconnect Details

·         Display similar SQL tips  - 2 February 2014

·         Display SQL plan outline - 23 March 2014

·         Display SQL Server database waits

·         Display SQL Server log errors

·         Display SQL Server RAM memory buffer cache

·         Display SQL Server session hogs

·         Display SQL Server storage filegroups script

·         Display SQL Server table I/O

·         Display tables in other schemas

·         Displaying RAM usage for SQL execution plan steps

·         Don Burleson speaks on 11g gotchas - October 15, 2007

·         Donald K. Burleson expert systems, decision support systems and AI experience

·         Downgrading Oracle - Downgrade tips

·         Dropping and deleting Oracle histograms - 22  October 2015

·         Dumping ASH Data to a Flat File tips -  7 April 2014

·         dupgdiag.sql Tips -  15 March 2014

·         duty security model tips - 16 March 2014

·         Eastern Caribbean Oracle Users Group 2007 Speakers

·         Easy formatting of Oracle SQL

·         Easy Oracle web searching

·         eBay and illegal ebook/software downloads

·         eBay fights States who enforce auctioneer license requirements

·         edit spfile tips - 20 March 2014

·         Elite Oracle Tips

·         Enable trigger tips - 2 July 2015

·         enable_ddl_logging Tips - 6 February 2014

·         Enabling AMM in 10g

·         Encrypt BFILE column Tips -  26 November 2015

·         encryption_pwd_prompt - 21 August 2015

·         endian format Tips - 4 May 2015

·         enqueue memory scripts - 13 July 2015

·         Entity Relation Diagram (ERD) tools for Oracle databases

·         Equivalent of exp consistent=y in expdp - 19 February 2014

·         ERROR 45 Initializing SQL*PLUS Internal Error

·         Error: dbconsole java.lang.exception: no such metric September 11th, 2007

·         Estimate Oracle Index Size

·         Estimate Space used by an Oracle Index

·         Estimating SGA size tips

·         Estimating the costs of Oracle data exposure

·         etc/group tips - 25 February 2014

·         ETL with pipelined table functions & external tables

·         Excel Database tips

·         Excluding Tables from Full Exports September 12th, 2007

·         execute immediate causes insufficient privileges over a database link   - 8 May 2015

·         Execute Immediate on Large Insert Strings

·         Execute operating system commands in Oracle

·         Executing SQL with the Oracle Perl DBI

·         exp imp tables

·         EXP: ORA-01036:illegal variable name/number

·         EXP-00002 tips - December 19, 2007

·         EXP-00008: ORACLE error 1455 encountered Tips  - 13 December 2015

·         EXP-00008: ORACLE error 904 encountered tips

·         EXP-00056: ORACLE error 942 encountered database link

·         EXP-00091 Exporting questionable statistics tips

·         expdp data pump compression_algorithm - 21 August 2015

·         expdp data pump disable_archive_logging - 21 August 2015

·         expdp dmp file location - 9 September 2015

·         expdp encrypted export tips -   18 March 2014

·         expdp encryption_mode tips -  18 March 2014

·         expdp exclude tips - 25 February 2014

·         expdp flashback_time tips - 20 February 2014

·         Expdp Impdp Network_Link Tips - 5 November 2015

·         expdp include tips - 25 February 2014

·         expdp view_as_tables Tips - 3 January 2015

·         Export a view Tips  - 12 March 2014

·         export import from Solaris to Linux - 13 November 2015

·         Export in excel format tips - 2 March 2014

·         Export table and index definitions only - 16 November 2015

·         Export table to csv Tips- 21 December 2015

·         Export to csv file Tips - 12 December 2015

·         Export with VPD Tips   - 12 March 2014

·         Extended cursor_sharing tips - 12 February 2015

·         extproc for Oracle tips - 10 April 2014

·         Extract SQL from AWR tips - 25 February 2014

·         Extract SQL from Oracle - 14 January 2015

·         ezconnect Tips - 22 March 2015

·         Far Sync Data Guard Tips -  23 July 2015

·         FAS 48 and income statements for publicly held corporations

·         Fast copying of Oracle table data Tips - 23 March 2014

·         fatal ni connect error 12170 Tips - 7 November 2015

·         final_blocking_session & final_blocking_instance Tips - 23 March 2014

·         Find all Oracle instances on a server - 3 March 2014

·         Find all Oracle listeners on a server - 3 March 2014

·         Find corrupt blocks in Oracle - 28 February 2014

·         Find disk constrained Oracle instance - 5 July 2015

·         Find gaps in Oracle sequences - October 26, 2007

·         Find Location of Oracle redo logs on Windows - 10 December 2015

·         Find long running SQL queries - 16 February 2014

·         Find max file size in partitioned table tips - 9 April 2014

·         Find movie show times fast

·         Find objects inside block tips - 12 July 2015

·         find oracle corruption - 15 November 2015

·         Find Oracle locked users -  6 March 2014

·         Find Oracle RAC Locks

·         Find ORACLE_HOME - 8 September 2015

·         Find ORACLE_SID - 8 September 2015

·         Find partition for a row tips - 19 September 2015

·         Find recently executed SQL - 5 November 2015

·         Find SQL with most updates -  29 May 2015

·         Find SQL*Plus file path  - 7 February 2015

·         Find tables referenced inside PL/SQL stored procedures

·         Find tables that do not belong in the SYSTEM tablespace - 22 January 2015

·         Find the Last Accessed Date for an Oracle Discoverer Workbook

·         Find the length of a CLOB - 14 March 2014

·         Find the threshold for large tables and small tables

·         Find the threshold for large tables and small tables - November 14, 2007

·         Find top indexes by size tips  - 1 March 2014

·         Find top tables by size tips - 1 March 2014

·         Find top tables tips - 1 March 2014

·         Find trace file in Oracle tips - 10 November 2015

·         Find unused columns with dba_unused_col_tabs

·         Finding Oracle business intelligence experts

·         Finding oracle locked objects -  9 March 2014

·         Finding Oracle materialized view opportunities

·         Finding Oracle Tuning experts

·         fingerprints as tables primary keys

·         fired for web surfing

·         First_rows tips - 19 February 2015

·         Fix high "cache buffer chain" waits

·         Fix Oracle mutating table errors

·         Fix Oracle swapping on AIX

·         Fix shared pool latch contention - 9 February 2015

·         Fix SQL*Loader date format errors

·         fixing Oracle broken jobs

·         Fixing slow connection problems in 10g

·         Fixing unexpected performance degradation caused by sub-optimal optimizer statistics

·         Flashback Data Archive (FDA) tips - 19 February 2014

·         fnd_request.submit_request tips - 3 March 2014

·         Forecasting Oracle Performance

·         Formatting PL/SQL stored procedure output - January 16, 2008

·         Freelist Tips - 6 February 2014

·         FRM-10221 September 17th, 2007

·         FRM-41839: Disk I/O error on temporary record buffer file September 26th, 2007

·         full hint Tips - 22 July 2015

·         full transportable data pump Tips - 15 March 2014

·         Fun News!

·         Get 10g SQL plans - 28 April 2015

·         Get AWR report on two time periods - 17 December 2015

·         Get AWR report on windows - 17 December 2015

·         Get DDL for Materialized View Script - 5 November 2015

·         Get ORACLE_SID from inside PL/SQL - 10 February 2015

·         ggs_ddl_trace.log Tips -  23 July 2015

·         Global temporary table tips - 22 February 2014

·         global temporary table troubleshooting tips - 26 March 2014

·         GoldenGate Data Pump tips -  5 March 2014

·         GoldenGate for Oracle Replication

·         Government Data Security Malfeasance

·         GPA LSAT GMAT test score matrix grid

·         Graphing Oracle SQL output - October 26, 2007

·         Grid Control Post Installation Tips - October 3, 2007

·         Gross State Domestic Product

·         Hacking Oracle from the Web

·         Handling NULL sets within the SQL CASE statement - November 7, 2007

·         Harvard & MIT extension schools have lower standards

·         hash join hint Tips - 14 March 2014

·         hash partition tips - 17 February 2014

·         hash_area_size

·         Hawaii Oracle Users Group meeting

·         Heterogeneous Database connections - Oracle to SQL Server

·         hidden characters in Oracle table names - Tony Jambu

·         Hidden Oracle8i log parameters

·         Hide passwords in oracle shell scripts - 20 February 2014

·         High speed Oracle data extract and reload

·         History of Postgres releases & features

·         Homeland Security says outsourcing increases risk of cyberattacks

·         How does STATSPACK collect "Top SQL"?

·         How much is a college degree worth?

·         How often to reanalyze statistics Tips - 20 November 2015

·         How to become an Oracle Applications DBA

·         How to cancel a concurrent manager request - 28 February 2015

·         How to change an Oracle table owner - October 24, 2007

·         How to compare two tables - 21 February 2014

·         How to create a word document from Oracle - December 27, 2007

·         How to create an Oracle database link - January 17, 2008

·         How to delete from VARRAY tips - 21 February 2014

·         How to detect a leap year with Oracle  -  January 15, 2008

·         How to display the execution plan for a finished SQL - 8 November 2015

·         How to do switching between oracle databases

·         How to enable automatic statistics collection in 11g r2 - 22 January 2015

·         How to enforce a minimum password length - November 8, 2007

·         How to force an execution plan -  25 November 2015

·         How to Format Oracle output with HTML/XML - January 15, 2008

·         How to generate a csv of a oracle table Tips - 21 December 2015

·         How to handle percent (%) underscore (_) and quotes within SQL LIKE queries

·         How to install Oracle RAC on Windows - November 2, 2007

·         How to invoke and execute a script from OEM

·         How to kill an Oracle process on Windows - October 20, 2007

·         How to learn Oracle

·         How to load Excel spreadsheet data into Oracle tables - December 27, 2007

·         How to monitor Data Pump sessions - 7 May 2015 

·         How to read an AWR report - 16 May 2015

·         How to read an Export expdp dmp file - 19 November 2015

·         How to retrieve oracle passwords

·         How to see if I am licensed to use AWR -  6 May 2015

·         How to select rows for a specific month - January 8, 2008

·         How to send a fax from Oracle

·         How to store an MS Word doc in Oracle - December 28, 2007

·         How to switch between multiple databases releases on Windows - 9 May 2015

·         How to tell when a scheduled job is running -   13 March 2014

·         How to tell when partition pruning is used - 27 November 2015

·         How to validate that a SQL*Plus script executed successfully - 7 May 2015

·         HTML-DB Administration

·         HTML-DB and JavaScript

·         HTML-DB and table default values

·         HTML-DB check boxes in reports regions

·         HTML-DB JavaScript Directory Hierarchy on the HTTP Server

·         HTML-DB JavaScript static file repository

·         HTML-DB with JavaScript cascading menus

·         HTMLDB: Adding JavaScript to an HTML-DB Application Page

·         HTML-DB: Calling JavaScript on Page Loading

·         HTML-DB: Creating an HTMLDB Button to Call JavaScript

·         HTML-DB: Highlighting Calendar Values

·         HTMLDB: Managing HTML-DB JavaScript Source Code

·         htmldb_mail message management

·         Hyperion vs. Cognos vs. Business Objects?

·         identify migrated/chained rows

·         identify sparse tables

·         Identity theft protection book

·         idle_time Tips -  6 March 2014

·         IE 7 Review

·         IMP-00010: not a valid export file tips -  January 14, 2008

·         impdp import with ORA-04020 error - 9 November 2015

·         impdp like exclude filtering - 5 June 2015

·         impdp specific column tips - 1 May 2015

·         impdp tips - 21 May 2015

·         impdp transform=segment_attributes - 27 February 2014

·         Import a view Tips - 12 March 2014

·         Import nls_lang not compatible - 3 November 2015

·         Import selected rows

·         import transform=disable_archive_logging - 29 January 2014

·         Important bug: Oracle SQL gives wrong result - October 26, 2007

·         Important changes in 10g statistics collection

·         Important notes for global SQL optimization - October 14, 2007

·         IN vs. EXISTS SQL

·         Inadvertent disclosure of Oracle database secrets

·         Index tablespace moved after issuing the "split partition" command - November 12, 2007

·         index_rs_asc hint tips -   25 March 2015

·         Informix to Oracle migration tips

·         Ingres tips

·         init.ora file

·         Initialization Parameters in Oracle 10g

·         inmemory_size tips - 7   November 2015

·         insert hyperlink into SQL output - 10 November 2015

·         Insert into long raw column Tips - 13 December 2015

·         Insert Nested Table tips - 14 May 2015

·         Inside Auction "sellers regret"

·         Inside cyberstalking

·         Inside Oracle 11g Database replay - October 31, 2007

·         Inside Oracle 11g ILM - Information lifecycle management

·         Inside Oracle execution plans

·         Inside Oracle LRU latches

·         Inside Oracle supplemental logging

·         Inside Oracle 10g Automatic Memory Management

·         Inside The Trace File

·         Installation of AWR - 25 January 2015

·         Installation of Oracle

·         installing Oracle STATSPACK

·         Installing RAC for an Oracle data warehouse

·         Integrating Streams Replication and Standby Databases

·         Interactive PL/SQL to accept input

·         Interfacing Oracle with Windows scripts

·         Intermittent Explosive Disorder?

·         Internet Copyright infringement & web page cloaking

·         Internet identity theft protection

·         Internet Oracle deployment of public data over the web

·         Internet Phishing scams book

·         Internet Predators book

·         Internet scams protection book

·         Interpreting Oracle RAC STATSPACK/AWR performance reports

·         Introduction to Bind calls with the Oracle Perl DBI

·         Introduction to Java Debugging

·         invalid nibble errors

·         Invisible data columns Tips - 5 January 2015

·         IOUG 2006 Top Session attendance results

·         IOUG Collaborate 2015

·         Is my Oracle 32-bit or 64-bit?

·         Java ORA-01461 solution - 13 November 2015

·         Java Testing Principles

·         job_queue_interval

·         joins in oracle

·         Jon Emmons on Oracle Linux & UNIX shell scripting

·         Justifying a migration upgrade to Oracle 10g

·         KEEP pool data buffer hit ratio - 7 November 2015

·         kewastUnPackStats(): bad magic 1 tips

·         killing oracle instance tips - 29 March 2014

·         killing oracle sessions

·         ksh .profile for Oracle - 28 April 2015

·         ku$_dblink_view tips - 3 March 2014

·         laptop notebook computers with biometrics and cameras

·         Large Oracle Blocksizes

·         last successful login time scripts - 19 September 2015

·         last_call_et in v$session tips - 31 January 2014

·         Law school admissions UPGA and LSAT

·         Learning Applied Artificial Intelligence with Oracle

·         Learning by Analogy - Oracle

·         Learning ODM

·         Learning SQL*Forms tips

·         Legality, privacy and verifying a college degree  - October 15, 2007

·         lengthb Tips - 14 March 2014

·         Let's roll - The true story of an Oracle hero

·         Lewis speaks on lower-cost Oracle tools

·         Libelous bloggers cost company $100m

·         Limitations of Oracle Streams?

·         Limitations on Oracle SQL processing?

·         Linux command to change all values within files in an Oracle directory?

·         Linux command to change database environment ORACLE_SID

·         Linux Error: 29 : Illegal seek tips

·         Linux Script using UTL_MAIL from SQL* PLUS - 28 December 2015

·         Linux threaded_execution tips

·         List AWR Snapshots - 17 December 2015

·         List Installed Components - 26 September 2015

·         List Oracle patches  -  8 March 2014

·         list partition tips - 16 February 2014

·         list ROWIDs per block - 25 June 2015

·         Listener log file location Tips - 16 July 2015

·         Listener log full tips - 15 July 2015

·         Load XLS file into SQL*Forms tips - 15 February 2014

·         Loading and Analyzing the 10046 Event

·         Loading CLOB data with sqlldr (SQL*Loader)

·         Loading LOB (BLOB) data into tables

·         Loading Oracle data from e-mail attachments

·         loadjava

·         LOB CLOB BLOB, undo and PCTVERSION

·         LOB freepools Tips -  8 May 2015

·         LOB Types and REF Cursors with Oracle Perl DBI

·         Locating similar SQL in Oracle

·         Location of DDL files for SQL*Plus- 1 February 2015

·         Location of Windows hostname - 20 March 2014

·         Lock Down Your Server

·         lock out all end user ID's tips - 24 March 2014

·         log_archive_dest_2 Tips - 22 March 2015

·         logging with LOB, BLOB, CLOB

·         Longest Oracle RAC 24x7 continuous availability

·         Lost SYSOPER password in Oracle 10g - October 4, 2007

·         Make a Oracle table column nullable - 27 February 2014

·         Managing Oracle disk I/O in AIX - November 12, 2007

·         Masking/Hiding/Encrypting password column in db_link view

·         Materialized View Fast Refresh Performance Tips

·         Materialized Views and query rewrite

·         Materialized Views in Oracle Warehouse Builder OWB

·         Materialized Views Refresh Performance Tuning

·         Materialized Views Tuning

·         Max partitions in table - 11 February 2015

·         max_sql_string_size Tips - 4 January 2015

·         max_string_size tips

·         Maximizing Value in Oracle Training Budgets

·         Maximum Oracle Limits

·         Measuring index block density for rebuilding

·         Measuring Oracle transactions per second

·         Measuring Success in Oracle Data Cleansing with precision and recall

·         Merge join cartesian tips - December 12, 2007

·         merge join hint Tips -  14 March 2014

·         Migrating Oracle Schema statistics

·         Minimizing downtime for Oracle release upgrades

·         minimizing migrated rows with pctfree and minimize_records_per_block

·         Misleading test cases: willful deception or sloppy work?

·         MMON suspending action tips - 29 March 2014

·         Modeling transitive Data Dependencies

·         Modeling transitive Data Dependencies webcast

·         Modify AWR Automatic Snapshot Settings - 12 December 2015

·         Monitor data pump expdp export script - 11 June 2015

·         Monitor Oracle alert log Tips - 28 November 2015

·         Monitor Oracle Connections Tips -  12 March 2015

·         Monitor Oracle Windows disks

·         Monitor Oracle Windows dump and trace files

·         Monitoring Network Performance Tips -  14 March 2014

·         Monitoring Network Performance with STATSPACK -  14 March 2014

·         Monitoring Oracle SGA & PGA Memory Changes

·         Monitoring Oracle Table Usage

·         Monitoring REDO Log Buffer Tips - 21 February 2014

·         Monitoring REDO Log Tips - 21 February 2014

·         Monitoring SQL*Loader Inserts

·         Monitoring UNDO Tips - 21 February 2014

·         More Random Data

·         Move RAC redo log files in ASM - 17 May 2015

·         MS-Word adding & removing carriage returns

·         multiple block sizes

·         multiple materialized views

·         Multiple Oracle buffer LRU latches?

·         multi-row subqueries in Oracle tips - 13 July 2015

·         narcissistic personality disorders

·         Native Dynamic SQL tips - 26 February 2014

·         Natural vs surrogate keys for Oracle tables - 7 May 2015

·         Net Present Value of undergraduate grades towards law school tuition

·         New Shared Pool Features of Oracle 10gr2 (release 2)

·         newgrp command Tips - 4 November 2015

·         NFB alleges Oracle Human Resources software is not blind-friendly

·         no_merge hint tips -  23 May 2015

·         Non-ORA Errors September 25th, 2007

·         Object type in dba_objects

·         OEM Database Express Tips - 15 March 2014

·         OEM RAC Monitoring

·         OER 7451 in Load Indicator Tips - 5 November 2015

·         Official DMCA Copyright Infringement Removal Request

·         offset fetch first rows only tips - 11 March 2015

·         OLAP Analytic Workspace XML objects

·         old dbms_scheduler job still running at execution time -  13 March 2014

·         On personal integrity and consulting

·         Online data validation format systems characteristics

·         Online DDL Tips - 15 March 2014

·         Online fraud protection

·         Online Systems Development Standards

·         Online wiki web pages suffer from lack of credibility

·         onsite Oracle consulting

·         On-site Oracle consulting

·         oow_getting_regular_with_regular_expressions.pdf

·         oow_oracle_apex_ajax.pdf

·         Open-Xchange tips

·         Optimal data buffer cache hit ratio tips - 20 May 2015

·         Optimal SHMMAX for Oracle -  21 November 2015

·         Optimize count(*) SQL Tips -  8 March 2014

·         Optimize Full table scans tips - 29 March 2014

·         Optimize Oracle import (impdp) speed

·         Optimize Oracle SQL*Loader Performance

·         Optimizer costs don't match SQL execution performance

·         Optimizer plan stability tips - 23 March 2014

·         optimizer_adaptive_features tips - 29 January 2014

·         optimizer_sql_plan_baselines Tips - 3 May 2015

·         Optimizing Linux network TCP/IP kernel parameters

·         Optimizing Oracle INSERT SQL performance

·         Optimizing Oracle performance

·         ORA- 39171 tips -  22 May 2015

·         ora_archive_state Tips  - 2 September 2015

·         ora_dba group tips - 25 February 2014

·         ORA_ROWSCN.... New 10g pseudo Column

·         ORA-00001: unique constraint (string.string) violated tips

·         ORA-00204: error in reading (block string, # blocks string) of control file tips - October 5, 2007

·         ORA-00257: archiver error. Connect internal only, until freed tips

·         ORA-00310: archived log contains sequence tips

·         ORA-00604: error occurred at recursive SQL level string tips

·         ORA-00823 Tips - 10 December 2015

·         ORA-00900: invalid SQL statement tips

·         ORA-00907: missing right parenthesis tips

·         ORA-00911: invalid character tips

·         ORA-00913: too many values tips

·         ORA-00932 inconsistent datatypes: expected string got string tips

·         ORA-00936: missing expression tips

·         ORA-00937: not a single-group group function tips

·         ORA-00942: table or view does not exist tips

·         ORA-00947: not enough values tips

·         ORA-00959 impdp tips - 3 April 2014

·         ORA-00972: identifier is too long tips

·         ORA-00980: synonym translation is no longer valid tips

·         ORA-01000: maximum open cursors exceeded tips

·         ORA-01031 on create directory - 23 March 2014

·         ORA-01034: ORACLE not available tips

·         ORA-01155 Tips - 15 April 2015

·         ORA-01187 from RMAN copy command tips

·         ORA-01187: cannot read from file nnn because it failed verification tests

·         ORA-01207 tips

·         ORA-01210: data file header is media corrupt Tips - 26 December 2015

·         ORA-01400: cannot insert NULL - 27 February 2014

·         ORA-01401 inserted value too large for column tips

·         ORA-01403: no data found tips