Adding a Datafile to Tablespace

When monitoring Tablespace Usage (see my Tablespace Usage blog post for more info), there comes a point when you need to add a datafile to a tablespace to allow for growth and more importantly get below a monitoring threshold for example in OEM or OpsView.

Query to see Current Datafiles State

To see the current state of the datafiles:

set pages 999
set lines 400
col FILE_NAME format a75
select d.TABLESPACE_NAME, d.FILE_NAME, d. (more...)

Querying Tablespace Usage

Tablespace management in an Oracle database is important and something a DBA will do quite frequently. ¬†Therefore I wrote a query, which I believe I originally got from the internet and then it evolved by me adding in temp tablespace and few other things ūüôā

Query for Tablespace Usage

Query to obtain Tablespace Usage:

set pages 999
set lines 400
SELECT df.tablespace_name tablespace_name,
 max(df.autoextensible) auto_ext,
 round(df.maxbytes / (1024 * 1024), 2) max_ts_size,
 round((df. (more...)

Assess Performance using Calibrate on Exadata

For those who are fortunate to have an Oracle Exadata Database Machine, may wonder if their Exadata meets the IOPS/MBPS as per the technical specifications. ¬†Well with the command CALIBRATE in CellCLI, you can run raw performance tests on the cell’s hard disks and flash drives, enabling you to verify the disk/drive performance:

[root@v1ex1celadm01 ~]# cellcli
CellCLI: Release 12.1.2.3.4 - Production on Tue Jun 13 19:02:05 IST 2017

Copyright  (more...)

How to easily delete files in the Oracle Cloud using CloudBerry Explorer

So you have some Oracle Cloud storage, which was probably throw in as a freebie initially by Oracle 🙂 ¬†Now your freebie is expiring and you decide you want to retain the service but now as metered, so you want to delete all the unnecessary files, which in my case are old Oracle database backups.

As you can see here I have 50k plus files using 897Gb:

Oracle Cloud Web Console Details

Here are the files listed in the Web Console:

Oracle Cloud Web Console List Objects

(more...)

All Flash Arrays: Scale Up vs Scale Out (Part 1)

Imagine you want to buy some more storage for your laptop – let’s say an external USB drive for backups. What are the fundamental questions you need to ask before you get down to the thorny issue of price? Typically, there is only one key question:

  • How much capacity do I need?

Of course there will be lesser questions, such as connectivity, brand, colour, weight, what it actually looks like and so on. But those (more...)

The Flash Insider: To POC or Not To POC?

Proof of Concept?

Guest Post

I’m excited announce¬†another guest blog written by my good friend and funny-talking American cousin Nathan Fuzi. Like me, Nate comes from a database background but joined the all-flash storage revolution back in its infancy. Which means, like me, Nate how has a little tombstone on his r√©sum√© marked Violin Memory. But¬†even though he has since¬†moved up¬†to working in THE CLOUD, Nate’s¬†experience working for an AFA vendor is invaluable. Over six years, he worked (more...)

All Flash Arrays: Active/Active versus Active/Passive

running

I want you to imagine that you are about to run a race. You have your trainers on, your pre-race warm up is complete and you are at the start line. You look to your right… and see the¬†guy next to you, the one with the bright orange trainers, is hopping up and down on one leg. He does have two legs –¬†the other one is¬†held up in the air – he’s just choosing to (more...)

All Flash Arrays: Controllers Are The New Bottleneck

bottleneck

Today’s¬†storage array market contains a¬†wild variation of products: block storage, file storage or¬†object storage; direct attached, SANs or NAS systems; fibre-channel, iSCSI or Infiniband… Even the SAN section of the market is full of diversity:¬†from legacy hard disk drive-based arrays through the transitory step of tiered disk+flash hybrid systems and on¬†to modern All-Flash Arrays¬†(AFAs).

If you were partial to the odd terrible pun, you might even say that it was a bewildering array of (more...)

New Installation Cookbook: Oracle Linux 6.7 with Oracle 11.2.0.4 RAC

cookbookI’ve updated my install cookbooks page to include a new¬†cookbook for installation of¬†Oracle 11.2.0.4 Real Application Clusters on Oracle Linux 6.7.

This is also the first one I’ve published since I left the employment of Violin Memory to work for Kaminario, so this install uses a¬†Kaminario K2 All Flash Array. However, it applies very well to any Oracle RAC installation which uses relatively capable¬†storage.

Enjoy:

https://flashdba.com/install-cookbooks/oracle-linux-6-7-with-oracle-11-2-0-4-rac/


Filed (more...)

How the Next Generation of Flash Storage is Changing the Economics Of SaaS Businesses (Recorded Webinar)

SaaS Webinar

This week I had the opportunity to record a webinar on a subject very close to my heart, the Software-as-a-Service industry. From 2003 to 2007 I managed the production infrastructure¬†for a global¬†SaaS company through the transition from startup to acquisition (partly by Salesforce.com). At the time, SaaS was a relatively new phenomenon, predating any concept of “Cloud”, but the challenges we faced then are still very relevant today.

The company was run by charismatic (more...)

Understanding Flash: The Fall and Rise of Flash Memory

grave

This month sees the four year anniversary of some interesting events. Commonwealth countries around the world celebrated the Diamond Jubilee of Queen Elizabeth II. Whitney Houston was tragically found dead in a Beverly Hills hotel. The Caribbean was hit hard by sargassum seaweed invasion. And I made the decision to leave the comfort of Oracle databases and join the exciting new All-Flash Array industry.

Ok,¬†I might have been stretching the use of the word “interesting” there. But for those with (more...)

Understanding Flash: What is 3D NAND?

grid-cube-3d

About 18 months ago I wrote a post¬†describing the¬†different types of NAND flash known as SLC, MLC and TLC. However, 18 months is a lifetime in the world of technology so now I need to clarify it based on the widespread adoption of a new type of NAND flash. Let me explain…

Recap: 2D Planar NAND

Until recently, most of the flash memory used for data storage was of a form known as 2D Planar NAND (more...)

All Flash Arrays: Hybrid Means Compromise

hybrid-car-engine

Sometimes the transition between two technologies is long and complicated. It may be that the original technology is so well established that it’s entrenched in people’s minds as simply “the way things are” – inertia, you might say. It could be that there is more than one form of the new technology to choose from, with smart customers¬†holding back to¬†wait and¬†see which emerges as a stronger contender for their¬†investment. Or it could just be (more...)

Postcards from Storageland: Pure Storage Cancels Christmas

christmas-angel

Ho ho ho folks. It’s nearly Christmas Day, 2016 and it most definitely is the season to be jolly. It’s also¬†an exciting time in the All Flash Array industry with¬†NetApp announcing its intended acquisition of Solidfire for a reported $870 million. Merry Christmas to everyone at¬†Solidfire!

Unfortunately those sentiments weren’t shared by Pure Storage’s VP of Product, Matt Kixmoeller, who published a blog on the subject of the acquisition which¬†seemed a little on (more...)

SYNC 2014 !

Vanuit Proact organiseren wij het kennisplatform SYNC 2014 op 17 september in de Rotterdam Cruise Terminal. Alle hedendaagse IT-infrastructuurontwikkelingen in 1 dag: ‚ÄĘ Een interactief programma o.l.v. dagvoorzitter Lars S√łrensen o.a. bekend van BNR ‚ÄĘ Een keynote van Marco Gianotten van Giarte, de Nederlandse ‚ÄúGartner‚ÄĚ op het gebied van Outsoucing/Managed Services ‚ÄĘ Huisman Equipment over de

Drill Down the I/O stack at UKOUG Tech13

It’s just under a week to go before the doors open for the UKOUG Tech13 conference and the adjoining OakTable World UK 2013 sessions, so I thought I would write a very short blog post about what I will be doing there, where I’ll be, and what I’m looking forward to. This year I will … Continue reading "Drill Down the I/O stack at UKOUG Tech13"

Death of the Storage Array

When I wrote this article for The Register in October 2010, there was a torrent of naysayers and witch hunters spewing their opinions in the comments section. I don’t have a problem with that, I was only expressing an opinion myself, after all. I don’t actually own a time machine and so any of my … Continue reading "Death of the Storage Array"

Optimal Oracle Configuration for Efficient Table Scanning (Part Three)

And finally, part three!  

Optimal Oracle Configuration for Efficient Table Scanning (Part Two)

Here’s part two!

Optimal Oracle Configuration for Efficient Table Scanning (Part One)

I just got permission from The UK Oracle Users Group to reproduce my article series on optimising scans in Oracle. Part One is available here, Part Two will follow shortly after, and then Part Three will be a few weeks away, following its publication in the magazine. Enjoy!