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 …
Category: Oracle
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 …
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 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. …
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
