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!

• Oracle correlates with Global Warming! - August 2010

• Everybody loves a fireman - April 2010

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

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

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

• Update on RBO in Oracle10g - September 10, 2003

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

• OracleWorld 2003 Update - September 5, 2003

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

• Oracle9i XML Security Exposure Patch - August 24, 2003

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

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

• Justify your Oracle partitioning project - July 22, 2003

• Inside the Oracle SGA regions - July 31, 2003

• Oracle9i sorting enhancements - July 29, 2003

• Find top Oracle sessions - July 24, 2003

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

Freeman Oracle Tips Archive

• Oracle read-only tablespaces and performance - June 2005

Oracle Articles & quick tips

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

• _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
• PL/SQL recursive calls: recursion in Oracle
• PL/SQL ref cursor tips
• PL/SQL Spacing Standards
• PL/SQL Statements Per Line
• PL/SQL Trigger naming standards
• PL/SQL variable naming standards
• plan9i.sql script
• plsql_optimize_level
• Poor Oracle performance after 64-bit server migration
• Poor Quality, Diploma Mill MBA Schools
• Praetoriate Oracle Tips
• Pragma serially_reusable
• Predict table and index full-scan activity
• Preliminaries – Before You Enable the 10046 Event
• Preventing table DDL
• Privacy concerns with Oracle Configuration Manager - October 27, 2007
• professional golf etiquette for IT professionals
• Pursuing a career in Oracle Medical Informatics
• Purge Oracle Recyclebin
• RAC and Oracle data warehouse
• RAC clusters for laptop computers
• RAC GES Monitoring
• RAID5 acceptable for Oracle databases
• Reading a STATSPACK report
• Reading SQL 10053 trace files
• Real Time SQL Monitoring tips - January 8, 2008
• Real-time web server traffic monitors - Live statistics
• Reclaiming Oracle disk space
• Recommended Oracle job scheduling book
• Recover a dropped table in Oracle
• Reducing undotbs01.dbf tips - October 19, 2007
• Refresh test database from production schema
• Refreshing an Oracle Materialized View
• Regular Expressions and Oracle Performance function based indexes
• Regular expressions for parsing-out substrings from larger strings
• Relationship between instance_name, ORACLE_SID and service_name
• Remote Oracle Support
• Removing Archive Log files from Enterprise Manager September 18th, 2007
• removing expensive "merge join cartesian"
• Removing like breaks from Oracle column data
• Removing sensitive Oracle data
• Renaming files from inside PL/SQL
• Reorganization with "alter table xxx move" syntax
• repair corruption with UNDO tablespace
• Republishing a libel & internet censoring
• Resolving host names with DNS for Oracle
• Resolving ORA-12705: Cannot access NLS data files or invalid environment specified
• Resolving the ORA-12705 error
• response time monitoring
• reverse key indexes
• Rittman OWB articles
• RMAN-03009: failure of backup command
• RMAN large pool PGA RAM tips
• RMOUG 2006 Conference speaker evaluations
• row resequencing webcast
• rules for internet journalists
• Sample STATSPACK (AWR) Analysis
• Sample Table Scans and Oracle Dynamic Sampling
• SAP Oracle Configuration Consulting
• SAP Oracle Tuning
• Scam to fool Google by simulating Oracle web sites
• Scheduled job completion verification
• Scheduling Oracle jobs in Windows
• Scheduling weekly, monthly and yearly jobs
• Script to compute Oracle table size
• Script to display SQL Server files for autogrowth
• Script to display SQL Server locks
• Script to verify that Oracle database is running
• Search Engine Precision and Recall
• Search Engine word stemming and synonym expansion
• segment_type in dba_segments
• Segregate tables and indexes on disks?
• Sending e-mail from HTML-DB
• Sending e-mail from Oracle
• Sending e-mail with wwv_flow_mail
• session_cached_cursors sizing
• Setting nls_date_format September 5th, 2007
• Setting Oracle environment variables in Linux/UNIX
• Setting SQL bind variables
• Shortcomings of the 10046 Event
• Show redo volume for an active DML transaction
• Signature Analysis of Wait Events
• Simulating Oracle server & disk failures
• Single-task versus two-task or multitask structure
• SLA - Service level agreement tips
• Slony-I tips
• software regression modeling for Oracle
• sort merge join tips - December 12, 2007
• Spyware and Adware Detection and Immunization
• SQL - Find number of commas with a string
• SQL best practices
• SQL design patterns tips
• SQL hanging on TEMP space usage - October 18, 2007
• SQL Tuning with Transitive Closure
• SQL Server 2005 script to display disk space usage
• SQL Server capacity planning scripts
• SQL Server database fragmentation script
• SQL Server file I/O script
• SQL Server script to find disk bottlenecks
• SQL Server table Fragmentation script
• SQL Server Health Checks
• sql server users groups
• SQL Server workload script
• SQL*Loader - loading data into multiple tables
• SQL*Loader External Tables
• sqlldr
• sqlldr reorg
• sqlnet_expire_time and dead connection detection
• SSD coming for Oracle PC Applications
• stats$enqueuestat Table
• stats$latch Table
• stats$latch_misses_summary Table
• stats$rollstat Table
• stats$waitstat Table
• STATSPACK oracle
• STATSPACK Oracle9i SQL Snapshot thresholds
• STATSPACK purge utility
• STATSPACK Snapshot thresholds
• Steps to install STATSPACK
• Stochastic methods for Oracle holistic tuning - September 29,2007
• stopping a queue error: ORA-03113: end-of-file on communication channel
• Storing MS-Word docs in Oracle
• Storing pictures and photos in Oracle tables
• Subtract SQL result sets? -  December 13, 2007
• Superfluous overhead in Oracle
• Supporting HTML-DB JavaScript and Cascading Style Sheets
• SYSAUX tablespace
• System Date errors and computer application exposure
• table rename column
• tablespace change extant management local uniform to autoallocate
• Taking a STATSPACK or AWR snapshot
• Taking a STATSPACK report
• Terminating Oracle connections with connect_time, idle_time, expire_time and inbound_connect_timeout
• The Art of Oracle Heuristic “Rule of Thumb” Tuning
• Why Oracle is not like CA
• The best Linux books
• The best of IOUG Collaborate 2006
• The best Oracle authors
• The History of Oracle
• The Oracle Manuals
• The origin of Oracle scott/tiger - Tony Jambu
• The perils of server deconsolidation - November 18, 2007
• The Plague of Large Oracle Disks
• The Publish/Subscribe Model for Oracle Replication
• The Screaming Banshee
• They AMM to Please...Sometimes
• Tips for ORA-02292 Constraint violation - child records found
• Tips for reading Oracle trace files
• Tips for using the COMPATIBLE parameter - November 17, 2007
• TLD e-mail filtering masks
• TNS-01190: The user is not authorized to execute the requested listener command lsnrctl
• TNS-12531 error
• TNS-12560: TNS:protocol adapter error
• tnsnames.ora
• tnsnames.ora dns host server name
• Top 10 Reasons for poor Oracle performance
• top job interview questions
• Top Oracle books now available overseas
• Top Oracle developer certification & skills
• trace Oracle bind variable values
• Tracing Events
• Tracing Oracle Sessions
• Tracking & Monitoring table growth
• Tracking Oracle full table scans
• Tracking Oracle hash joins
• Tracking Oracle schema changes
• transposition errors with Oracle regular expressions
• Troubleshooting & diagnosing TNS SQL*Net connectivity errors
• Troubleshooting network TNS SQL*Net connectivity - November 17, 2007
• Tuning Cognos on Oracle
• Tuning large oracle batch jobs
• Tuning Linux VM on Kernel 2.6
• Tuning Oracle redo logs
• Tuning Oracle SQL subqueries
• Tuning Oracle UNDO segments
• Tuning Oracle with NUMA on Solaris 9
• Tuning SQL inside Oracle batch jobs - October 31, 2007
• Tuning SQL with STATSPACK & AWR
• Tuning SQL with temporary tables
• Types of Oracle auditing?
• Unauthorized Network access becomes a felony
• undo tablespace sizing
• UNDO tablespace with autoextend
• United States SECRET security clearances. Costs, time required, and disqualifying conditions
• UNIX commands from inside Oracle
• Upgrade Oracle Applications R11i version 11.5.5 invalid Java class
• Using asm_diskstring for LUN's in Solaris multipathing
• Using dba_optstat_operations
• Using dbms_hprof to trace PL/SQL execution
• Using explain plan
• Using faster hardware to correct an Oracle performance problem
• Using Google keyword searches to Find Oracle Information
• Using Oracle to capture UNIX/Linux vmstat output
• Using ORADEBUG To Set A Trace Event
• Using SQL*Loader to Reorganize Oracle Tables
• Using SQL*Plus autotrace
• Using TDE with Partitioning and OLS
• Using the APPEND hint with the MERGE (upsert) SQL - November 14, 2007
• Using the Oracle _convert_set_to_join parameter
• Using The SQL MODEL Clause
• Using the up arrow key for command history in Oracle
• Using utl_recomp
• Using v$sql_monitor - November 22, 2007
• v$active_session_history
• v$asm_file extraction script
• v$bh status column and free RAM blocks
• v$cache_transfer
• v$event_histogram tips
• v$lock wait events
• v$logmnr_contents tips
• v$pq_tqstat script? - January 12, 2008
• v$sql_plan_statistics
• v$system_event
• Verifying & Auditing Data Replication Oracle
• Vertical vs. Horizontal scalability for Oracle
• View Oracle patents
• Viewing Oracle CPU and I/O costs
• Viewing SQL execution details over time
• VOUG 2006: Virginia Oracle Users Conference Speakers
• Warning: Product user profile information not loaded  - January 9, 2008
• Web Predators book
• Web Server page compression tips
• Web Stalkers Book exposes criminal tactics
• webcast - Sorted Hash Clusters
• webserver RAM caching tips
• Webserver Traffic Monitoring Tips
• Welcome to My Nightmare – The Common Performance Errors in Oracle Databases
• What to do when somebody seals your web content?
• What to do when you cannot connect to Oracle - January 8, 2008
• Why choose Oracle?
• Why use a small data block buffer cache with solid-state disks?
• Windows Oracle Job Schedulers examples
• Windows script to display SQL Server Disk Usage
• Word 2007 docx file conversion - October 23, 2007
• world record data warehouse benchmark
• Writing conditional messages to SQL*Plus spool file
• Writing Efficient Oracle SQL
• Writing Oracle BLOB to OS file
• Writing to the Oracle Alert Log
• Zero Day attack definition
• 利用Oracle数据库存储和分析Unix操作系统的性能

