Brian Peasland
Author's posts
Dec 30
ORA-01618
This is my 100th post to this blog!!! I am trying to duplicate a problem where I have threads 4, 5, and 6 in my primary and my standby has threads 1 and 2. When I did a switchover, everything was fine, but I could not switch back because the old primary, now the standby, …
Dec 19
Standby Network Tuning
I’ve been working on tuning our network configuration between our primary and standby databases. This entry shows the steps I took. The first thing to check is our bandwidth. I talked with our Network Admin and we have a DS-3 link between our primary data center at our corporate headquarters and our DR site 30 …
Dec 13
SQL Developer 4.0 Released
The latest/greatest version of Oracle’s free SQL Developer has now been released. Previously, version 4.0 was in Early Adopter release, which I think is just a fancy way of saying “beta”. If you want to see new features or tips and tricks, then go to That Jeff Smith’s blog. He is the product manager for …
Dec 10
Flushing Single Cursor
Earlier today, I was answering a question where someone proposed as a possible solution the idea of flushing the Shared Pool to solve a problem with one SQL statement. I find this to be bad advice. As I stated in my reply, why kill all end user’s performance to solve one guy’s problem? My answer …
Nov 25
EM12c Database Time Spent Waiting alerts
I have an Oracle EM12c environment (version 12.1.0.3) set up to monitor my production databases. On one database, I occasionally get an alert for the ‘Database Time Spent Waiting (%)’ category. Yet I have disabled this metric in EM. I found out that this metric is a server-side alert. Disabling in the OMS does not …
Nov 19
12c Deprecated Features
Everyone likes to talk about the new exciting features in Oracle 12c. But what will be going away that you need to start preparing for? I haven’t seen much discussion in this area yet so I figured I would blog about it. You can view the list of deprecated features in the 12c Upgrade Guide, …
Oct 16
No more SPU
I meant to blog about this awhile back but I got sidetracked. Last month, Oracle announced that for Oracle 12c, it would no longer be offering two types of patches every quarter in the Cumulative Patch Update (CPU). Currently for 11g, you can get a Security Patch Update (SPU) which contains just security fixes or …
Oct 04
Another 12c Optimizer White Paper
Yesterday, I blogged about a good white paper I found from Maria Colgan of Oracle Corp relating to the CBO. I also discovered another good paper. This one discusses all of the CBO-related enhancments for Oracle 12c. You can find this paper here. Optimizer with Oracle Database 12c This one is a really good read. …
Oct 03
CBO Statistics White Paper
At Oracle OpenWorld 2013, I attended a presentation by Jonathon Lewis, who of course is one of the world’s leading Oracle experts especially when it comes to the Cost Based Optimizer (CBO). As is usually the case, the room was completely packed for his presentation. He had a co-presenter, Maria Colgan who works for Oracle …
Oct 03
One of my typical days
Yesterday morning, I ran across this blog entry from Bobby Durrett’s blog about a typical day in his life as a DBA. So I figured I would have some similar fun and document my workday. So here is how my day went yesterday: 7:30 – Got to work. Checked email to make sure there was …
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
