Back in July 2013, Oracle released the latest version of its flagship database product, Oracle 12c. Among the usual fanfare was information about a number of new options - including one known as Multitenant. With the Multitenant option, databases use a new architecture which features a container database (or CDB) which in turn contains one or more pluggable databases (or PDBs). … Continue reading Deprecation of Non-CDB Architecture in Oracle 12c
Category: Blog
Understanding Flash: Floating Gates and Wear
NAND flash wears out because repeated program and erase operations degrade the oxide layer in floating gate transistors. This article explains how flash cells store data and why wear affects SLC, MLC and TLC differently.
Oracle AWR Reports: When IOStats Lie
If you've been unfortunate enough to follow my dithering on Twitter recently you'll know that I've been lurching between thinking that there is and isn't a problem with Oracle's tracking of I/O statistics in its AWR reports. I'm now convinced there is a problem, but I can't work out what causes it... so step 1 … Continue reading Oracle AWR Reports: When IOStats Lie
New Cookbook: Oracle Linux 6 Update 5 within an Oracle VM Template
I've posted a new installation cookbook for using Oracle within a virtual machine running on Oracle VM. Surprisingly, I was unable to come up with a satisfactory method of accessing external storage that did not involve the use of Oracle ASMLib... Oracle Linux 6 Update 5 within an Oracle VM Template
Understanding Flash: Unpredictable Write Performance
Not all NAND flash writes are equal. MLC flash has fast pages and slow pages, creating unpredictable write latency unless the storage controller manages them intelligently. This article explains why write performance varies and what enterprise arrays do about it.
Oracle AWR Reports: When Averages Lie
I was recently contacted by a customer who runs a busy ERP system on their Oracle database. Their users have been screaming for some time about unpredictable performance, where application screens which would usually open in under a second suddenly take an age. ERP systems are legendary for this, of course, because as each screen … Continue reading Oracle AWR Reports: When Averages Lie
Understanding Flash: The Write Cliff
When flash garbage collection cannot keep pace with incoming writes, performance falls off a cliff. This article explains background versus active garbage collection, write amplification and why predictability matters more than peak speed.
Postcard from Oracle OpenWorld 2014: The Oracle FS1 Flash Array
A couple of weeks ago I wrote a post about my trip to Oracle OpenWorld 2014 and the surprise announcement of the Oracle FS1 Flash Array. I posted it on the Violin Memory corporate website here: http://www.violin-memory.com/blog/postcard-oracle-openworld-2014-the-oracle-fs1-flash-array/ Follow the link to find out whether I thought it was the most amazing product in the history … Continue reading Postcard from Oracle OpenWorld 2014: The Oracle FS1 Flash Array
Understanding Flash: Garbage Collection Matters
NAND flash can only be erased at the block level, not the page level. Garbage collection is the process that recycles stale pages to keep a flash system writable – and without it, performance collapses. This article explains why.
Understanding Flash: The Flash Translation Layer
The flash translation layer is the hidden software layer that makes NAND flash usable as enterprise storage. This article explains logical block mapping, wear levelling, garbage collection and write amplification.
flashdba 