open web page in expression web from browser

Oracle 12c New Features Training Course

Upgrading to Oracle 12c training class

Oracle 12c New Features training in Oracle12c

Linux block_devices

Linux character devices

Linux named pipes

Linux sockets

Linux: sending output to a File

escape special characters

Linux PATH variable Tips

Moving Oracle control files

How to disable AWR

dbms_stats run frequency tips -    28 October, 2012

SCN change tips -   28 October, 2012

Find function-based indexes -  26 October, 2012

Find function-based indexes - 26 October, 2012

Limiting Oracle table size - 26 October, 2012

Data Guard fal_client and fal_server - 25 October, 2012

RMAN backup of ASM disk - 24 October, 2012

RMAN convert file to ASM storage -   24 October, 2012

Calling COBOL from PL/SQL -  24 October, 2012

ORA-01153: an incompatible media recovery is active tips - 22 October, 2012

_use_adaptive_log_file_sync tips - 22 October, 2012

ORA-01722: invalid number & SQL*Loader - 22 October, 2012

ORA-16792 Tips -  17 October, 2012

ILM clause Tips - 17 October, 2012

12c Transaction Guard Tips - 17 October, 2012

Hybrid Histograms tips - 16 October, 2012

adaptive execution plan tips - 16 October, 2012

Pluggable Database Tips - 15 October, 2012

