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...)
In my previous post on the subject of the new ASM Filter Driver (AFD) feature introduced in Oracle’s 188.8.131.52 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...)
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.
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...)
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...)
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...)
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:
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
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...)
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...)
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...)
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...)
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...)
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
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...)
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 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
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 184.108.40.206X’)! 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...)
It’s been around for a month or so, but I just got around to checking out the new BI Publisher Enterprise 11g Trial Edition that the BIP folks posted about in May.
When BIP 11g hit the streets the installation was huge. Unlike the small and easy to install BIP Enterprise 10g, 11g was quite a chore to install. Sure it was prettier than 11g and gave a lot more functionality as it’s now integrated with OBIEE, but it wasn’t very practical if you just wanted to run it on your laptop or desktop for development or demo (but (more...)