David Njoku Oracle for Absolute Beginners: Data Types All databases stand on a tripod of datatypes: strings, numbers and dates. And so I’d imagine that by Day 2... 15 February 2017 11 min read
Houri Oracle Partitioned Index Efficiency PartitionedIndexEfficiency Although it is generally true that rebuilding an index represents a waste of time and resources, there nevertheless exist... 09 February 2017 10 min read
Anju Garg Policy-Managed Oracle RAC One Node Databases Oracle RAC One Node, introduced in Oracle Database 11g Release 2 (11.2.0.2), is a single instance of an Oracle RAC-enabled... 09 February 2017 13 min read
Oracle Aman Sharma in Oracle Understanding Oracle SQL Query Parsing: Part 4 – Understanding Bind Variable Peeking Learn all about Oracle SQL bind variables: the potential issues surrounding bind variables and how to handle them.… 03 February 2017 8 min read
David Njoku Oracle for Absolute Beginners: Date, Timestamp and Interval All databases stand on a tripod of datatypes: strings, numbers and dates. And though they might dress them in fancy... 02 February 2017 12 min read
David Njoku Oracle for Absolute Beginners: Other SQL Functions Here’s a simple trick you can play on your friends. Ask them to pick a number from 1 to 10,... 30 January 2017 8 min read
Anju Garg Duplicate Point-In-Time Recovered PDB Using Backup At times, we might need to duplicate a production pluggable database to a Past Point in Time without disturbing the production... 25 January 2017 9 min read
Jonathan Lewis Snapshots While looking at the results from a query against the dynamic performance view v$active_session_history during a recent trouble-shooting assignment I... 24 January 2017 11 min read
Jonathan Lewis Index Costing Threat In the previous post I described a problem with the strategy that the optimizer uses for costing an index fast... 24 January 2017 9 min read
Oracle Aman Sharma in Oracle Understanding Oracle SQL Query Parsing – Part 3: Bind Variables and Cursor Sharing In this third article, we will look at the issue of duplicate SQL statements and how Bind Variables can help... 20 January 2017 9 min read
Jonathan Lewis Problems with Indexes In my book “Cost Based Oracle – Fundamentals” (Apress 2005) I described a problem with the cost calculation for the... 20 January 2017 7 min read
Houri Oracle Data Type Implicit Conversion Hierarchy In Oracle, under certain circumstances, an implicit data type conversion precludes the use of indexes. Perhaps you have a vague... 09 January 2017 10 min read
Jonathan Lewis Investigating Indexes – 2 In an earlier article on investigating indexes I described some methods for looking at the internal structure of an index... 09 January 2017 16 min read
Zafar Ali Invisible Columns In Oracle Database 12C In Oracle Database 12c, you can set a column in table as invisible either during CREATE TABLE or modifying existing... 12 December 2016 5 min read
Oracle Aman Sharma in Oracle Oracle Parent and Child Cursors: The Library Cache Sharing Model, Soft Parse Deep Dive, and Cursor Version Count Diagnostics Oracle parent and child cursors explained - how the library cache shares SQL execution plans across identical statements while maintaining... 12 December 2016 11 min read
Anju Garg Re-registering Databases In A Cluster With srvctl: Problems and Solutions Recently I wanted to create a policy managed database in my 12.1.0.2 flex cluster setup, but free servers are not... 30 November 2016 8 min read
David Njoku JSON For Absolute Beginners: Part 5 – Generating JSON in Oracle In this fifth article in our series on JSON and the Oracle database we’ll be pulling the curtains back on... 11 October 2016 7 min read
Jonathan Lewis Hacking Indexes Indexes are expensive to maintain so we want to get the greatest benefit we can from them and make sure... 03 October 2016 14 min read
David Njoku JSON For Absolute Beginners: Part 4 – Retrieving JSON in Oracle There’s a possibility you’ve parachuted into this series on JSON and Oracle at this point. If you are already familiar... 03 October 2016 11 min read
Anju Garg Migrate Oracle Database To ASM Using ASMCMD Introduction Oracle Database 10g Release 1 introduced Automatic Storage Management (ASM), a new framework for managing Oracle database files. ASM... 29 September 2016 9 min read