Oracle data copy speed - 15 October, 2012

Display maxsize for a data file - 11 October, 2012

dbms_scheduler dictionary views - 9 October, 2012

Obsolete Import Utility Parameters - 9 October, 2012

RMAN convert clause tips - 9 October, 2012

TOAD: ORA-01031: Insufficient privileges - 9 October, 2012

Create tablespace using ASM - 9 October, 2012

Invalidating SQL after running dbms_stats - 8 October, 2012

Index full scan tips - 7 October, 2012

RMAN section size tips -  7 October, 2012

RMAN maxpiecesize tips -   7 October, 2012

import schema with impdp Tips -  6 October, 2012

ORA-01276: Cannot add file Tips -  6 October, 2012

dba_parallel_execute_chunks Tips -  4 October, 2012

Negative value in an AWR report -  4 October, 2012

Using substr with multibyte character sets - 2 October, 2012

Guaranteed Restore Point tips - 1 October, 2012

Oracle extent overhead tips - 27 September 2012

awr_sql_report_text tips - 27 September 2012

Oracle table performance tips - 26 September 2012

dbms_workload_repository topnsql Tips - 26 September 2012

Increase the maximum number of open file descriptors in Linux - 26 September 2012

AWR: high water mark of sessions - 25 September 2012

df command in Oracle - 23 September 2012

Oracle: Using the UNIX mount command - 23 September 2012

Find UNIX file blocksize - 23 September 2012

Oracle lsof command tips - 23 September 2012

identity column tips - 21 September 2012

RMAN ORA-01403 No Data Found Tips - 20 September 2012

File management between primary and standby database Tips - 20 September 2012

