Brian Peasland
Author's posts
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 …
Jun 04
Splunk
A few weeks ago, I attended some training on a new product at my company called Splunk. After the training was over, I spent some time reflecting on this product’s strengths and how it can be leveraged in our business. Splunk is great working with unstructured data. The most common source of this data …
May 19
Google Doodle – Rubik’s Cube
This is just one of those posts that have nothing to do with databases. Today’s Google Doodle is a working Rubik’s Cube to celebrate the 40th anniversary of this device. Like millions of others, I had one of these when I was growing up. I learned early on how to break them apart so …
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 …
May 14
Updated WP
Today I updated WordPress that I use for this blog. The upgrade started when I initially upgraded the theme used for presentation. But the theme upgrade broke my blog. Contact your spehttp://new.castillodeprincesas.com/item-4093 viagra on line prescriptiont immediately in the event that you have any of thesesigns of a hypersensitive response:Amid sexual movement, in the event …
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 …
Feb 07
Oracle Interface Changes
I regularly participate in the My Oracle Support Communities and answer lots of questions there. Late last week, Oracle changed the interface and like many people, I haven’t necessarily found it to be better. I am getting used to the new UI. And as I use it more and get past the learning curve, it …
Feb 05
TEMPFILE Offline Physical Standby
I received an alert from Enterprise Manager Cloud Control that a tempfile was offline in my physical standby database. Message=The temporary file /u01/app/oracle/oradata/ncpp/temp/temp01.dbf is OFFLINE. We recently did a restore of the standby, i.e. recreated it from a backup. Surprisingly only 7 of the 8 tempfiles were available. One tempfile was missing. I found this …
Dec 31
ORA-38868
When working on a standby database recently, I went to DG Broker to check the status and received this: DGMGRL> show configuration Configuration – resp_ress_config Protection Mode: MaxPerformance Databases: resp – Primary database ress – Physical standby database Error: ORA-16766: Redo Apply is stopped Hmm…my standby is not applying redo. When I attempted …
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
