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 is to describe the problem here, after which step 2 will probably be to sit back and hope someone far (more...)
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
Filed under: Blog
, oracle vm
I’ve spent a lot of time in this blog series talking about the challenges involved in using flash, such as the way that pages have to be erased before they are written and the restriction that erase operations take place on a whole block. I also described the problem of erase operations being slow in comparison to reads and writes – and the resulting processes we have to put in place to manage that problem (i. (more...)
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 loads the application tends to fire off a glut of queries to populate all the various fields, graphs and so (more...)
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...)
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:
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...)
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.
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...)
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...)
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...)
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...)
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...)
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...)
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...)
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
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...)