db_file_name_convert Tips - 20 September 2012

Shutdown Timeout Tips - 19 September 2012

Oracle change execution priority - 18 September 2012

Oracle display RAM - 18 September 2012

Oracle controlfile I/O Tips - 18 September 2012

SQL*Loader bad file vs discard file - 18 September 2012

Real-time ADDM -   15 September 2012

SQL Commonality Index Tips -   15 September 2012

Recursive PL/SQL -  15 September 2012

Remote file copy tips -  15 September 2012

ASH Analytics -  11 September 2012

Recursive PL/SQL - 9 September 2012

How to execute multiple sql files in DOS Windows - 6 September 2012

v$shared_pool_reserved tips -  5 September 2012

Row cache enqueue lock tips -  5 September 2012

ORA-31693: Table data object failed to load/unload error - 5 September 2012

ASM intelligent file placement Tips - 2 September 2012

v$asm_disk_iostat Tips - 2 September 2012

Oracle index rebuild online  - 2 September 2012

Oracle defragmentation Tips - 1 September 2012

Copy Oracle BLOB -  31 August, 2012

How to insert a video into an Oracle database  -  31 August, 2012

Difference between CONSISTENT and OBJECT_CONSISTENT parameter -  30 August, 2012

Data Recovery Advisor tips -  29 August, 2012

Reset SYS password tips - 29 August, 2012

Oracle block format tips - 27 August, 2012

Oracle merge hint tips -  23 August, 2012

Oracle alter table shrink compact -  22 August, 2012

Oracle library cache SQL hash value -  22 August, 2012

Automatic re-start of Oracle on Windows -  21 August, 2012

Alert when Oracle refuses connections -  19 August, 2012

Alert on hung Oracle database -  19 August, 2012

Alert oracle database crash -  19 August, 2012

Backup oracle files with tar -  19 August, 2012

Copy tnsnames.ora file tips -  19 August, 2012

Oracle file soft link tips -  19 August, 2012

Change Oracle file permissions with chmod -  19 August, 2012

Materialized view refresh group tips -  17 August, 2012

ASM Background Processes -  11 August, 2012

ASM Instance Management -  11 August, 2012

Tablespace Alert Script -   11 August, 2012

Masking Oracle table rows -  11 August, 2012

Masking Oracle columns Tips - 11 August, 2012

Gupton's Guns Henderson NC

ORA-00494 enqueue [CF] held for too long tips - 8 August, 2012

Oracle SCAN listener tips - 7 August, 2012

Oracle Bulk Collect Tips -  7 August, 2012

PLS-00306: wrong number or types of arguments tips - 5 August, 2012

delete all data rows from Oracle table tips -  2 August, 2012

unexpire Oracle password tips -  1 August, 2012

Reset forgotten password -  1 August, 2012

ORA-28002 tips - 1 August, 2012

Oracle fusion middleware job duties tips  -  1 August, 2012

Oracle Weblogic job duties tips - 1 August, 2012

Oracle client 32 bit or 64 bit? - July 28. 2012

Oracle one-way replication tips  - July 26. 2012

Create snapshot tips - July 26. 2012

Oracle 11g new CBO Optimizer Features- July 23. 2012

undo advisor Tips  - July 22. 2012

MTTR Advisor Tips  - July 22. 2012

dbms_xplan.display_cursor Tips  - July 22. 2012

utl utilities list  - July 22. 2012

utl_coll Tips  - July 22. 2012

Oracle UTL_ENCODE Tips - - July 22. 2012

PL/SQL Boolean Examples - July 22. 2012

difference between RAC public IP, private IP and Virtual VIP - July 18, 2012

DMSYS Schema tips -  July 18, 2012

log_archive_local_first tips - July 12, 2012

standby_log_archive_dest & log_archive_dest tips - July 12, 2012

ORA-01400: cannot insert NULL into ("SYS"."AUDIT_DDL"."DICT_OBJ_TYPE") tips - July 11, 2012

create_stored_outlines tips - July 10,. 2012

dbms_space create_index_cost tips - July 10, 2012

dba_dimensions tips - July 8, 2012

dba_constraints tips - July 7, 2012

dbms_advisor tips - July 7, 2012

dbms_workload_capture tips - July 7, 2012

ORA-25152: TEMPFILE cannot be dropped tips - July 4, 2012

dbms_space_admin tips - July 4, 2012

Why does SQL not choose the lowest cost plan? - July 4, 2012

generate index DDL tips - July 3, 2012

Generate PL/SQL stored procedures from Oracle - July 3, 2012

