Oracle Articles            By Burleson Consulting

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

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

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

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

Publish articles with BC

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

Oracle Article Index:

• 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

Click here for Burleson reader comments.

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

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

• 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 MetaLink - 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.

• _optimizer_cost_based_transformation tips - October 26, 2007
• 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
• Add Constraint Oracle
• Adding animated pictures to PowerPoint Presentations
• Adjusting STATSPACK Collection levels
• Aegis Oracle Tips
• 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
• All Oracle 8i hidden parameters
• Alter Oracle for autoextend on
• Alter Tablespace Add Datafile
• Alter User Oracle
• alter_database_tab_monitoring
• alter_schema_tab_monitoring
• Alteration of Databases
• Altering Oracle sequences
• and-equal data access method
• Andrew Kerber expert systems, decision support systems and AI experience
• Anonymous Block Tips
• ApEx (HTML-DB) release 3 new features
• Application Page to use a JavaScript multi-level menu list
• 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
• asmcmd tips
• Assigning Oracle user security roles
• Assigning weights for a multi-column Oracle text index - January 18, 2008
• ASSM, freelists and PCTFREE
• auditing concepts webcast
• Auditing Oracle eBusiness Suite Financials
• Ault & Burleson to give Predictive Modeling Seminar
• Autonomous Transaction
• Automated Storage Management ASM configuration
• Automatic speech/voice recognition software for the Oracle professional - January 19, 2008
• Automating Oracle Data cleansing approaches
• AWR and SQL Tuning
• 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
• Biometric fingerprint scanners planned for credit card authentication
• Bizgres tips
• Black Arabian Stallion
• Blocking Oracle access by IP Addresses
• British Bloggers face journalist standards when web publishing
• Buffer busy waits and I/O contention
• 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
• Change Oracle IP and Domain DNS Tips
• 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
• Cloning a large terabyte RAC database
• Cloning an Oracle user
• 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
• 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
• Concurrent manager job scheduling utility
• Configuring oracle network
• Connect Oracle to SQL Server
• Connecting to Oracle with the Perl DBI
• Consolidation of Oracle Audit Data sources
• Converting Oracle rows to columns
• copy Oracle table into MySQL database
• Corporate e-mail spam rules
• Corporate Information Technology (IT) budget planning
• counterintelligence-scope CI polygraph
• Counting Oracle tables
• Create Database Link Oracle
• Create or Replace Procedure
• Create Schema
• Creating an Oracle Data Cleansing Architecture
• Criminals offer shilling bidding service for eBay
• CTAS table reorg
• Data Dictionary catalog scripts
• Data format validation with Oracle regular expressions
• Data Guard: archive log target fix
• Data guard switchover with dgmgrl
• 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
• dateline adoption scams fraud
• db_cache_size
• db_file_multiblock_read_count
• dba_advisor_findings procedure
• DBI and Oracle
• dbms_auto_task_admin tips
• dbms_backup_restore tips - November 6, 2007
• dbms_job vs. dbms_scheduler
• dbms_job.broken tips
• dbms_job.remove tips
• dbms_lob.writeappend to join BLOB columns
• dbms_metadata tips
• dbms_mtune
• dbms_outfut.put_line
• dbms_scheduler replaces cron for shell scripts

• dbms_shared_pool.keep

