Upgraded production to 11.2.0.4 a few nights ago. The primary is 3-node RAC and the standby is 2-node RAC. Notice that one of the threads was not transmitting redo to the standby. Saw this repeatedly in the alert log: Error 1033 received logging on to the standby Turns out this was a problem …
Category: Oracle
Sep 05
Oracle 12.2.0.1 coming in 2016
Oracle will be releasing Oracle 12cR2 in the first half of 2016. See Metalink Note 742060.1 for the current release schedule. The Oracle 12.1.0.3 patchset is not on the list but there is a chance it will be out before 12cR2. We’ll have to wait and see I guess. Erectile dysfunction is termed as a …
Aug 14
Result Cache
I was playing around with the Result Cache the other day…I know…this isn’t a new feature and has been available for awhile. Unfortunately, it can take a while to get to things I guess. In my simple test, I had a query that exhibited this behaviour: select max(det.invoice_date) from invoices i join …
Aug 08
GI 12.1.0.2 Upgrade
The 12.1.0.2 patchset has been out for a bit now. I am just now finding time to be able to take my first look at it. I’m interested, like many others, in looking at the In Memory database option. But I need to upgrade my Grid Infrastructure before I can upgrade my database. The upgrade went …
Aug 01
Oracle In-Memory Cost
Just read an interesting post by James Morle on the “true cost” of Oracle’s new In-Memory database option. It’s a good read. Fishes in the form of sardines, get free viagra salmon, etc. are vital sources of Omega 3 fatty acids. A few problems can also be caused cialis 20 mg by the use …
Jul 15
Oracle Big Data SQL
Oracle announced a new product called Big Data SQL that will be available in the Fall. I think this product will be interesting. The one downside I see is that it appears to only run on an Oracle appliance which means you are forced to use their hardware as well. For more information, see the …
Jun 16
Safety Nets
Safety nets exist for a reason. To protect you from when a catastrophic event happens. To stop that event from becoming your worst nightmare. A person who washes windows on a skyscraper has one catastrophic event to worry about…falling to the ground. So that person wears a harness attached to a rope. If the platform …
May 14
Tuning SQL
Not that long ago, I gave a tutorial on Explain Plan to our application development staff. One question that came up was how do I go about deciding which SQL statements need tuning? I use a few different approaches and find SQL tuning candidates from different angles. I routinely perform code reviews on SQL …
Mar 26
Grid Infrastructure Upgrade Assistants
Yesterday I was working on testing an upgrade of Grid Infrastructure 11.2.0.3 to 11.2.0.4 in my testbed. This is my first step in my larger plan to upgrade our production systems to 11.2.0.4 this calendar year. For my X-windows environment which I need to run the Oracle Universal Installer, I run Ubuntu Linux in Virtual …
Feb 07
Obtain Database Patchsets
I see this question asked often on the My Oracle Support Communities, so it must not be that obvious as it seems to be. So I figured I would post this on my blog. The question is “how do I obtain the XX patchset for my Oracle database”? Sometimes people post the link to the …
Oracle DBA Mentor
Oracle RAC Performance Tuning
Latest Tweets
-
@sacrophyte That was an old recommendation which is probably out of date now. When I look at the 19c doc for that p… https://t.co/h0VwGJECvH
-
Also in that note is "We decided to not promote our Database 20c Preview version to General Availability. Instead,… https://t.co/bvUcRKQ9gt