Generate database DDL tips - July 3, 2012

dbms_redefinition example - July 3, 2012

Import entire schema Tips- July 3, 2012

Import entire tablespace Tips- July 3, 2012

Search a CLOB column tips - July 3, 2012

impdp parameter tips - July 2, 2012

Optimize impdp performance - July 2, 2012

fastest way to join two tables  - July 2, 2012

ORA-26689 Column Type Mismatch tips - June 30, 2012

SQL*Plus timing start and timing stop tips - June 30, 2012

Copying Oracle statistics tips -  June 29, 2012

ORA-09925: Unable to create audit trail file tips -  June 29, 2012

estimate_percent tips  -  June 27, 2012

gc cr current grant busy tips - -  June 26, 2012

gc cr multi block request tips -  June 26, 2012

db link usage script tips -  June 25, 2012

/etc/sysconfig/oracleasm tips - June 25, 2012

ocfs2console tips - June 25, 2012

orastack tips - June 24, 2012

renice tips - June 24, 2012

Tips for Tracing Oracle - June 20, 2012

Share tnsnames.ora tips - June 20, 2012

Share tnsnames.ora tips - June 20, 2012

NETCA tips -  June 19, 2012

Oracle restart tips -  June 18, 2012

How Oracle users are mapped to tablespace files - June 18, 2012

crsctl css pin -n command tips - June 16, 2012

Oracle Capturing Date Information in UNIX - June 14, 2012

Capturing server information in Linux/UNIX - June 14, 2012

Common UNIX/Linux commands - June 14, 2012

Linux dircmp command example - June 14, 2012

TNS connectivity example -  June 14, 2012

Difference between multiplexing and mirroring - June 13, 2012

Oracle Windows binary executables list - June 11, 2012

Oracle UNIX Linux binaries list - June 11, 2012

Oracle packages list - June 11, 2012

Export expdp command syntax - June 9, 2012

expdp parameters for procedures functions and and packages - June 9, 2012

The value of MAXTRANS parameter ignored tips - June 7, 2012

SP2-1503: Unable to initialize Oracle call interface tips - June 6, 2012

oracleasm command tips - June 4, 2012

ASM create diskgroup tips  - June 4, 2012

ASM external redundancy  - June 4, 2012

dcmctl command tips - May 31, 2012

Oracle relink command tips - May 31, 2012

Oracle file striping tips - May 31, 2012

dbms_stats compare statistics tips -  May 29, 2012

dbms_stats incremental statistics tips - May 29, 2012

ORA-12008 tips - May 26, 2012

raw vs. cooked Oracle file tips - May 25, 2012

Change SYSDATE display value Tips - May 25, 2012

/etc/sysconfig/clock zone values - May 25, 2012

ORA-00308 cannot open archived log tips - May 16, 2012

 ASM allocation units for RAC - May 13, 2012

Oracle: display euro symbol € - May 10, 2012

Oracle Linux server sizing tips - May 10, 2012

AWR Global RAC report tips -  May 9, 2012

olsnodes command tips -  May 9, 2012

RAC Policy managed database tips - May 8, 2012

RAID 10 vs RAID 0+1 Tips - May 8, 2012

Consistent read block tips - May 8, 2012

Dirty block tips - May 8, 2012

Purpose of the large pool -  May 8, 2012

RAC global resource directory tips -  May 8, 2012

RAC heartbeat tips -  May 8, 2012

11g hint list - May 8, 2012

RAC voting disk tips -  May 7, 2012

 Startup mount tasks tips - May 7, 2012

Debugging utl_smtp email tips -   May 6, 2012

Oracle trigger validation tips -  May 2, 2012

Oracle incremental checkpoint tips -  May 2, 2012

  Oracle RAC Grid Differences -  May 2, 2012

Oracle cluster tables tips

Oracle cluster index tips -   May 1, 2012

Select rows per block in Oracle -   April 29, 2012

Select first 10 rows from an Oracle table -   April 28, 2012

Select last 100 rows from an Oracle table -   April 28, 2012

Server room standards Tips -   April 20, 2012

ORA-00028 Tips -   April 20, 2012

Oracle export import character set differences -  April 19, 2012

Find Oracle system roles-  April 19, 2012

SQL*Plus single logon attempt Tips -  April 19, 2012

SQL*Plus restriction Tips -  April 19, 2012

ref cursor examples  -  April 18, 2012

ORA-06504 ref cursor OUT Tips -  April 18, 2012

Running WebCenter from Weblogic tips -  April 17, 2012

ORA-00904 when select nvarchar from SQL Server -  April 17, 2012