• dbms_stats.gather_fixed_objects_stats tips
• dbms_stats.gather_system_stats and SQL optimizer behavior
• dbms_warning usage tips
• dbms_xmlquery vs. dbms_xmlgen
• DBWR Tuning Tips
• Decompiling Oracle Java decompiler
• Decreasing log file sync waits
• Dedicating CPU processors - Oracle affinity
• Defending against web content theft
• Definition: Ya Boo Sucks to you
• Delete duplicate rows - Deletion from Oracle tables
• 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
• Difficulty with Host Credentials in Linux September 10th, 2007
• Dimensionless Star Schema (Bitmap Star)
• disable Oracle 10g statistics collection
• Disable Oracle Dynamic Sampling
• Discoverer: The server is running low on virtual memory tips
• Discoverer "Not all rows have been retrieved. Data may be inaccurate" tips
• Disk Average Failure Rate (AFR)
• Disk to LUN I/O performance on SAN and NAS
• Display Oracle concurrent manager processes
• Display Oracle locks - locked rows for a user
• Display Oracle SQL output rows on one single line
• Display RAC Interconnect Details
• 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
• 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
• Elite Oracle Tips
• Enabling AMM in 10g
• Entity Relation Diagram (ERD) tools for Oracle databases
• Error: dbconsole java.lang.exception: no such metric September 11th, 2007
• ERROR 45 Initializing SQL*PLUS Internal Error
• Estimate Oracle Index Size
• Estimate Space used by an Oracle Index
• Estimating SGA size tips
• Estimating the costs of Oracle data exposure
• ETL with pipelined table functions & external tables
• Excel Database tips
• Excluding Tables from Full Exports September 12th, 2007
• Execute Immediate on Large Insert Strings
• Execute operating system commands in Oracle
• Executing SQL with the Oracle Perl DBI
• exp imp tables
• Oracle export performance tuning - December 13, 2008
• EXP: ORA-01036:illegal variable name/number
• EXP-00002 tips - December 19, 2007
• EXP-00008: ORACLE error 904 encountered tips
• EXP-00056: ORACLE error 942 encountered database link
• EXP-00091 Exporting questionable statistics tips
• FAS 48 and income statements for publicly held corporations
• Find gaps in Oracle sequences - October 26, 2007
• Find movie show times fast
• Find Oracle RAC Locks
• Find tables referenced inside PL/SQL stored procedures
• Find the Last Accessed Date for an Oracle Discoverer Workbook
• Find the threshold for large tables and small tables
• Find the threshold for large tables and small tables - November 14, 2007
• Find unused columns with dba_unused_col_tabs
• Finding Oracle business intelligence experts
• Finding Oracle materialized view opportunities
• Finding Oracle Tuning experts
• fingerprints as tables primary keys
• fired for web surfing
• Fix high "cache buffer chain" waits
• Fix Oracle mutating table errors
• Fix Oracle swapping on AIX
• 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
• Forecasting Oracle Performance
• Formatting PL/SQL stored procedure output - January 16, 2008
• FRM-10221 September 17th, 2007
• FRM-41839: Disk I/O error on temporary record buffer file September 26th, 2007
• Fun News!
• 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_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
• 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 to become an Oracle Applications DBA
• How to change an Oracle table owner - October 24, 2007
• How to create a word document from Oracle - December 27, 2007
• How to create an Oracle database link - January 17, 2008
• How to detect a leap year with Oracle  -  January 15, 2008
• How to do switching between oracle databases
• How to enforce a minimum password length - November 8, 2007
• How to Format Oracle output with HTML/XML - January 15, 2008
• 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 retrieve oracle passwords
• 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
• 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
• IE 7 Review
• IMP-00010: not a valid export file tips -  January 14, 2008
• Import selected rows
• 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
• Informix to Oracle migration tips
• Ingres tips
• init.ora file
• Initialization Parameters in Oracle 10g
• 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
• Integrating Streams Replication and Standby Databases
• Installation of Oracle
• installing Oracle STATSPACK
• Installing RAC for an Oracle data warehouse
• 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
• IOUG Collaborate 2010
• IOUG 2006 Top Session attendance results
• Is my Oracle 32-bit or 64-bit?
• Java Testing Principles
• job_queue_interval
• joins in oracle
• Jon Emmons on Oracle Linux & UNIX shell scripting
• Justifying a migration upgrade to Oracle 10g
• killing oracle sessions
• kewastUnPackStats(): bad magic 1 tips
• laptop notebook computers with biometrics and cameras
• Large Oracle Blocksizes
• 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
• 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
• 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 Types and REF Cursors with Oracle Perl DBI
• Locating similar SQL in Oracle
• Lock Down Your Server
• logging with LOB, BLOB, CLOB
• Longest Oracle RAC 24x7 continuous availability
• Lost SYSOPER password in Oracle 10g - October 4, 2007
• 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
• Maximum Oracle Limits
• Maximizing Value in Oracle Training Budgets
• 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
• 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?
• Modeling transitive Data Dependencies
• Modeling transitive Data Dependencies webcast
• Monitor Oracle Windows disks
• Monitor Oracle Windows dump and trace files
• Monitoring Oracle SGA & PGA Memory Changes
• Monitoring Oracle Table Usage
• Monitoring SQL*Loader Inserts
• More Random Data
• MS-Word adding & removing carriage returns
• multiple block sizes
• multiple materialized views
• Multiple Oracle buffer LRU latches?
• narcissistic personality disorders
• Net Present Value of undergraduate grades towards law school tuition
• New Shared Pool Features of Oracle 10gr2 (release 2)
• NFB alleges Oracle Human Resources software is not blind-friendly
• Non-ORA Errors September 25th, 2007
• Object type in dba_objects
• OEM RAC Monitoring
• Official DMCA Copyright Infringement Removal Request
• OLAP Analytic Workspace XML objects
• On personal integrity and consulting
• Online data validation format systems characteristics
• 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
• Optimize Oracle import (impdp) speed
• Optimize Oracle SQL*Loader Performance
• Optimizer costs don't match SQL execution performance
• Optimizing Linux network TCP/IP kernel parameters
• Optimizing Oracle INSERT SQL performance
• Optimizing Oracle performance
• 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-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-00972: identifier is too long tips
• ORA-00980: synonym translation is no longer valid tips
• ORA-01000: maximum open cursors exceeded tips
• ORA-01034: ORACLE not available tips
• ORA-01187 from RMAN copy command tips
• ORA-01187: cannot read from file nnn because it failed verification tests
• ORA-01207 tips
• ORA-01401 inserted value too large for column tips
• ORA-01403: no data found tips
• ORA-01422: exact fetch returns more than one requested number of rows tips
• ORA-01578 and ORA-26040 tips - December 21, 2007
• ORA-01652: unable to extend temp segment by string in tablespace string tips
• ORA-01658: unable to create INITIAL extent for segment in tablespace string tips
• ORA-01722: invalid number tips
• ORA-01775 looping chain of synonyms - October 8, 2007
• ORA-01830 date format picture ends before converting entire input string tips
• ORA-01940 tips
• ORA-02049: timeout: distributed transaction waiting for lock tips - November 17, 2007
• ORA-02049: timeout: distributed transaction waiting for lock tips
• ORA-02096: specified initialization parameter: mot modifiable with this option - October 1, 2007
• ORA-03106: fatal two-task communication protocol error tips
• ORA-03118: two-task coroutine has invalid state tips - October 2, 2007
• ORA-03136: inbound connection timed out tips
• ORA-04031: unable to allocate string bytes of shared memory("string","string","string","string") tips
• ORA-04068: existing state of packagesstringstringstring has been discarded tips
• ORA-04098: trigger "string.string" is invalid and failed re-validation tips
• ORA-12170: TNS: Connect timeout occurred tips
• ORA-12203: TNS:unable to connect to destination tips
• ORA-12505: TNS:listener does not currently know of SID given in connect descriptor tips
• ORA-12518: TNS:listener could not hand off client connection tips
• ORA-12519: TNS:no appropriate service handler found tips
• ORA-12528: TNS:listener: all appropriate instances are blocking new connections tips - October 9, 2007
• ORA-1458: invalid length inside variable character string - October 10, 2007
• ORA-15029: disk "string" is already mounted by this instance tips - October 22, 2007
• ORA-16139: media recovery required tips - October 23, 2007
• ORA-19625: error identifying file string tips - October 11, 2007
• ORA-22905: cannot access rows form a non-nested table item tips - October 25, 2007
• ORA-22913: table data object string failed to load
• ORA-23313 error when calling CREATE_MASTER_REPGROUP
• ORA-23327: imported deferred rpc data does not match string of importing db tips - October 24, 2007
• ORA-23357: the propagator does not exist tips
• ORA-27101: shared memory realm does not exist tips
• ORA-28000: the account is locked tips
• ORA-28009:connection as SYS tips
• ORA-28545: error diagnosed by Net8 when connecting to an agent
• ORA-29278: SMTP transient error: string tips - October 12, 2007
• ORA-29857: domain indexes and/or secondary objects exist in the tablespace tips - October 26, 2007
• ORA-30036: unable to extend segment by string in undo tablespace "string" tips
• ORA-31603: object "string" of type string not found in schema "string" - October 15, 2007
• ORA-31693: table data object string failed to load
• ORA-32006: %s initialization parameter has been deprecated tips - October 16, 2007
• ORA-37002: Oracle OLAP failed to initialize tips - October 28, 2007
• Oracle - Get IP address
• Oracle - Slow performance after upgrade
• Oracle - Tracking constraint dependencies
• Oracle - UNIX and Oracle parameters
• Oracle - Using default values
• Oracle "alter table" add column syntax example
• Oracle "alter table" constraint syntax examples
• Oracle "alter table" drop column syntax example
• Oracle "alter table" modify column Syntax example
• Oracle "alter table" rename column Syntax example
• Oracle "Basic" initialization parameters
• Oracle "connect by" syntax
• Oracle "file open" wait event tuning
• Oracle "grant resource" role components
• Oracle "with admin" vs. "with grant" security privileges
• Oracle & read ahead cache
• Oracle _db_writer_flush_imu tips
• Oracle _log_io_size parameter
• Oracle _smm_px_max_size Parameter
• Oracle “with check option” syntax
•  Oracle 10.2 proxy user connect syntax
• Oracle 100% CPU tips
• Oracle 10g adaptive threshold monitoring
• Oracle 10g bug 4243687 wrong count(*)
• Oracle 10g data mining software tips
• Oracle 10g fast dual
• Oracle 10g Materialized Views new features
• oracle 10g new features
• Oracle 10g New Features: Changes to dbms_stats
• Oracle 10g PC Windows and hardware requirements
• Oracle 10g PL/SQL performance optimization
• Oracle 10g r2 Data Guard Standby Redo log recovery
• Oracle 10g RAC installation
• Oracle 10g release 2 locking changes?
• Oracle 10g segment advisor Tips
• Oracle 10g sorted hash clusters
• Oracle 10g support
• Oracle 10g tips
• Oracle 10g tips
• Oracle 10g v$session_event
• Oracle 10g XML file formatting
• Oracle 10g: Find full-table scans with AWR using plan10g.sql
• Oracle 11g automated SQL Tuning
• Oracle 11g full hash join - October 25, 2007
• Oracle 11g fully automated SQL tuning tips - January 17, 2008
• Oracle 11g Healthchecks service - October 27, 2007
• Oracle 11g hits the streets
• Oracle 11g Holistic Tuning Tips - January 17, 2008
• Oracle 11g memory_target parameter
• Oracle 11g Real Application Testing (RAT)
• Oracle 11g SQL performance analyzer concepts - January 16, 2008
• Oracle 11g SQL tuning transformations - December 16, 2007
• Oracle 2008 conference: RMOUG and IOUG Collaborate 2008
• Oracle 2008 conferences
• Oracle 8i hidden corruption recovery parameters
• Oracle 8i hidden database parameters
• Oracle 8i hidden disable & enable parameters
• Oracle 8i hidden enqueue parameters
• Oracle 8i hidden lm parameters
• Oracle 8i hidden log writer parameters
• Oracle 8i hidden materialized views parameters
• Oracle 8i hidden NUMA (non uniform memory access) parameters
• Oracle 8i hidden real application clusters parameters
• Oracle 8i hidden recovery parameters
• Oracle 8i prefetch hidden parameters
• Oracle 9i Tips
• Oracle aborted_request_threshold tips
• Oracle Academy Textbooks
• Oracle ADF and Java ADF faces
• Oracle AIX RAC UDP - November 12, 2007
• Oracle AIX Tuning Optimization
• Oracle AJAX Consulting Support
• Oracle AJAX Tips
• Oracle alert log error notification
• oracle alert log stored procedure
• Oracle alter table change column datatype
• Oracle alter table drop column
• Oracle alter table shrink space commands
• Oracle alternative dual table
• Oracle AMM
• Oracle ANALYZE TABLE
• Oracle version control tips
• Oracle Analytic Functions
• Oracle Analytics 12-5-07
• Oracle Analyze Index
• Oracle Apex (HTML-DB) best practices certification
• Oracle Application Server Certification - OCA tips
• Oracle Application Server Guard
• Oracle Application Server migration from 9i to 10g
• Oracle Application Server OracleAS Health Checks
• Oracle Application Server Tips
• Oracle Applications - Find installed modules
• Oracle Applications 11i Health Checks
• Oracle Applications 11i security tips
• Oracle Applications Modules
• Oracle Applications Tips
• Oracle Applications Tuning
• Oracle Acquires Sun Microystems for $7.4b
• Oracle archivelog noarchivelog mode recovery
• Oracle ASSM
• Oracle asynchronous change data capture
• Oracle audit command tips
• Oracle Auditing at the database level
• Oracle auditing concepts video
• Oracle auditing for FAS 48
• Oracle Auditing Misconceptions
• Oracle Auditing Reliability and Completeness
• Oracle Auditing traps
• Oracle auditing: SQL select statements
• Oracle auditing: SQL select statements
• Oracle AUM tips
• Oracle automatic segment space management
• Oracle Automatic Shared Memory Management (ASMM)
• Oracle Automatic undo management and transactions_per_rollback_segment
• Oracle automating script for keep pool caching tables & indexes
• Oracle Autotrace
• Oracle autostats_target
• Oracle AWR report
• Oracle AWR Retention period
• Oracle background processes
• Oracle backup & recovery
• Oracle backup compression tips
• Oracle Backward Compatibility Tips
• Oracle batch shell scripting
• Oracle BBED Tips
• Oracle Benchmark Testing
• Oracle benchmark tips
• Oracle benchmark tips
• Oracle benchmarks
• Oracle best Practices
• Oracle Bigfile tablespace tips
• Oracle bind variables
• Oracle Biometrics Consulting
• Oracle bitmap freelists
• Oracle BLOB CLOB storage overhead
• Oracle BLOB CLOB tips
• Oracle block change tracking
• Oracle Block size tips
• Oracle blocksize
• Oracle blog tips
• Oracle Buffer Cache Advisory
• Oracle Bulk Collect
• Oracle Business Analytics tips
• Oracle cardinality hint tips -  December 4, 2007
• Oracle case insensitive indexes searching
• Oracle CASE SQL
• Oracle catalog.sql run twice
• Oracle certification tips
• Oracle certification tips
• Oracle Certifications
• Oracle certified experts?
• Oracle Certified Masters
• Oracle Character Function
• Oracle classpath
• Oracle Classroom Training
• Oracle clustering
• Oracle Clusters RAC deployment
• Oracle Coherence: A RAC alternative?
• Oracle collections
• Oracle column-oriented data storage
• Oracle command column within v$session
• Oracle command column within v$session
• Oracle compiled PL/SQL
• Oracle Conference Downloads
• Oracle Conferences
• Oracle constraints
• Oracle Consultant
• Oracle Consulting Companies
• Oracle Consulting firms
• Oracle ContentDB tips - October 24, 2007
• Oracle Contracting
• oracle controlfile management
• oracle copy
• Oracle cost based optimizer
• Oracle Convert to Number
• oracle create database example
• Oracle create spreadsheet tips
• Oracle CREATE SEQUENCE
• Oracle create tablespace & alter tablespace syntax
• Oracle Create Type
• Oracle CREATE VIEW
• Oracle cron crontab examples
• Oracle cube syntax
• Oracle Current Timestamp
• Oracle cursor.arraysize tips - December 10, 2007
• Oracle cursor_sharing
• Oracle cursor_sharing cached cursors
• Oracle data access with SOAP
• Oracle data block segment allocation
• Oracle Data cleansing anomalies
• Oracle Data cleansing Decision Support System Team
• Oracle data extraction for Excel spreadsheets
• Oracle data file tablespace management FAQ
• Oracle Data Guard and perlglob
• Oracle Data Guard licensing guidelines
• Oracle Data Integrator and OWB
• Oracle Data Mining Tips
• Oracle Data Mining tips
• Oracle data privacy auditing issues
• Oracle Data Propagation
• Oracle data pump PCTSPACE tips
• Oracle data security auditing
• Oracle Data type
• Oracle data warehouse configuration
• Oracle data warehouse date transformation
• Oracle Data Warehouse DBA
• Oracle data warehouse design tips
• Oracle data warehouse development best practices
• Oracle Data Warehouse Job Roles
• Oracle data warehouse staffing tips
• Oracle database growth reports
• Oracle database privacy and background checks
• Oracle database sizing estimation
• Oracle Database Tips
• Oracle Database Tuning
• Oracle Datatype
• Oracle date arithmetic tips - November 15, 2007
• Oracle date format display
• Oracle date math manipulation
• Oracle date to hundredths of a second
• Oracle dates: group rows into periods
• Oracle db_files and maxdatafiles parameters
• Oracle dblink
• Oracle DBA Certification
• Oracle DBA Code of Ethics
• Oracle DBA job duties
• Oracle DBA resume
• Oracle DBA Screening Service
• Oracle DBA Tasks
• Oracle DBA Views
• Oracle dba_hist_osstat
• Oracle DBA's threatened by offshoring?
• Oracle DBCA templates for database creation
• Oracle dbms_advanced_rewrite
• Oracle dbms_alert
• Oracle dbms_application_info
• Oracle dbms_aq
• Oracle dbms_aqadm
• Oracle dbms_crypto
• Oracle dbms_ddl
• Oracle dbms_describe
• Oracle dbms_expfil
• Oracle dbms_fga
• Oracle dbms_file_transfer
• Oracle dbms_flashback
• Oracle dbms_job
• Oracle dbms_job examples
• Oracle DBMS_LCR
• Oracle dbms_lob
• Oracle dbms_lock
• Oracle dbms_metadata
• Oracle dbms_metadata
• Oracle dbms_monitor
• Oracle dbms_monitor
• Oracle dbms_mview
• Oracle dbms_output
• Oracle dbms_profiler
• Oracle dbms_random
• Oracle dbms_rectifier_diff
• Oracle dbms_redefinition
• Oracle dbms_refresh
• oracle dbms_repair
• Oracle dbms_resource_manager
• Oracle dbms_resumable
• Oracle dbms_rls
• Oracle dbms_rls
• Oracle dbms_rowid
• Oracle dbms_scheduler examples
• Oracle dbms_scheduler for weekday execution
• Oracle dbms_server_alert
• Oracle dbms_session
• Oracle dbms_shared_pool
• Oracle dbms_sleep
• Oracle dbms_space
• Oracle dbms_sql
• Oracle dbms_sqltune
• Oracle dbms_stats
• Oracle dbms_stats validate_stats statistics bugs
• Oracle dbms_support
• Oracle dbms_system
• Oracle dbms_tts
• Oracle dbms_utility
• Oracle dbms_workload_repository
• Oracle dbms_workload_repository
• Oracle dbms_xpla
• Oracle dbv database verify Utility
• Oracle DDL Triggers
• Oracle deadlock
• Oracle Debugging
• Oracle decode
• Oracle decode function
• Oracle define table blob lob storage
• Oracle DELETE Statement
• Oracle design for performance webcast
• Oracle Design for performance?
• Oracle design patterns
• oracle developer consulting
• Oracle Developers
• oracle development
• Oracle Development
• Oracle development best practices
• Oracle Dimensions
• Oracle Directories
• Oracle Disable Constraints
• Oracle disaster recovery
• Oracle Discoverer tuning tips - December 28, 2007
• Oracle disk configuration
• Oracle disk I/O on Linux Tips
• Oracle disk I/O throughput speed
• Oracle DML error logging
• Oracle DML statements
• Oracle documentation Search
• Oracle Drop Partition
• Oracle Drop Tablespace
• Oracle Drop Synonym
• Oracle Dual table tips
• Oracle dynamic memory management tips - December 10, 2007
• Oracle dynamic PL/SQL procedures
• Oracle dynamic_sampling hint tips - December 4, 2007
• Oracle eCommerce RAC usage
• Oracle e-mail interface for Windows
• Oracle enable row movement tips
• Oracle ergonomics for online screens
• Oracle error ORA-03114 tips
• ORACLE error: unable to INSERT record tips September 21st, 2007
• Oracle escape characters
• Oracle estimate table join cardinality
• Oracle excel spreadsheet examples
• Oracle execution plan tips
• Oracle execution plan tips
• Oracle exp export syntax example
• Oracle experts and Oracle professionals
• Oracle exploit vulnerability allows privilege escalation
• Oracle export 2 gig files
• Oracle export script for Windows
• oracle export utility
• Oracle export with Boolean logic variables
• Oracle exports from Windows Scripts
• Oracle extended RAC for geographical disaster recovery
• Oracle External LOB BFILE Data types
• Oracle External Table error and ORA-29913
• Oracle Fail Safe
• Oracle Fail Safe vs. RAC
• Oracle features enabled but not licensed
• Oracle feedback architecture
• Oracle File Group Repository for versioning
• Oracle Flashback
• Oracle Flashback Transaction Query
• Oracle Flashback with "as of timestamp" SQL
• Oracle Forms 6i DML Insert when button pressed trigger
• Oracle Forums
• Oracle function based indexes
• Oracle Functions
• Oracle Fundamentals - Ahmed Baraka
• Oracle fusion - Hot or Not?
• Oracle global temporary tables
• Oracle Global Temporary Tables
• Oracle Grid Control Server tips
• Oracle Group By
• Oracle hackers horror stories
• Oracle hanganalyze trace files
• Oracle hard-parse vs. soft parse
• Oracle Hardware Scalability Testing
• Oracle Hardware Upgrade Tips - November 15, 2007
• oracle hash join
• Oracle hash partitioned IOT & sub-optimal SQL
• Oracle Having Clause
• oracle health check
• Oracle help screen demo software - screencasting
• Oracle hidden memory manager PGA advice parameters
• Oracle hidden olap parameters
• Oracle hidden optimizer parameters
• Oracle hidden parallel parameters
• Oracle hidden sort parameters
• Oracle hidden SQL subquery parameters
• Oracle high resource SQL.
• Oracle high water mark sessions
• Oracle hints tips - December 4, 2007
• Oracle Histograms
• Oracle histograms for join predicates
• Oracle hot backup scripts
• Oracle HTML-DB: sending emails from multiple select LOV
• Oracle I/O optimization on Sun Solaris
• Oracle I/O Slave Waits dbwr parallel DML
• Oracle I/O throughput scripts
• Oracle IBM terabyte RAM benchmark
• Oracle Idle Event list
• Oracle Implementation
• oracle import
• Oracle import completed successfully message
• Oracle Import Foreign Keys
• Oracle in a laissez faire economy
• Oracle Index Organized Tables ( IOT )
• Oracle index rebuilding: rebuild indexes
• Oracle Indexes
• Oracle INSERT statement
• Oracle INSTR
• Oracle Initialization Parameters
• Oracle INITRANS tips
• oracle inline view
• Oracle insert tuning - October 25, 2007
• Oracle Instructors
• Oracle Instrumentation Tips
• Oracle Intermedia Install Failed with errors
• Oracle Internals
• Oracle interview questions
• Oracle invalid Objects
• Oracle Invalid Objects recompile
• Oracle invalid or unusable indexes
• Oracle IOT vs. Single-table cluster
• Oracle Jargon Generator
• Oracle Java
• Oracle Java blob graphics retrieval
• Oracle java.lang.OutOfMemoryError Tips
• Oracle Java Methods
• Oracle Java PL/SQL scripts
• Oracle JDBC
• Oracle job interview questions
• Oracle JSQL, JDBC and JAVA
• Oracle large object (LOB) support
• Oracle large or small data files sizes?
• Oracle leading vs. ordered hints
• oracle left outer join
• Oracle licensing Pricing
• Oracle Linux - Using the "find" command to manage files
• Oracle Linux DBA Benefits
• Oracle Linux installation error Unable to load native library
• Oracle Linux Open Source
• Oracle Listener Security & passwords
• Oracle locally managed tablespaces
• Oracle lock_sga parameter tips
• Oracle Locking scripts
• Oracle locking strategies - November 9, 2007
• Oracle log buffer
• Oracle log buffer sizing
• Oracle logminer tips
• oracle lsnrctl listener command
• Oracle LTRIM
• Oracle LTOM Lite Onboard Monitor
• Oracle Magazine list
• Oracle Materialized View refresh methods
• Oracle Maximum datatypes Lengths
• Oracle Memory Configuration
• Oracle MetaBase Plus
• Oracle Migration consulting support
• Oracle Migration from Solaris to Linux
• Oracle minimum downtime migration error tips - December 28, 2007
• Oracle misspelled error messages
• Oracle months_between tips
• Oracle MREADTIM and SREADTIM workload statistics - November 22, 2007
• Oracle MTS - multithreaded shared servers
• Oracle NEXTVAL function
• Oracle next_day tips
• Oracle nls_lang tips
• Oracle normalization
• Oracle not equals (!=) SQL operator
• Oracle num_rows in dba_tables
• Oracle OAE Training Class
• Oracle OCA practice tests
• Oracle OCM certification tips
• Oracle OCP Tips
• Oracle OLAP dbms_aw_xml
• Oracle OLAP dimensions & cubes
• Oracle OLAP Hierarchical Tools
• Oracle OOAD Database Design Object Oriented
• Oracle on the Internet
• Oracle on Windows Vista
• Oracle online systems for data scrubbing
• Oracle online table reorganization
• Oracle Open World 2004
• Oracle OpenWorld 2004 top speakers & best sessions
• Oracle opt_param SQL hint tips
• Oracle Optimal Flexible Architecture (OFA)
• Oracle optional features
• Oracle ora_rowscn and the rowdependencies clause
• Oracle ora-01031 tips
• Oracle ORA-07445 exception tips
• Oracle Orion tool
• Oracle Outer Join Tips
• Oracle pagination SQL tips
• Oracle parallel DML
• Oracle parallel DML: Deadlock Detected: ORA-00060
• Oracle parallel query OPQ
• Oracle Parse to Execute Ratio
• Oracle Partition Key Statistics & tuning
• Oracle partition SQL queries
• oracle partitioning
• Oracle partitioning and tables - partition-wise joins
• Oracle password protection tips - November 8, 2007
• Oracle password tips
• Oracle Password Security
• Oracle passwords - changing, expiring and locking users
• Oracle Peoplesoft Tuning
• Oracle performance best practices
• Oracle PHP programming tips
• Oracle PL/SQL If Statements
• Oracle PL/SQL select into clause
• Oracle ports tips
• Oracle predictions - Correlation vs. Causation
• Oracle primary keys
• Oracle production access control
• Oracle professionals in high demand for 2008
• oracle programming
• Oracle query_rewrite_integrity and query_rewrite_enabled
• Oracle RAC Architecture
• Oracle RAC cluster fencing tips
• Oracle RAC clusters for personal computers
• Oracle RAC Configuration
• Oracle RAC course
• Oracle RAC Extended Distance Clusters
• Oracle RAC File I/O Monitoring Scripts
• Oracle RAC GCS Monitoring
• Oracle RAC Health Checks
• Oracle RAC installation
• Oracle RAC load balancing tips
• Oracle RAC Monitoring
• Oracle RAC on a Linux PC tips - December 29, 2007
• Oracle RAC partitioning
• Oracle RAC performance in STATSPACK & AWR reports
• Oracle RAC review by Microsoft SQL Server
• Oracle RAID
• Oracle RAM shared memory errors
• Oracle RBO and CBO for OLTP
• Oracle RBO and CBO for OLTP2
• Oracle reactive monitoring tools
• Oracle read-only table tips - December 15, 2007
• Oracle recovering dropped table DDL
• Oracle recursive SQL and STATSPACK
• Oracle Recycle Bin
• Oracle redo allocation latch misses
• Oracle refcursor tips
• Oracle regression testing tips
• Oracle regular expressions
• Oracle Regular Expressions
• Oracle Regular Expressions for date address and telephone number formats
• Oracle Regular expressions indexes as a tuning tool
• Oracle Regular Expressions with regexp_like parsing
• Oracle releases and platforms
• Oracle rename data file tips
• Oracle rename table syntax
• Oracle rename tablespace tips
• Oracle Replication Conflict Resolution
• Oracle Replication Tips - October 21, 2007
• Oracle replication: ORA-23318: a DDL failure has occurred
• Oracle resource profile tips
• Oracle Results Sets   12-1-07
• Oracle Resumable Space Allocation - November 1, 2007
• Oracle Ring of Fire Conference
• Oracle rman
• Oracle RMAN backup strategies for very large databases - November 25, 2007
• Oracle rman backups from Windows Script
• Oracle RMAN Tips
• Oracle RMAN vs. Export
• Oracle Rollback Segments Min Extents
• Oracle rolling upgrades
• Oracle rootkits
• Oracle round date function tips
• Oracle row locks and row level locking
• Oracle Row Re-sequencing
• Oracle Ruby on Rails
• Oracle Salary Compensation
• Oracle SAVEPOINT
• Oracle Schedule Automatic STATSPACK Data Collection
• Oracle schema
• Oracle schema change control
• Oracle Schema Components
• Oracle Schema Documentation
• Oracle scripts for Windows
• Oracle Secure Backup Utility
• Oracle segmentation fault tips - November 17, 2007
• oracle select from replication queue?
• Oracle Select Statement
• Oracle selective export with where clause exp expdp
• Oracle sequence caching & performance
• Oracle Sequences
• Oracle server configuration
• Oracle Sessions
• Oracle SGA Sizing
• Oracle shared memory parameters for UNIX/Linux
• Oracle shared pool scripts
• Oracle Shell Scripting Best Practices - December 26, 2007
• oracle shutdown steps
• Oracle Siebel Tuning
• Oracle Solaris parameters
• Oracle Solid-State Disk RAM SAN
• Oracle spends 1.8 billion on research & development in 2006
• Oracle spfile
• oracle spfile example
• Oracle SQL - Find max values within a range of selected values
• Oracle SQL - Find the current day of the week
• Oracle SQL - Find the first day of a month
• Oracle SQL "contains" clause tips
• Oracle SQL "like clause" and index access
• Oracle SQL cost-based optimizer parameter _like_with_bind_as_equality
• Oracle SQL Developer
• Oracle SQL execution statistics with SQL*Plus autotrace command
• Oracle SQL Hints Tuning
• Oracle SQL Injections Attacks
• oracle SQL materialize undocumented hint
• Oracle SQL Optimizer parameters
• Oracle SQL performance with database links - dblink
• oracle sql predicate
• Oracle SQL query rewriting with temporary tables
• Oracle SQL subquery unnesting
• Oracle SQL tips
• Oracle SQL with multiple versions in the library cache
• Oracle SQL*Loader commit point tips - October 27, 2007
• Oracle SQL*Loader sqlldr Control File
• Oracle SQL: displaying multiple columns per row
• Oracle SQL99 WITH Clause
• Oracle SQLERRM
• Oracle SQL Query - Rollup Analytical Function
• Oracle standby database license requirements
• Oracle standby reporting database
• Oracle Statistics
• oracle stats$sql_summary Table
• Oracle Statspack Analyzer
• Oracle STATSPACK Tips
• Oracle Stored Procedures
• Oracle Streams Benchmark Testing
• Oracle Streams conflict resolution
• Oracle Streams Replication Sequence Number Verification
• Oracle Streams Schema replication
• Oracle Sun Solaris Hardware
• Oracle support for daylight savings time emergencies
• Oracle Support Services
• Oracle Synonyms
• Oracle sys and system dictionary schemas
• Oracle SYSDATE and Linux/UNIX date?
• Oracle SYSDATE examples
• Oracle System Events
• Oracle System triggers
• Oracle table hash clusters
• Oracle Table I/O and buffer efficiency monitoring
• Oracle table monitoring
• Oracle table object wait statistics - v$segment_statistics
• Oracle tablespace exports
• Oracle tablespace migrate from dictionary to local managed
• Oracle tablespace script
• Oracle tablespace uniform size extents
• Oracle temporary tablespace groups
• Oracle testing
• Oracle testing to destruction
• Oracle third-party tuning tools
• Oracle Times Ten data caching
• Oracle Timestamp Elapsed Math
• Oracle tkprof utility
• Oracle TNS-12541 tips
• Oracle tnsping command example
• Oracle to_char SQL
• Oracle to_date
• Oracle tools tips
• Oracle TPC Benchmarks QphH
• Oracle Tracing of SQL*Net round trips
• Oracle Training Cruises 2008
• Oracle trending forecasting Signature Analysis
• Oracle trunc tips
• Oracle TRUNCATE
• Oracle tuning as a life-or-death endeavor - October 29, 2007
• Oracle tuning best practices
• Oracle Tuning Consulting
• Oracle tuning scripts
• Oracle University Instructors
• Oracle UNIX pipe command
• Oracle UNIX split command export file 32-bit
• Oracle UNIX to Linux Migration
• Oracle Unrecoverable Datafile Tips
• Oracle update optimal performance best practices
• Oracle Update Statement Syntax
• Oracle upgrade from 10.0.2 to 10.0.3
• Oracle upgrade performance consulting
• Oracle use with Solaris, Linux, AIX, HP/UX and Windows - October 22, 2007
• Oracle User Group Sessions
• Oracle user groups presentation - Ace your Oracle Job Interview
• Oracle user groups presentation - Beyond Oracle10g – A look at the future of Oracle in the 21st Century
• Oracle user groups presentation - Creating a self-tuning Oracle10g Database
• Oracle user groups presentation - Ergonomics best practices for Oracle Developers
• Oracle user groups presentation - Exception Reporting with the Oracle 10g Enterprise Manager
• Oracle user groups presentation - Extending the Power of the Oracle 10g Automated Workload Repository
• Oracle user groups presentation - For Managers Only – Secrets for hiring the best Oracle Professional
• Oracle user groups presentation - Inside the Oracle 10g cost based SQL Optimizer
• Oracle user groups presentation - Inside the Oracle10g Automatic Database Diagnostic Monitor
• Oracle user groups presentation - Insider tips for Oracle Application Express (Apex HTML-DB)
• Oracle user groups presentation - Is Oracle an Art, craft or a Science?
• Oracle user groups presentation - Oracle DBA predictive modeling
• Oracle user groups presentation - Oracle Quality Assurance Techniques
• Oracle user groups presentation - Oracle SQL Tuning Secrets
• Oracle user groups presentation - Oracle10g Privacy Security Auditing Techniques
• Oracle user groups presentation - Oracle10g Wait Event Tuning with the Automated Session History Tables
• Oracle user groups presentation - Predicting the benefit from an Oracle maintenance activity
• Oracle user groups presentation - Scaling Oracle Application Express for large systems projects
• Oracle user groups presentation - The Changing role of the Oracle Professional of the 21st Century
• Oracle user groups presentation - Tuning Tips for Oracle Application Server 10g
• Oracle user groups presentation - Understanding Interpersonal Relations in Oracle Technology
• Oracle user script
• Oracle utl_file Package
• Oracle utl_smtp utility
• oracle v$log_history
• Oracle v$session user connections
• Oracle Validated Configurations
• oracle varray
• Oracle Varrays
• Oracle Veritas vxfs filesystem optimization
• Oracle version control & change control tips
• Oracle version control and change control?
• Oracle Virtual Private Databases VPD multiple policy values
• Oracle vmware tips -  November 13, 2007
• Oracle Warehouse Builder (OWB) vs. Manual data loading
• Oracle webcast on Oracle Windows 64-bit
• Oracle webcast on server consolidation
• Oracle WHERE clause
• Oracle Windows - changing the font in SQL*Plus
• Oracle Windows alert log script
• Oracle Windows external user authentication
• Oracle Windows installer failure tips
• Oracle Windows Monitoring tips
• Oracle on Windows tips
• Oracle Windows tips - October 21, 2007
• Oracle Windows with multiple ORACLE_HOME registry values
• Oracle WITH clause
• Oracle with SAN NAS disks
• Oracle workload analysis tips
• Oracle Workspace Manager
• Oracle Worst Practices
• Oracle Wrap Utility
• Oracle x$ tables
• Oracle x$ksmlru and x$ksmsp for shared pool monitoring
• Oracle XE Features - January 17, 2008
• Oracle XLS Upload approaches
• Oracle XML Schema Definition XSD
• Oracle: bitmap conversion to rowid
• Oracle: Coalesce vs. deallocate unused space
• Oracle: convert BLOB to VARCHAR datatype - September 28, 2007
• Oracle: disable flashback - October 27, 2007
• Oracle: export procedures & triggers
• Oracle: move tablespace datafile between filesystems
• Oracle: restart OEM agent
• oracle_10g_new_features  - Ahmed Baraka
• Oracle10g Release 2 10g Case insensitive searches
• Oracle10g SQL*Trace Changes
• Oracle8i hidden trace parameters
• Oracle9i desupport date set for July 2007
• oradim
• orakill
• Organizing Oracle Not-for-profit Functions
• OS commands for RAC
• OUI-10151 During Install tips - October 17, 2007
• overview of STATSPACK install scripts
• Parallel query error ORA-12801
• Parsing with regular expressions regexp_like
• Partitioning an Oracle table
• Peoplesoft Configuration & Oracle Consulting
• Personality assessment for business professionals
• pga_aggregate_target
• pivoting one row of several columns into one column of several rows
• PL/SQL - Passing Large Data Structures with NOCOPY
• PL/SQL best practice Standards
• PL/SQL best practice Standards
• PL/SQL Capitalization Best Practices Standards
• PL/SQL code alignment standards
• PL/SQL features by release
• PL/SQL IF Statement syntax example
• PL/SQL Indentation Standards
• PL/SQL Named Notation Tips
• PL/SQL NOCOPY Tips
• PL/SQL ORA-01008 : Not all variables bound
• PL/SQL Package naming standards
• PL/SQL parallel processing
• PL/SQL Performance tips - October 18, 2007
• PL/SQL Programming Design Standards