January 2, 2021 (Last Update Date)
Lost blog articles are an unfortunate side-effect of the blog environment. Below are quick reference links to older blog articles found on this site.
Analytic Functions
- Analysis Challenges
- CPU Wait? LAG to the Rescue
- Create an Auto-Scaling HTML Chart using Only SQL
- Everything or Nothing in SQL
- Excel – Charting the Results of Oracle Analytic Functions
- Graphical Work Center Utilization – Creating the Demo Data and Active Server Page
- Matching the Expected Output – Analytic RANK, ROW_NUMBER, DENSE_RANK, or Something Different?
- On the Topic of Programming 3
- Row Values to Comma Separated Lists, an Overly Complicated Use Case Example
- SELECT Statement is Fast, INSERT INTO Using the SELECT Statement is Brutally Slow 2
- Simple SQL with and without Inline Views
- SQL – Bad Execution Plan caused by ROWNUM, ROW_NUMBER is Possible Fix
- SQL – Combining Overlapping Date Rows
- SQL – COUNT Analytical Function, GROUP BY, HAVING
- SQL – DENSE_RANK, PERCENT_RANK, and COUNT Analytical Functions
- SQL – Filling in Gaps in the Source Data 2
- SQL Grouping – Generating Comma Separated Lists
- SQL – LISTAGG – Finding Rows with Common Attributes – Roman to Find a Solution in Something New
- SQL – Outer Joins, Inline Views, and DENSE_RANK
- SQL – Methods of Reformatting into Equivalent Forms 6
- SQL – Running Sum, Skipping Weekends
- SQL – RANK, MAX Analytical Functions, DECODE, SIGN
- SQL – ROW_NUMBER Analytical Function, Many to One Join
- SQL – ROW_NUMBER, MOD, Even Distribution
- SQL – ROW_NUMBER – Retrieving Rows from the Midpoint
- Update Rows in Another Table with the Help of Analytic Functions
Bind Variables
- 10046 Extended SQL Trace Interpretation 3
- Explain Plan Lies, Autotrace Lies, TKPROF Lies, What is the Plan?
- From a VBS Script to a 10046 Trace and Back into a VBS Script
- Hard Parses when Using Bind Variables?
- Histograms and Bind Variables, But Why?
- Impact of the TRUNC Function on an Indexed Date Column
- Plan Cardinality Estimates Problem with 11.1.0.7 and 11.2.0.1
- Tracking Performance Problems – Inserting a Hint into SQL in a Compiled Program
- Using Histograms to Fix Bind Peeking Problems?
Book Review
- Book Library – Finding Motivation
- Book Review: Beginning Oracle SQL
- Book Review: Beginning PL/SQL: From Novice to Professional
- Book Review: Cost-Based Oracle Fundamentals
- Book Review: Expert Oracle Database 11g Administration
- Book Review: Expert Oracle Database Architecture: Oracle Database Programming 9i, 10g, and 11g Techniques and Solutions, Second Edition
- Book Review: Mastering Oracle SQL and SQL*Plus
- Book Review: Misc. Oracle Related Books
- Book Review: Oracle Core Essential Internals for DBAs and Developers
- Book Review: Oracle Database 10g RMAN Backup & Recovery
- Book Review: Oracle Database 11g Performance Tuning Recipes
- Book Review: Oracle Database 11g Performance Tuning Recipes (Part 2)
- Book Review: Oracle Database 11gR2 Performance Tuning Cookbook (Part 1)
- Book Review: Oracle Database 11gR2 Performance Tuning Cookbook (Part 2)
- Book Review: Oracle Performance Firefighting (Fourth Printing)
- Book Review: Oracle SQL Recipes: A Problem – Solution Approach
- Book Review: Oracle Tuning: The Definitive Reference Second Edition
- Book Review: Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning
- Book Review: Practical Oracle8i: Building Efficient Databases
- Book Review: Pro Oracle SQL
- Book Review: RMAN Recipes for Oracle Database 11g : A Problem-Solution Approach
- Book Review: Secrets of the Oracle Database
- Book Review: Troubleshooting Oracle Performance
- Book Review: Troubleshooting Oracle Performance (Part 2)
- Book Review: Troubleshooting Oracle Performance, Second Edition
C#
- C# Web-Based Forms with Oracle Database Access
- See Sharp Objects, Run with Sharp Objects, Crash with Sharp Objects – Nothing but .Net, C#, and ODP.NET – 1
- See Sharp Objects, Run with Sharp Objects, Crash with Sharp Objects – Obscure and Incorrect Error Messages in Commercial Products
Deadlock
- Deadlock Experimentations
- Deadlock on Oracle 11g but Not on 10g
- Faulty Quotes 7 – Deadlock Kills Sessions?
- Oracle Enqueue Rules Leading to Deadlock Changes Again in 12.1?
Enqueue
- Deadlock on Oracle 11g but Not on 10g
- Enqueue Experimentations
- Lock Watching – What is Wrong with this SQL Statement?
- Oracle Enqueue Rules Leading to Deadlock Changes Again in 12.1?
Excel
- Automated DBMS_XPLAN, Trace, and Send to Excel
- Excel – Charting the Results of Oracle Analytic Functions
- Excel – Graphical Scheduled Usage Viewer for Production Equipment
- Excel – Scrolling Oracle Performance Charts
- Excel – Session Viewer with Query Capability
- Excel – The Graphical Master of Oracle Foreign Keys
- Excel – UserForms with Database Access, Called from VBS
- Extract 1834 Images from Excel 2007 and Transfer to a Database Table
- Extract the First 4400 Images from Excel 2003 (and Above) and Transfer to a Database Table
- MS Query Teases You – Excel will Not Display Text Contained in Long Raw/Blob Column
- Oracle Database Time Model Viewer in Excel 1
- Oracle Database Time Model Viewer in Excel 2
- Oracle Database Time Model Viewer in Excel 3
- Oracle Database Time Model Viewer in Excel 4
- Oracle Database Time Model Viewer in Excel 5
- Oracle Database Time Model Viewer in Excel 6
- Print Oracle Data to a Barcode Label with a Zebra Printer using VBS and Excel
- Retrieve Data to Excel with a Macro using ADO
- Retrieving the Hidden Oracle Parameters and Saving the Parameter Values in Excel
- Select From or Update a Database Table Based on the Contents of an Excel Spreadsheet
- Send an Email From Excel, Visual Basic 6, or a Windows Command Line Using Oracle’s UTL_MAIL Package
- Transfer a Text File into an Oracle Database using an Excel Macro
- Watching Consistent Gets – 10200 Trace File Parser
Faulty Quotes
- Faulty Quotes 1 – OPTIMIZER_INDEX_COST_ADJ
- Faulty Quotes 2 – Test Cases
- Faulty Quotes 3 – Contradictory Information
- Faulty Quotes 4 – Buffer Cache Hit Ratio (BCHR)
- Faulty Quotes 5 – Block Sizes
- Faulty Quotes 6 – CPU Utilization
- Faulty Quotes 7 – Deadlock Kills Sessions?
- Proving that 1=2, is Oracle Wrong to Short-Circuit an Execution Plan?
- True or False – Autotrace
- True or False – Buffer Busy Waits
- True or False – Data Dump Import and Indexes
- True or False – Direct Path Reads
- True or False – Hash Joins
- True or False – Improving Performance of SQL Statements
- True or False – NVL
- True or False – Optimizer Mode and Tuning Goals
- True or False – Oracle Sorting
- True or False – Undo
- True or False – Wait Events
General Administration
- 11.2.0.1 ODBC Update Problem
- An Interesting ERP Problem in Oracle 11g that is Not a Problem in 10g R2
- A Simple Request or a Performance Nightmare – Painted into a Corner by the ERP System
- Auto-Tuned DB_FILE_MULTIBLOCK_READ_COUNT Parameter
- Battling the Symptoms or Addressing the Root Cause
- Book Library – Finding Motivation
- Brain Teaser: 10046 Extended SQL Trace Shows a FETCH Call with c=306350000, e=299174653, p=0, cr=22298 – How is that Possible?
- Buffer Busy Waits – Reason Codes and Block Classes
- Buffer Cache Hit Ratio, Optimizer Index Cost Adj, Clustering Factor, Performance Testing – How to Break a Test Computer
- Building Oracle Database Test Case Scripts – Is there an Easy Method?
- Connecting to an Oracle Database with Visual Basic 6.0 on Windows 8 64 Bit
- CPU Run Queue – What is Wrong with this Quote?
- Database Writer Parameters – What is Wrong with this Quote?
- DB File Scattered Read Wait Event – What is Wrong with this Quote?
- DBMS_XPLAN Format Parameters
- Demonstration of Oracle “Ignoring” an Index Hint
- Determine the Oracle Client Release Version – Remotely
- Disabling AUTOTRACE Causes “SP2-0575: Use of Oracle SQL feature not in SQL92 Entry Level” on 11.2.0.1
- Duplicates when Querying V$TEMPSEG_USAGE?
- Eliminating 2 Wait Events from the Top 5, How Many Remain?
- Expectations of Oracle Technical Books – The Path to Positive Book Reviews
- Experimenting with Automated Emails
- “Expert Oracle Practices: Oracle Database Administration from the Oak Table” Book
- Extents of an Oracle Database DBA’s Knowledge Base
- Failed Logon Attempts
- Finding a New Home for a Client on Windows
- Having Fun with ORA-00600 (qkebCreateConstantOpn1) – What is the Cause of this Error?
- How Do You Find Information in the Oracle Documentation Library?
- How Many Topics can be Packed into a Short OTN Thread?
- How Much Space is Required to Store a Whole Lot of Nothing?
- How to Determine which First Rows OPTIMIZER_MODE was Specified
- How to Eliminate Wait Events in Oracle Database?
- Hyper-Extended Oracle Performance Monitor 7.0 Beta
- If I Need to Fetch My Rows Faster, Is There Any Way?
- Insert Error on Oracle 11g but Not on 10g
- Install Nagios on a Synology DiskStation DS1813+ or DS412+
- Install the Oracle Client on a Synology DiskStation DS1813+ or DS412+ for Nagios to Monitor Databases
- Log File Sync – What is Wrong with this Quote?
- Mining Your Own Business, Is Supplemental Logging Enabled?
- Monitoring Changes to Table Data
- Neat Tricks
- Notes about Various Oracle Parameters
- oci-24550 [3221225477] [Unhandled exception: Code=c0000005 Flags=0
- Open Cursor Leaks – Identifying the Problem
- On the Topic of Programming 1
- On the Topic of Programming 2
- On the Topic of Programming 3
- ORA-1410 Invalid ROWID Mystery
- Oracle DBA, IT Manager, or Something Else
- PGA Memory – The Developer’s Secret Weapon for Stealing All of the Memory in the Server
- PGA Memory – The Developer’s Secret Weapon for Stealing All of the Memory in the Server 2
- Reading Material On Order
- Reading Material On Order 2
- Redo Log Buffer – What is Wrong with this Quote?
- Retrieving the Hidden Oracle Parameters and Saving the Parameter Values in Excel
- Reviewing Session-Level Parameters
- See Sharp Objects, Run with Sharp Objects, Crash with Sharp Objects – Nothing but .Net, C#, and ODP.NET – 1
- See Sharp Objects, Run with Sharp Objects, Crash with Sharp Objects – Obscure and Incorrect Error Messages in Commercial Products
- Select Statement Causing an ORA-00001?
- SESSION_CACHED_CURSORS – Possibly Interesting Details
- SESSIONS Derived Value Formula – Doc Bug Explains
- Simplified Logical and Physical Data Organization
- Single Sign-On Security Issue in 11.2.0.2 Patchset
- _SMALL_TABLE_THRESHOLD Parameter and Buffer Cache – What is Wrong with this Quote?
- SQL Challenge – Submit Update Statements, Updated Values are Reversed on Successful Commit
- SQL Injection – Getting a Date with Bobby Tables
- SQL_TYPE_MISMATCH in V$SQL_SHARED_CURSOR
- System/Kernel Mode CPU Usage – What is Wrong with this Quote?
- Tables and Their Indexes Should be Located on Different Disks – What is Wrong with this Quote?
- The Transforming Face of the Oracle Support Site
- Tracing Enabled for Sessions After Instance Restart
- True or False – Autotrace
- True or False – Buffer Busy Waits
- True or False – Data Dump Import and Indexes
- True or False – Direct Path Reads
- True or False – Hash Joins
- True or False – Improving Performance of SQL Statements
- True or False – NVL
- True or False – Optimizer Mode and Tuning Goals
- True or False – Oracle Sorting
- True or False – Undo
- True or False – Wait Events
- True or False – Why Isn’t My Index Getting Used?
- Undo Quiz – Bringing the Right Tools for the Job
- Undo Segments – What is Wrong with this Quote?
- Unique Index Result Error with Ref Cursor on Oracle 11g but Not on 10g
- V$FILESTAT is Wrong?
- V$SESSION’s ROW_WAIT_OBJ# Column Shows the DATA_OBJECT_ID – Verify the Documentation Challenge
- Value of Improving One’s Knowledge
- Wait Classes – How Do You Use Them to Find the Root Cause?
- What Could Go Wrong? Testing the DB_FILE_MULTIBLOCK_READ_COUNT Parameter
- What does it Mean when a Select Statement in Oracle is using 100% CPU?
- Where Are My Views?
- Why Doesn’t this Trigger Code Work?
- Why Doesn’t This Trigger Work – No Developer Tools Allowed in the Database
- Windows as an OS Platform for Oracle Database – Where Do I Start?
General Technology
- Adding Features to PowerPoint Based Oracle Presentation Files
- A Year Older, Any Wiser?
- Install Nagios on a Synology DiskStation DS415+ (Plex Support Also Added)
- Internal Server Error – Contact Your System Administrator
- On the Topic of Technology…
- On the Topic of Technology… 2
- On the Topic of Technology… 3
- On the Topic of Technology… 4
- On the Topic of Technology… 5
- On the Topic of Technology… 6
- On the Topic of Technology… 7
- On the Topic of Technology… 8 – First 48 hours with Windows 10
- Review of Synology DS415+, How to Add Memory to the DS415+, Web Pages Not Databases
- Unexpected Timer Resolution, Unexpected Parked CPUs, Unexpected Power Consumption
- Web Pages Not Databases – Part 2: Fail2ban, Apache, IP Addresses, Linux, SELinux
Histogram
- DATE Datatype Or NUMBER Datatype – Which Should be Used?
- Histograms and Bind Variables, But Why?
- Histograms – What is Wrong with this Quote?
- Plan Cardinality Estimates Problem with 11.1.0.7 and 11.2.0.1
- Using Histograms to Fix Bind Peeking Problems?
HTML
- Create an Auto-Scaling HTML Chart using Only SQL
- Database Inpector Gadget
- Graphical Work Center Utilization – Creating the Demo Data and Active Server Page
- Oracle Logging Trigger Creator
- Oracle Statistics Chart Viewer
- Output Employee Attendance Calendar to Web with VBS
- Submit Input to an ASP Web Page and Retrieve the Result using VBS
- The SQL to the Orbiting Ball
- Use VBS to Search for Oracle Books using Google’s Book Library
- Working with Oracle’s Time Model Data 2
- Working with Oracle’s Time Model Data 3
Linux
- Install Nagios on a Synology DiskStation DS1813+ or DS412+
- Install Nagios on a Synology DiskStation DS415+ (Plex Support Also Added)
- Install the Oracle Client on a Synology DiskStation DS1813+ or DS412+ for Nagios to Monitor Databases
- Web Pages Not Databases – Part 2: Fail2ban, Apache, IP Addresses, Linux, SELinux
Network Monitoring
- Favorite Free Applications to Troubleshoot Visual Manufacturing and Windows – Part 10 Wireshark
- Network Monitoring Experimentations 1
- Network Monitoring Experimentations 2
- Network Monitoring Experimentations 3
- Network Monitoring Experimentations 4
- Network Monitoring Experimentations 5
- Network Monitoring Experimentations 6
- Network Monitoring Experimentations 7
Performance
- 10046 Extended SQL Trace Interpretation
- 10046 Extended SQL Trace Interpretation 2
- 10046 Extended SQL Trace Interpretation 3
- 10200 Trace Shows Consistent Reads, but Not All Consistent Reads
- 11.2.0.1 Statspack Report Contents
- A Simple Request or a Performance Nightmare – Painted into a Corner by the ERP System
- Adding Comments to SQL Statements Improves Performance?
- Automated DBMS_XPLAN, Trace, and Send to Excel
- Brain Teaser: 10046 Extended SQL Trace Shows “EXEC #435118472:c=15600,e=510″, How is that Possible?
- Buffer Cache Hit Ratio, Optimizer Index Cost Adj, Clustering Factor, Performance Testing – How to Break a Test Computer
- Column Order in a Table – Does it Matter? 1
- Column Order in a Table – Does it Matter? 2
- Consistent Gets During a Hard Parse – a Test Case to See One Possible Cause
- Consistently Inconsistent Consistent Gets
- CPU Usage Monitoring – What are the Statistics and when are the Statistics Updated?
- Database using ASSM Tablespace Exhibits Slow Insert Performance After an Uncommitted Delete
- Defy Logic – the Cost-Based Optimizer does Not Select the Lowest Cost Plan – Implicit Data Type Conversion
- Determining Why a Query Using MIN(column) in the WHERE Clause on an Indexed Column takes a Long Time
- Different Execution Plans when Converting SQL from SELECT to UPDATE … IN SELECT, ROWNUM Related Bug in 11.2.0.2
- Different Performance from Standard Edition and Enterprise Edition? 1
- Different Performance from Standard Edition and Enterprise Edition? 2
- Different Performance from Standard Edition and Enterprise Edition? 3
- Different Performance from Standard Edition and Enterprise Edition? 4
- Drilling into Session Detail from the Operating System – On the Windows Platform
- Drilling into Session Detail from the Operating System – On the Windows Platform 2
- Dumping Trace Events – What You See is Not Necessarily What You Get
- Dynamic Sampling Changes
- Excel – Scrolling Oracle Performance Charts
- Explain Plan Shows a Cartesian Merge Join, How Would You Help?
- Execution Plan Changes when the OPTIMIZER_FEATURES_ENABLED Parameter is Changed, But Why?
- Execution Plans – What is the Plan, and Where Do I Find It?
- Execution Plans – What is the Plan, and Where Do I Find It 2
- Execution Plans – What is the Plan, and Where Do I Find It 3
- Explain Plan – Which Plan is Better
- Extended SQL Trace – the Case of the Missing 40,000 Seconds
- Faulty Quotes 1 – OPTIMIZER_INDEX_COST_ADJ
- Faulty Quotes 6 – CPU Utilization
- First Table is 550MB, Second Table is 26GB – Nested Loops or Full Table Scan?
- First Table is 550MB, Second Table is 26GB – Nested Loops or Full Table Scan? 2
- First Table is 550MB, Second Table is 26GB – Nested Loops or Full Table Scan? 3
- First Table is 550MB, Second Table is 26GB – Nested Loops or Full Table Scan? 4
- FIRST_ROWS_n Optimizer Mode – What is Wrong with this Statement?
- Follow that Index
- From a VBS Script to a 10046 Trace and Back into a VBS Script
- Full Table Scan when Selecting Null Values
- Give Me a Hint – How were These Autotrace Execution Statistics Achieved?
- Hard Parses when Using Bind Variables?
- High Value for MBRC Causes High BCHR, High CPU Usage, and Slow Performance
- How to Collect Statistics
- Hyper-Extended Oracle Performance Monitor 6.0 Beta
- Idle Thoughts – SSD, Redo Logs, and Sector Size
- Impact of the TRUNC Function on an Indexed Date Column
- Improving Performance by Using a Cartesian Join 2
- Invalid Hints are Silently Ignored? An Invalid USE_HASH Hint Transforms a Sort-Merge Join into a Nested Loops Join
- Large Page Support or Not – ORA_LPENABLE, Granule Size
- Miscellaneous Metalink Performance Articles
- Miscellaneous Metalink Performance Articles 2
- Oracle Database Time Model Viewer in Excel 1
- Oracle Database Time Model Viewer in Excel 2
- Oracle Database Time Model Viewer in Excel 3
- Oracle Database Time Model Viewer in Excel 4
- Oracle Database Time Model Viewer in Excel 5
- Oracle Database Time Model Viewer in Excel 6
- Oracle Statistics Chart Viewer
- Parallel Execution Challenge – It’s About Time
- Parallel Parking – What is causing the Query to be Executed in Parallel?
- Parallel Reasoning
- Parent-Child Relationships and the Questions Left Unanswered by TKPROF, Re-Learning Something Old
- Physical Reads are Very Fast, Why is this SQL Statement Slow
- Plan Cardinality Estimates Problem with 11.1.0.7 and 11.2.0.1
- Possibly Interesting Execution Plan
- Query Executes in Seconds with the RULE Hint and Several Minutes Otherwise – What Would You Do?
- Query Performance Problem, or is Something Else Happening?
- Query Requires More Time to Execute from an Instant Client Connection
- Ramming Two SQL Statements Together – To Scalar or Too Scalar
- Row Values to Comma Separated Lists, an Overly Complicated Use Case Example
- SELECT Statement is Fast, INSERT INTO Using the SELECT Statement is Brutally Slow 1
- SELECT Statement is Fast, INSERT INTO Using the SELECT Statement is Brutally Slow 2
- SELECT Statement is Fast, INSERT INTO Using the SELECT Statement is Brutally Slow 3
- Simple Query Generates Complex Execution Plan, the Mysterious 4063.88 Second Single Block Read Wait
- Slow Query with an Interesting Execution Plan
- Something is Bugging Me: V$SESSION and 10046 Trace Files Show OBJECT_ID or DATA_OBJECT_ID?
- SORT_AREA_SIZE Affecting Sorts to Disk with PGA_AGGREGATE_TARGET Set?
- SORT_AREA_SIZE Affecting Sorts to Disk with PGA_AGGREGATE_TARGET Set 2?
- SQL – Bad Execution Plan caused by ROWNUM, ROW_NUMBER is Possible Fix
- SQL – Programmatic Row By Row to MERGE INTO
- SQL – Reformatting to Improve Performance 1
- SQL – Reformatting to Improve Performance 2
- SQL – Reformatting to Improve Performance 3
- SQL – Reformatting to Improve Performance 4
- SQL – Reformatting to Improve Performance 5
- SQL – Reformatting to Improve Performance 6
- SQL – Reformatting to Improve Performance 7
- SQL – Reformatting to Improve Performance 8
- SQL – Reformatting to Improve Performance 9
- SQL – Reformatting to Improve Performance 10
- SQL – Reformatting to Improve Performance 11
- SQL Performance Problem, AWR Reports Query is #1 in Elapsed Time, #2 in CPU Time – How Would You Help?
- SQL PLAN_HASH_VALUE Changes for the Same SQL Statement
- SQL PLAN_HASH_VALUE Change When Literals Change?
- Statspack/AWR Report Resources
- Taking a Hint, For What it is Worth
- Test Case Showing Oracle Database 11.2.0.1 Completely Ignoring an Index Even when Hinted
- The Effects of Potential NULL Values in Row Sources During Updates Using an IN Subquery
- Thoughts on a Hyper-Extended Oracle Performance Monitor Beta
- TKPROF Elapsed Time Challenge – the Elapsed Time is Half of the Wait Event Time
- TKPROF in 11.2.0.2 Unexpected Improvement – Rows (1st), Rows (avg), and Rows (max)
- To N or Not to N, is SYS_OP_C2C the Question; Oracle NVARCHAR Slow?
- Toy Project for Performance Tuning
- Toy Project for Performance Tuning 2
- Tracking Performance Problems – Inserting a Hint into SQL in a Compiled Program
- Transitive Closure Causing an Execution Plan Short-Circuit
- V$FILESTAT is Wrong?
- V$SESSION_LONGOPS – Where’s My SQL Statement
- Wait Classes – How Do You Use Them to Find the Root Cause?
- What Happens when 1=2 is Included in a WHERE Clause?
- What is the Impact on the CPU Statistic in a 10046 Trace File in a CPU Constrained Server?
- What to Do When Performance Problems Appear
- Which is Most Efficient when Deleting Rows: EXISTS, IN, or a VIEW
- Which is Most Efficient when Selecting Rows: EXISTS, IN, or a JOIN
- Which PLAN_HASH_VALUE Appears in V$SQLAREA?
- Why is a Full Table Scan Selected – Will the Execution Plan Provide a Clue?
- Why Isn’t My Index Used… When USER2 Executes this Query?
- Will Enabling a 10046 Trace Make My Query Slower (or Faster)?
- Working with Oracle’s Time Model Data
- Working with Oracle’s Time Model Data 2
- Working with Oracle’s Time Model Data 3
Quiz – Whose Answer is it, Anyway?
- 10046 Extended SQL Tracing for a Session – What is Wrong with this Quote?
- Addressing TM Enqueue Contention – What is Wrong with this Quote?
- Analytic Functions – What is Wrong with this Statement?
- CPU Run Queue – What is Wrong with this Quote?
- Database Writer Parameters – What is Wrong with this Quote?
- DB_BLOCK_SIZE and DB_FILE_MULTIBLOCK_READ_COUNT – What is Wrong with this Quote?
- DB_BLOCK_SIZE and DB_FILE_MULTIBLOCK_READ_COUNT 2 – What is Wrong with this Quote?
- DB_BLOCK_SIZE and DB_FILE_MULTIBLOCK_READ_COUNT 3 – What is Wrong with this Quote?
- DB_BLOCK_SIZE and DB_FILE_MULTIBLOCK_READ_COUNT 4 – What is Wrong with this Quote?
- DB File Scattered Read Wait Event – What is Wrong with this Quote?
- Directly Executing a Query is Slower than Returning a REFCURSOR from a PL/SQL Procedure – What is Wrong with this Quote?
- Down for the Count – Multiple Choice Quiz
- Find Objects with the Greatest Wait Time – What is Wrong with this Quote?
- Full Table Scans and the Buffer Cache in 11.2 – What is Wrong with this Quote?
- Hash Joins – What is Wrong with this Statement?
- Histograms – What is Wrong with this Quote?
- I Didn’t Know That 1 – What is Wrong with this Quote?
- I Didn’t Know That 2 – What is Wrong with this Quote?
- I Didn’t Know That 3 – What is Wrong with this Quote?
- I Didn’t Know That 4 – What is Wrong with this Quote?
- I Didn’t Know That 5 – What is Wrong with this Quote?
- I Didn’t Know That 6 – What is Wrong with this Quote?
- Inline Views – What is Wrong with this Quote?
- Insert Error on Oracle 11g but Not on 10g
- Interesting Index “Facts” – What is Wrong with these Quotes?
- KEEP Pool – What is Wrong with this Quote?
- Log File Sync – What is Wrong with this Quote?
- NOLOGGING Option and log file sync Waits – What is Wrong with this Quote?
- Optimizer Costing 1 – What is Wrong with this Quote?
- Optimizer Costing 2 – What is Wrong with this Quote?
- Optimizer Costing 3 – What is Wrong with this Quote?
- Optimizer Costing 4 – What is Wrong with this Quote?
- Parse CPU to Parse Elapsd – What is Wrong with this Quote?
- PGA Memory and PGA_AGGREGATE_TARGET, is there Something Wrong with this Quote?
- Prepared Quizzes, How Would You Answer that Question? 1
- Prepared Quizzes, How Would You Answer that Question? 2
- Prepared Quizzes, How Would You Answer that Question? 3
- Redo Log Buffer – What is Wrong with this Quote?
- Repeat After Me: NULL Values are Not Stored in Indexes?
- Row Lock is Synonymous with TX Lock, and is a Lock on a Single Row of a Table – Verify the Documentation Challenge
- _SMALL_TABLE_THRESHOLD Parameter and Buffer Cache – What is Wrong with this Quote?
- Stored Outlines (Plan Stability) are an Enterprise Edition Feature? A Self-Conflicting Story
- System/Kernel Mode CPU Usage – What is Wrong with this Quote?
- Tables and Their Indexes Should be Located on Different Disks – What is Wrong with this Quote?
- Temporary Tablespace Storage Parameters – What is Wrong with this Quote?
- The CURSOR_SHARING Parameter is a Silver Bullet – What is Wrong with this Quote?
- True or False – Autotrace
- True or False – Buffer Busy Waits
- True or False – Data Dump Import and Indexes
- True or False – Direct Path Reads
- True or False – Hash Joins
- True or False – Improving Performance of SQL Statements
- True or False – NVL
- True or False – Optimizer Mode and Tuning Goals
- True or False – Oracle Sorting
- True or False – Undo
- True or False – Wait Events
- True or False – Why Isn’t My Index Getting Used?
- Undo Segments – What is Wrong with this Quote?
- Unindexed Foreign Keys – What is Wrong with this Quote?
- Using TKPROF for Analyzing 10046 Extended SQL Trace Files – What is Wrong with this Quote?
- V$SESSION’s ROW_WAIT_OBJ# Column Shows the DATA_OBJECT_ID – Verify the Documentation Challenge
- Wait Events 1 – What is Wrong with this Quote?
- Wait Events 2 – What is Wrong with this Quote?
- Wait Events 3 – What is Wrong with this Quote?
- Waiting for a Long Time – What is Going On?
SQL
- Adding Comments to SQL Statements Improves Performance?
- An Invalid, or Do You Just Not Want to Work
- Analysis Challenges
- Analytic Functions – What is Wrong with this Statement?
- ANSI Full Outer Join, Ready or Not?
- BIN$ Index Found in the Execution Plan – Digging through the Recycle Bin
- Bitten by a Virtual Column, _OPTIMIZER_IGNORE_HINTS Doesn’t Ignore Hints?
- Brain Teaser: Why is this Query Performing a Full Table Scan
- Calculate the Distance Between Two Latitude/Longitude Points using Plain SQL
- Calculating Overlapping Hours for Labor Transactions
- COLLECTION ITERATOR (PICKLER FETCH) Appearing in DBMS_XPLAN Output
- Column Order in a Table – Does it Matter? 1
- Column Order in a Table – Does it Matter? 2
- Concatenate Text Stored in Byte Arrays within BLOB Type Columns
- Consistent Gets During a Hard Parse – a Test Case to See One Possible Cause
- CPU Wait? LAG to the Rescue
- Create an Auto-Scaling HTML Chart using Only SQL
- Database Inpector Gadget
- DATE Datatype Or NUMBER Datatype – Which Should be Used?
- Date Delta SQL – What is Wrong with this SQL Statement?
- Defy Logic – the Cost-Based Optimizer does Not Select the Lowest Cost Plan – Implicit Data Type Conversion
- Determining Why a Query Using MIN(column) in the WHERE Clause on an Indexed Column takes a Long Time
- Down for the Count – Multiple Choice Quiz
- Eliminate Rows Having a Letter and Number Combination
- Everything or Nothing in SQL
- Explain Plan Lies, Autotrace Lies, TKPROF Lies, What is the Plan?
- Feeling ANSI About Oracle Join Syntax?
- Feeling ANSI About Oracle Join Syntax? 2
- Finding the Next Primary Key Value, a Pre-fixed Solution
- Finding the Right Index for this SQL Statement
- Finding Rows with Common Attributes – Roman to Find a Solution in Something New
- Free ANSI SQL to Oracle Specific SQL Translator and SQL Tutor
- Full Table Scan when Selecting Null Values
- Graphical Work Center Utilization – Creating the Demo Data and Active Server Page
- Grouping Data Sets by Week Number of the Month
- Hash Joins – What is Wrong with this Statement?
- How Many Ways to Solve this Problem? Add the Sequential Numbers x Through y
- How Many Ways to Solve this Problem? Generate a Calendar that Displays Average Hours Per Day
- How Many Ways to Solve this SQL Problem?
- I ORDERED a Hint – Why Won’t You Listen to Me?
- Impact of the TRUNC Function on an Indexed Date Column
- Improving Performance by Using a Cartesian Join
- Improving Performance by Using a Cartesian Join 2
- Inner and Outer Join Examples
- Lock Watching – What is Wrong with this SQL Statement?
- Measuring Numbers – Is this a Valid Comparison?
- Monitoring Changes to Table Data
- Name that Table’s Column
- Nested Loops Join – the Smaller Table is the Driving Table, the Larger Table is the Driving Table
- NO_QUERY_TRANSFORMATION Hint is Ignored… Well, Almost Ignored
- Non-Specific Index Hints
- On the Topic of Programming 1
- On the Topic of Programming 2
- On the Topic of Programming 3
- Oracle Query Optimizer Vanishing Acts
- PGA Memory – The Developer’s Secret Weapon for Stealing All of the Memory in the Server
- PGA Memory – The Developer’s Secret Weapon for Stealing All of the Memory in the Server 2
- Query Costs
- Query is Returning ORA-06502: Character String Buffer Too Small, Any Help for the OP?
- Query Performance Problem, or is Something Else Happening?
- Ramming Two SQL Statements Together – To Scalar or Too Scalar
- Reproducing a Canned Report using a Single SQL Statement
- Row Values to Comma Separated Lists, an Overly Complicated Use Case Example
- Select For Update – In What Order are the Rows Locked?
- SELECT Statement is Fast, INSERT INTO Using the SELECT Statement is Brutally Slow 1
- SELECT Statement is Fast, INSERT INTO Using the SELECT Statement is Brutally Slow 2
- SELECT Statement is Fast, INSERT INTO Using the SELECT Statement is Brutally Slow 3
- Sequence Driven Primary Keys – Which is Better: Call NextVal in the Insert Statement or in a Row Level Trigger?
- Simple SQL – Finding the Next Operation
- Simple SQL with and without Inline Views
- Simple SQL with and without Inline Views 2
- SQL – Bad Execution Plan caused by ROWNUM, ROW_NUMBER is Possible Fix
- SQL – Combining Overlapping Date Rows
- SQL – COUNT Analytical Function, GROUP BY, HAVING
- SQL Date Ranges with Connect By
- SQL – DENSE_RANK, PERCENT_RANK, and COUNT Analytical Functions
- SQL – Determining if Resources are in Use in 2 Hour Time Periods
- SQL – Experimenting with Case Insensitive Searches
- SQL – Filling in Gaps in the Source Data
- SQL – Filling in Gaps in the Source Data 2
- SQL Grouping – Generating Comma Separated Lists
- SQL – Methods of Reformatting into Equivalent Forms 1
- SQL – Methods of Reformatting into Equivalent Forms 2
- SQL – Methods of Reformatting into Equivalent Forms 3
- SQL – Methods of Reformatting into Equivalent Forms 4
- SQL – Methods of Reformatting into Equivalent Forms 5
- SQL – Methods of Reformatting into Equivalent Forms 6
- SQL – Outer Joins, Inline Views, and DENSE_RANK
- SQL – Overlapping Transactions, How Many Hours have We Worked?
- SQL – Programmatic Row By Row to MERGE INTO
- SQL Challenge – Submit Update Statements, Updated Values are Reversed on Successful Commit
- SQL Challenges
- SQL Performance Problem, AWR Reports Query is #1 in Elapsed Time, #2 in CPU Time – How Would You Help?
- SQL PLAN_HASH_VALUE Changes for the Same SQL Statement
- SQL PLAN_HASH_VALUE Change When Literals Change?
- SQL Precedence UNION and MINUS, Converting to Full Outer Join Syntax
- SQL – RANK, MAX Analytical Functions, DECODE, SIGN
- SQL – Recursive Summing of Related Entities
- SQL – Reformatting to Improve Performance 1
- SQL – Reformatting to Improve Performance 2
- SQL – Reformatting to Improve Performance 3
- SQL – Reformatting to Improve Performance 4
- SQL – Reformatting to Improve Performance 5
- SQL – Reformatting to Improve Performance 6
- SQL – Reformatting to Improve Performance 7
- SQL – Reformatting to Improve Performance 8
- SQL – Reformatting to Improve Performance 9
- SQL – Reformatting to Improve Performance 10
- SQL – Reformatting to Improve Performance 11
- SQL – Retain Specific Sort Order
- SQL – ROW_NUMBER Analytical Function, Many to One Join
- SQL – ROW_NUMBER, MOD, Even Distribution
- SQL – ROW_NUMBER – Retrieving Rows from the Midpoint
- SQL – Running Sum, Skipping Weekends
- SQL Basics – Working with ERP Data
- Strange Timestamp Behavior
- Taking a Hint, For What it is Worth
- Test Case Showing Oracle Database 11.2.0.1 Completely Ignoring an Index Even when Hinted
- The Effects of Potential NULL Values in Row Sources During Updates Using an IN Subquery
- The FizzBuzz Oracle Database Coding Challenge
- The INSTR Function will Never Use an Index? I will give You a Hint
- The New Order Oracle Coding Challenge 1
- The New Order Oracle Coding Challenge 2
- The New Order Oracle Coding Challenge 3 – Mind Boggle
- The New Order Oracle Coding Challenge 4 – Tic Tac Toe
- The SQL to the Orbiting Ball
- The Unique Result Oracle Database Coding Challenge
- To N or Not to N, is SYS_OP_C2C the Question; Oracle NVARCHAR Slow?
- Tracking Performance Problems – Inserting a Hint into SQL in a Compiled Program
- Transitive Closure Causing an Execution Plan Short-Circuit
- Update Rows in Another Table with the Help of Analytic Functions
- Using ROWNUM in the Where Clause Causes Problems
- Watching Consistent Gets – 10200 Trace File Parser
- What Happens when 1=2 is Included in a WHERE Clause?
- What is the Difference Between the FIRST_ROWS Hint and ROWNUM in the WHERE Clause?
- What is the Meaning of the %CPU Column in an Explain Plan?
- What is the Meaning of the %CPU Column in an Explain Plan? 2
- What Number Immediately Follows 3,999? Oracle Database Refuses to Answer
- What Would Cause a NO_INDEX Hint to Not Work as Expected?
- WHERE MOD(ROWNUM,100) = 0
- Which is Most Efficient when Deleting Rows: EXISTS, IN, or a VIEW
- Which is Most Efficient when Selecting Rows: EXISTS, IN, or a JOIN
- Why Doesn’t this SQL Work?
- Why Isn’t My Index Used… When USER2 Executes this Query?
Uncategorized
- A Year Older, Any Wiser?
- A Year Older, Any Wiser? 2
- Adding Features to PowerPoint Based Oracle Presentation Files
- Book Reviews and DMCA – No Longer Curious, Order Cancelled
- Failure to Collect Fixed Object Statistics Leads to ORA-01013 or ORA-07445
- Internal Server Error – Contact Your System Administrator
- Interviewed for the November 2010 NoCOUG Journal
- Michigan OakTable Symposium (Advert)
- On the Topic of Copyright
- On the Topic of Technology…
- On the Topic of Technology… 2
- On the Topic of Technology… 3
- On the Topic of Technology… 4
- On the Topic of Technology… 5
- On the Topic of Technology… 6
- On the Topic of Technology… 7
- OT: Do Search Terms Describe the Visitor?
- Strange Search Terms – Are the Answers Out There?
- Technical Review of MOTS
- The OakTable Network Invades Michigan, USA (Advert)
- Unexpected Timer Resolution, Unexpected Parked CPUs, Unexpected Power Consumption
VBS
- Automated DBMS_XPLAN, Trace, and Send to Excel
- Connecting to an Oracle Database with Visual Basic 6.0 on Windows 8 64 Bit
- Database Inpector Gadget
- Determine the Oracle Client Release Version – Remotely
- Drilling into Session Detail from the Operating System – On the Windows Platform
- Drilling into Session Detail from the Operating System – On the Windows Platform 2
- Finding the Next Primary Key Value, a Pre-fixed Solution
- From a VBS Script to a 10046 Trace and Back into a VBS Script
- Graphical Work Center Utilization – Creating the Demo Data and Active Server Page
- Improving Performance by Using a Cartesian Join
- Investigating Enqueues Burns CPU Cycles
- MS Query Teases You – Excel will Not Display Text Contained in Long Raw/Blob Column
- Oracle Logging Trigger Creator
- Oracle Statistics Chart Viewer
- Output Employee Attendance Calendar to Web with VBS
- Print Oracle Data to a Barcode Label with a Zebra Printer using VBS and Excel
- Query Active Directory, WMI, and Upload to Database
- Retrieving the Hidden Oracle Parameters and Saving the Parameter Values in Excel
- Send an Email From Excel, Visual Basic 6, or a Windows Command Line Using Oracle’s UTL_MAIL Package
- SESSION_CACHED_CURSORS – Possibly Interesting Details
- Simple VBS Script to Retrieve Data from Oracle
- SQL – Programmatic Row By Row to MERGE INTO
- Submit Input to an ASP Web Page and Retrieve the Result using VBS
- The SQL to the Orbiting Ball
- Use VBS to Search for Oracle Books using Google’s Book Library
- Watching Consistent Gets – 10200 Trace File Parser
- Working with Oracle’s Time Model Data 2
- Working with Oracle’s Time Model Data 3
Charles Hooper's Oracle Notes 
Recent Comments