ORA-30683: failure establishing connection to debugger tips -  April 16, 2012

ASM disk does not exist or is not instantiated tips -  April 15, 2012

extract data files from RMAN tips -  April 14, 2012

RAC: IP address has already been used tips -  April 14, 2012

authid current_user Tips -  April 13, 2012

Oracle PAE Tips -  April 13, 2012

Oracle HACMP Install Tips -  April 13, 2012

Oracle Total Recall Tips -  April 11, 2012

RAC CRS will not start tips -  April 11, 2012

Oracle estimate percent tips -  April 10, 2012

Recover a missing control file tips -  April 9, 2012

ORA-00205: error in identifying controlfile -  April 9, 2012

Recover Oracle after losing a data file  - April 9, 2012

Oracle control file tips - April 9, 2012

dba_hist_undostat tips - April 7, 2012

DBA_DATAPUMP_JOBS Tips - April 4, 2012

SQL to convert a day of the week to a number - April 4, 2012

ORA-31626 tips - April 4, 2012

Why is my index not being used? - April 3, 2012

Oracle mlog$ tips - April 2, 2012

Oracle drop tips - April 2, 2012

Oracle sqlcode tips - April 1, 2012

Oracle sqlcode = 100 tips  - April 1, 2012

sqlnet.inbound_connect_timeout tips - April 1, 2012

v$transaction tips - April 1, 2012

alter database backup controlfile to trace - April 1, 2012

for update nowait tips - April 1, 2012

for update wait tips - April 1, 2012

pls_integer tips - April 1, 2012

v$locked_object tips - April 1, 2012

elsif tips  - April 1, 2012

Oracle multi-column subquery tips -   March 31, 2012

Oracle correlated subquery tips -   March 31, 2012

Oracle memory usage tips -   March 31, 2012

v$sql scripts -   March 31, 2012

Oracle Bulk Insert tips -  March 31, 2012

Oracle VARRAY Table tips -  March 31, 2012

Oracle Nested Table tips -  March 31, 2012

parallel hint tips -  March 31, 2012

update multiple columns tips -  March 31, 2012

Calling an Oracle function -  March 31, 2012

Calling an Oracle stored procedure -  March 31, 2012

index range scan tips -  March 30, 2012

index fast full scan tips -  March 30, 2012

SQL plan not reproducible -  March 30, 2012

Oracle Constraint Tips - March 29, 2012

nvl vs. nvl2 - March 28, 2012

lnnvl Tips - March 28, 2012

Update table Oracle tips - March 27, 2012

v$sqltext tips - March 27, 2012

sys.aud$ tips -  March 27, 2012

Oracle spool tips - March 27, 2012

ORA-01820 tips - March 26, 2012

obtool command tips - March 23, 2012

Oracle SQL nested subqueries tips - March 19, 2012

v$sesstat tips - March 19, 2012

PL/SQL function examples - March 18, 2012

PL/SQL assignment statement examples - March 18, 2012

PL/SQL constant examples - March 17, 2012

 PL/SQL accept command tips - March 17, 2012

Format Report output with PL/SQL - March 17, 2012

SQL*PLus print command tips - March 17, 2012

Display blank lines with PL/SQL - March 17, 2012

PL/SQL: join tables together tips - March 10, 2012

Find SQL with excessive hard parses - March 3, 2012

Global temporary table example - March 3, 2012

Oracle: How to drop a histogram - March 3, 2012

11gr2 cursor_sharing=force bug causes contention - March 3, 2012

Tuning WHERE NOT EXISTS Tips - March 3, 2012

Convert to a blob tips - February 27, 2012

PL/SQL function restriction tips -   February 26, 2012

PL/SQL read file tips -  February 25, 2012

PL/SQL object type examples -  February 23, 2012

PL/SQL associative array examples -  February 23, 2012

PL/SQL function examples -  February 23, 2012

PL/SQL implicit cursor examples -  February 23, 2012

PL/SQL FOR Loop examples -  February 23, 2012

PL/SQL Collection tips -  February 22, 2012

PL/SQL associative array tips -  February 22, 2012

PL/SQL nested table tips -  February 22, 2012

SQL*Plus set command tips -  February 21, 2012

Oracle SQL Tuning Quick Reference cheat sheet -  February 21, 2012

Inserting Chinese character set tips -  February 21, 2012

Size threshold for partitioning tips - February 20, 2012

dbms_auto_sqltune tips - February 11, 2012

AWR dba_hist_colored Table - February 11, 2012

11.2 new v$ WLM views - February 11, 2012

11.2 new v$ QMON views - February 11, 2012

