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...)

History of AMIS Blog design, Congratulations AMIS

It is July 2014 and the AMIS Blog celebrates it’s 10th anniversary. While diving in the history of the AMIS Blog it is very interesting (amusing and somewhat shocking) to see were we came from. Using the Internet Archive (https://archive.org) I made some screenshots of the AMIS blog depicting the different styles. We made 3 major steps in the design of the blog. Please join me for this trip through memory lane….

640*480 (more...)

Congratulations to AMIS, 10 years of blogging

10 year anniversary AMIS Technology blog – Congratulations from around the world

“ The AMIS Technology Blog continues to impress me as a platform to turn to for sources of innovation and inspiration.
If you want to see where enterprise-grade software technology is going, what direction to point your technology career for the future, and learn some impressive capabilities are of Fusion Middleware – read this blog. “

Misha Vaughan
image
Oracle, Director, Communications & Outreach, (more...)

AMIS celebrates the 10th anniversary of the Technology Blog

imageIn July 2014, the AMIS Technology Blog has been live for ten years. A decade of sharing knowledge, opinions, research results and reviews. Ten years of community service – driven by enthusiasm, knowledge and fun.

Counted among the most visible and valuable resources on Oracle technology today, the AMIS Technology Blog was first launched in July 2004. Using the then relatively new blogging tool WordPress on a small Linux server under a desk somewhere in (more...)

Knowledge is power, sharing knowledge is powerful

Information sharing stimulates innovation and technical excellence

Almost 8 years ago I joined AMIS. Before this I worked with a lot of Open Source projects and companies. The key to a good Open Source project is sharing information. In my vision the AMIS Technology Blog is an excellent form of the open source way of sharing information. In 2004 we were the first company within the Oracle knowledge domain to actively and openly share all our (more...)

Understanding Flash: SLC, MLC and TLC

slc-mlc-tlc-fruitmachine

The last post in this series discussed the layout of NAND flash memory chips and the way in which cells can be read and written (programmed) at the page level but have to be erased at the (larger) block level. I finished by mentioning that erase operations take substantially longer than read or program operations… but just how big is the difference?

Knowing the answer to this involves first understanding the different types of flash (more...)

Understanding Flash: Blocks, Pages and Program / Erases

In the last post on this subject I described the invention of NAND flash and the way in which erase operations affect larger areas than write operations. Let’s have a look at this in more detail and see what actually happens. First of all, we need to know our way around the different entities on a flash chip: the die, the plane, the block and the page:

NAND Flash Die Layout (image courtesy of AnandTech)

NAND Flash Die Layout (image courtesy (more...)

Blog : Oracle DBA Blog 2.0

Un blog intéressant à consulter : Oracle DBA Blog 2.0 

On y trouve des articles intéressants; par exemple sur Enterprise Manager & CMDB : http://dbaharrison.blogspot.de/2014/05/on-using-cloud-control-as-cmdb.html 

New My Oracle Support note on Advanced Format (4k) storage

advanced-format-logo

In the past I have been a little critical of Oracle’s support notes and documentation regarding the use of Advanced Format 4k storage devices. I must now take that back, as my new friends in Oracle ASM Development and Product Management very kindly offered to let me write a new support note, which they have just published on My Oracle Support. It’s only supposed to be high level, but it does confirm that the _DISK_SECTOR_SIZE_OVERRIDE (more...)

Understanding Flash: What Is NAND Flash?

circuit-board

In the early 1980s, before we ever had such wondrous things as cell phones, tablets or digital cameras, a scientist named Dr Fujio Masuoka was working for Toshiba in Japan on the limitations of EPROM and EEPROM chips. An EPROM (Erasable Programmable Read Only Memory) is a type of memory chip that, unlike RAM for example, does not lose its data when the power supply is lost – in the technical jargon it is non-volatile. It does (more...)

Understanding Disk: Caching and Tiering

 

roulette-and-casino

When I was a child, about four or five years old, my dad told me a joke. It wasn’t a very funny joke, but it stuck in my mind because of what happened next. The joke went like this:

Dad: “What’s big at the bottom, small at the top and has ears?”

Me: “I don’t know?”

Dad: “A mountain!”

Me: “Er…<puzzled>…  What about the ears?”

Dad: (Triumphantly) “Haven’t you heard (more...)

Oracle SLOB On Solaris

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. Nate believes that all English people live in the Dickensian London of the 19th century and speak in Cockney rhyming slang. I hate to disappoint, so have a butcher’s below and feast your mince pies on his attempts to make SLOB work on Solaris without (more...)

How To Succeed In Presales?

success-and-failure

This article is aimed at anyone considering making the move into technical presales who currently works in a professional services, consultancy or support role, or as customers and end-users. You will notice that the title of the article has a question mark at the end – that’s because I don’t have the answer – and I have neither the confidence nor the evidence to claim that I have been a success. But I have made lots (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...)