Understanding Flash: The Write Cliff

cliffs

For the last couple of posts in this series I’ve been banging on about the importance of garbage collection (GC) in a flash system. I attempted to show you what happens if you don’t perform any GC at all (clue: you turn your flash device into a slow ROM), but clearly in the real world every flash array or SSD vendor has GC technology built into their flash translation layer. So why am I going (more...)

Blog : Cloud Community France

Intéressé par les solutions Cloud (IaaS & PaaS / Public & Privé) d'Oracle ?
Suivez le blog : https://blogs.oracle.com/Cloud-Community-France/

Postcard from Oracle OpenWorld 2014: The Oracle FS1 Flash Array

OOW14

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 of storage, or simply a rehashed Pillar Axiom hybrid array with some SSDs and a ton of marketing.


(more...)

Understanding Flash: Garbage Collection Matters

garbage-collection

In the last post in this series I discussed some of the various tasks that need to be performed by the flash translation layer – the layer of abstraction that sits between us and the raw NAND flash on which we desire to store our data. One of those tasks is the infamous garbage collection process (or “GC”) – and in these next couple of posts I’m going to look into GC a little deeper.

But (more...)

Understanding Flash: The Flash Translation Layer

electronics

A couple of posts ago in this series, I explained how a NAND flash die is comprised of planes, which contain blocks, which contain pages… which contain individual cells of data. Read operations take place at the page level, as do write operations (although we call them program operations in the flash world). But crucially, erase operations take place at the block level and so affect multiple pages.

Erases are also (more...)

My lucky find for ORA-01720: Grant Option Does Not Exist.

Strangest thing happened the other day during a customer upgrade.  Our automated scripts were in the process of creating a view and I received the error:

ORA-01720: Grant Option Does Not Exist.

OK…..  I get it…  BUT…. I didn’t even execute a GRANT statement!?  I was just executing a CREATE OR REPLACE VIEW…. what gives?

Doing some searching online, I didn’t find too much that fit my issue.  Everyone was getting (more...)

Oracle, Parallelism and Direct Path Reads… on Flash

3000-open-case

Guest Post

This is another guest post from my buddy Nate Fuzi, who performs the same role as me for Violin but is based in the US instead of EMEA. Because he’s an American, Nate believes that “football” is played using your hands and that the ball is actually egg-shaped. This is of course ridiculous, because as the entire rest of the world knows, this is football whereas the game Nate is thinking of is (more...)

Viewing ASM trace files in VIM: Which Way Do You Use?

cafepress_womens_cap_sleeve_tshirt

A couple of people have asked me recently about a classic problem that most DBAs know: how to view ASM trace files in the VIM editor when the filenames start with a + character. To my surprise, there are actually quite a few different ways of doing it. Since it’s come up, I thought I’d list a few of them here… If you have another one to add, feel free to comment. I know that (more...)

Oracle 12.1.0.2 ASM Filter Driver: Advanced Format Fail

wrong-way

In my previous post on the subject of the new ASM Filter Driver (AFD) feature introduced in Oracle’s 12.1.0.2 patchset, I installed the AFD to see how it fulfilled its promise that it “filters out all non-Oracle I/Os which could cause accidental overwrites“. However, because I was ten minutes away from my summer vacation at the point of finishing that post, I didn’t actually get round to writing about what (more...)

Oracle 12.1.0.2 ASM Filter Driver: First Impressions

This is a very quick post, because I’m about to log off and take an extended summer holiday (or vacation as my crazy American friends call it… but then they call football  “soccer” too). Before I go, I wanted to document my initial findings with the new ASM Filter Driver feature introduced in this week’s 12.1.o.2 patchset.

Currently a Linux-only feature, the ASM Filter Driver (or AFD) is a replacement for ASMLib (more...)

New AWR Report Format: Oracle 11.2.0.4 and 12c

statistics-and-graphs

This is a post about Oracle Automatic Workload Repository (AWR) Reports. If you are an Oracle professional you doubtless know what these are – and if you have to perform any sort of performance tuning as part of your day job it’s likely you spend a lot of time immersed in them. Goodness knows I do – a few weeks ago I had to analyse 2,304 of them in one (long) day. But for anyone (more...)

New section: Oracle SLOB Testing

slob ghost

For some time now I have preferred Oracle SLOB as my tool for generating I/O workloads using Oracle databases. I’ve previously blogged some information on how to use SLOB for PIO testing, as well as shared some scripts for running tests and extracting results. I’ve now added a whole new landing page for SLOB and a complete guide to running sustained throughput testing.

Why would you want to run sustained throughput tests? Well, one (more...)

Oracle EBS 12.2 Online Patching – First Glance

Anyone that’s been following the release of 12.2 knows that Online Patching is the BIG feature that everyone is talking about.  I’ve had the opportunity to utilize this new functionality and it’s been quite interesting.  Online Patching is based on the Oracle Database 11.2 feature called (more...)

Bursting in One Step from R12.2: Users in the Dark on Request Status

In the latest release of EBS R12.2, Oracle has introduced the ability to burst in a single concurrent request. Although we predicted this was coming, we weren’t sure what it would mean for users and support admins. What we have found is that the new feature actually creates (more...)

Printing Attachments in Oracle 12.2: How does it Stack Up?

With the release of EBS 12.2, Oracle is making the claim that they have improved the attachment printing process. After reviewing the integration, I completely disagree; they have not given users a better solution.  No matter how you slice it, Oracle EBS customers are no further ahead with (more...)

Forms Personalization: Calculating an Item Value

I received the following comment recently on an older Forms Personalization post:

how can i get result from the following equation through personalization
K_LINES.LINE_VALUE = K_HEADER.K_VALUE/K_HEADER.PRIME_K_NUMBER

i want to know what is the syntax and what is the required steps to get the result automatically

thanx

(more...)

Error! FRM-92095: Oracle JInitiator version too low. Please install version 1.1.8.2 or higher

Brought a couple new PCs up recently and ran into the subject nasty error when attempting to access EBS.  We’ve run into this before and we usually get it worked out one way or another.  This time proved to be a bit challenging for some reason…  Thought I (more...)

Google reader is dead, long live RSS

So calling Google Reader dead may be a bit premature, but Googles announcement of their intention to kill their baby all but killed it. On monday it is RIP for the reader. I’ve gone through disbelief to mourning the loss to a search for a replacement that best emulates what (more...)

Fishbowl Solutions WebCenter Portal Spaces Addon – For Real Time Chat, Instant Messaging and Presence

Bringing Facebook, Gtalk styled messaging to Oracle Webcenter Portal Spaces.

If you still have this blog bookmarked – then head over to CFour where I post regularly and check out my latest WebCenter Portal Integration.

If your interested in a trial contact sales at FishbowlSolutions.com

Here is a quick breakdown of features:
- Does not require beehive, presence or XMMP servers for chat – just an authorised spaces connection
- Authenticates against webcenter and lists your webcenter Connections
- Show User online status
- Can link upto multiple XMPP Servers like the Pidgin Client but within a web browser
(more...)

Bursting EBS Documents in a Single Step Available in R12.2?

I came across Bug 12927519 on Metalink today that suggests that EBS R12.2 may include an enhancement to allow for bursting of BI Publisher/XML Publisher documents in one step (it says it was ‘fixed in product version 12.2.0.20X’)!  I do not see anything about in the 12.2 Release Content Documents, but that’s nothing new.

Currently, to burst you have to run 2 concurrent requests.  The actual concurrent request to generate your output and then a second concurrent request to actually do the bursting (XML Publisher Report Bursting Program).  This is not (more...)