11.2 new v$ iostat views - February 11, 2012

Oracle 11.2 new GoldenGate v$ views - February 11, 2012

Oracle 11.2 new v$ dnfs views - February 11, 2012

11.2 new v$ diag views - February 11, 2012

Oracle 11.2 new AWR Tables - February 11, 2012

11.2 new v$ views - February 11, 2012

column "set unused" drop column tips - February 9, 2012

SQL to select tables with rows - February 9, 2012

Streams Logical Standby as propagator the receiver - February 6, 2012

How to display and show referential integrity constraint violations - February 3, 2012

What does TKPROF stand for? - February 2, 2012

Difference between db block gets and consistent gets and physical reads?  February 2, 2012

SQL to exclude rows without strings - January 31, 2012

Oracle sharding tips - January 31, 2012

x$ir incident reporting tips -  January 27, 2012

x$ir incident reporting tips -  January 27, 2012

ORA-22835: Buffer too small tips -  January 27, 2012

x$ kernel service & cache table tips -  January 26, 2012

v$memory_dynamic_components tips EOI-  January 26, 2012

11g Streams v$ Views  EOI-  January 26, 2012

Oracle 11g RMAN v$ Views  EOI-  January 26, 2012

Oracle 11g ASM v$ Views  EOI-  January 26, 2012

11g SQL Tuning v$ Views - EOI-  January 26, 2012

Oracle 11g SGA Pool v$ Views - EOI-  January 26, 2012

Oracle 11g RMAN v$ Views - EOI-  January 26, 2012

parallel/partition aware SQL tips January 25, 2012

Oracle packet analyzer tips - January 24, 2012

Display directory file sizes - January 24, 2012

Get root system user privileges on a Windows server - January 20, 2012

example stored procedure - January 20, 2012

extproc: no such file or directory - January 19, 2012

alter database datafile resize Tips - January 19, 2012

SQL 2nd highest row value tips - January 19, 2012

incremental statistics tips - January 18, 2012

ORA-00704 bootstrap process failure tips - January 18, 2012

alter database create datafile - January 17, 2012

alter database add logfile - January 17, 2012

alter database add datafile tips - January 17, 2012

add tempfile temp tips - January 17, 2012

add partition tips - January 17, 2012

User password encryption tips - January 17, 2012

Physical Standby Database tips - January 17, 2012

Data Guard archive redo gap tips - January 12, 2012

Server side Data Guard broker tips - January 12, 2012

Data Guard standby database recovery mode tips - January 12, 2012

Flashback Sizing - January 12, 2012

Example Data Guard Configuration - January 12, 2012

Data Guard operational constraints - January 12, 2012

Data Guard Background processes tips  - January 12, 2012

Data Guard Standby Tips - January 12, 2012

Data Guard Logical Standby Tips - January 12, 2012

Data Guard Manual Failover Tips - January 12, 2012

Data Guard Disaster Recovery tips - January 12, 2012

Oracle-02236 Tips - January 11, 2012

Virtual Circuit wait tips - January 11, 2012

 Justify migrating from Windows to Linux - January 10, 2012

Windows DOS vs. Unix commands - January 10, 2012

v$datafile_header tips - January 9, 2012

dbms_stats.set_column_stats tips - January 9, 2012

dbms_stats.set_index_stats tips - January 9, 2012

dbms_stats.set_table_stats tips - January 9, 2012

dbms_sqldiag tips - January 8, 2012

v$iostat_file tips - January 8, 2012

v$iostat_consumer_group tips - January 8, 2012

v$iostat_function tips - January 8, 2012

publish pending stats tips - January 8, 2012

v$sql_plan_monitor tips - January 8, 2012

dba_audit_exists Tips - January 7, 2012

dba_audit_trail Tips - January 7, 2012

 dba_audit_session Tips - January 7, 2012

Oracle Auditing Tips - January 7, 2012

dba_audit_statement tips - January 6, 2012

dba_audit_object tips - January 6, 2012

dba_obj_audit_opts tips - January 6, 2012

dba_priv_audit_opts tips - January 6, 2012

dba_stmt_audit_opts - January 6, 2012

Monitoring TEMP tablespace activity - January 5, 2012

Monitoring tablespace usage tips- January 5, 2012

oraenv tips - January 5, 2012

Automatic Oracle startup on Windows Tips - January 5, 2012

Automatic Oracle startup on HP/UX Tips - January 5, 2012

Automatic Oracle startup on AIX Tips - January 5, 2012

Automatic Oracle startup on Linux Tips - January 5, 2012

Automatic Oracle startup on Solaris Tips - January 5, 2012

CDC with CLOB example - January 5, 2012

RMAN-06059 Tips - January 4, 2012

RMAN crosscheck Tips - January 4, 2012

db_recovery_file_dest_size Tips - January 4, 2012

Oracle ROWID Tips - January 2, 2012

See All Roles Granted to a User Tips- January 2, 2012

db_lost_write_protect tips - January 2, 2012

db_block_checksum tips - January 2, 2012

db_ultra_safe Tips - January 2, 2012

Fix frequent log switches - January 1, 2012

Delete shared memory segments in Windows - January 1, 2012

SOPA Act to shut-down foreign web sites! - January 1, 2012

Mismanaging data queues with dbms packages  December 27, 2011

Translate dropped recycle bin table tames - December 27, 2011

Becoming an OBIEE or SAS Data Analyst - December 26, 2011

dbms_packages util release dates - December 21, 2011

Save transportable tablespace database link - December 21, 2011

Save Secure Oracle Passwords online - December 17, 2011

Example of RMAN shell script - December 17, 2011

display all years between two dates - December 16, 2011

Add Datafile to Oracle - December 16, 2011

Alter Tablespace Add Datafile - December 16, 2011

Foreign Key Constraint Tips - December 16, 2011

Unique Constraint Tips - December 16, 2011

Primary Key Constraint Tips - December 16, 2011

NOT NULL Constraint Tips - December 16, 2011

Check Constraint Tips - December 16, 2011

Oracle TCL Tips - December 16, 2011

Oracle DCL Tips - December 15, 2011

Make a custom Oracle error message - December 14, 2011

ORA-24010 tips - December 13, 2011

JMS-178 Invalid Queue name - December 12, 2011

Oracle Inactive Session Tips - December 12, 2011

Concurrent DML & DDL Tips - December 9, 2011

nested_table_set_refs Tips - December 9, 2011

TNS-12502 Tips - December 5, 2011

Oracle SQL tuning with cardinality estimates - December 4, 2011

Stop unauthorized connections to Oracle - December 3, 2011

Oracle 2012 Salary Tips - December 3, 2011

ADRCI Error 19809 creating archive log file - December 1, 2011

SQL to display all months between two dates - December 1, 2011

dbms_assert tips - December 1, 2011

Oracle convert ANSI to UTF8 - November 27, 2011

Oracle convert function - November 27, 2011

ORA-00924 Missing BY keyword tips - November 23, 2011

v$asm views and x$ tables for ASM - November 23, 2011

Oracle ASM Parameters - November 23, 2011

ASM data file name tips - November 23, 2011

ORA-12514 on Data Guard Switchover - November 21, 2011

dbms_apply_adm.set_schema_instantiation_scn tips - November 21, 2011

dba_segments tips - November 20, 2011

dbms_libcache tips - November 19, 2011

ORA-15064 tips - November 19, 2011

ORA-26840 tips - November 19, 2011

Oracle Reinstantiation Tips - November 19, 2011

emcli command tips - November 19, 2011

List all table and column privileges  - November 19, 2011

How to export/unload a BLOB/CLOB  - November 19, 2011

Oracle instance_role tnsnames tips - November 19, 2011

ORA-29702 ksuitm: waiting - November 19, 2011

Shrink TABLESPACE Tips - November 19, 2011

Add a foreign key constraint to a table with duplicates - November 18, 2011

Oracle e-mail attachment tips  - November 18, 2011

RMAN could not locate the LNM save file tips - November 18, 2011

Using the RMAN Duplicate command - November 18, 2011

How to encrypt data to one listener - November 17, 2011

Difference between dbms_output.put_line and utl_file.put_line  - November 17, 2011

Automate export to test instance - November 17, 2011

Intermittent ORA-01017 errors - November 17, 2011

Display disabled instances in CRS - November 17, 2011

Intermittent Oracle client connect problem - November 17, 2011

Count by year in a date columns - October 31, 2011

Count by month in a date columns - October 31, 2011

Count by day in a date columns - October 31, 2011

Loadjava sql/oracle/BLOB jar file not found - October 31, 2011

Find the SID for a dbms_job dbms_scheduler job - October 30, 2011

dba_lobs tips - October 30, 2011

dbms_lob.getlength - October 30, 2011

Oracle Network Adapter could not establish the connection tips - October 29, 2011

Dynamic query for column min and max values - October 29, 2011

******

Copying Oracle datafiles between Linux and Windows servers - October 29, 2011

Oracle adding dates - October 29, 2011

Oracle storage parameter exceptions - October 29, 2011

Estimate Size of Last RMAN Backup - October 27, 2011