Many of you out there will be using dataguard and i guess most of you will have some variation of the startup trigger below
CREATE OR REPLACE NONEDITIONABLE TRIGGER "SYS"."MANAGE_SERVICE" after startupon databasedeclarerole varchar2(40);beginselect database_role into role from v$database;if role = 'PRIMARY' thendbms_service.start_service('NYNAME_DG');elsedbms_service.stop_service('MYNAME_DG');end if;end;
So basically if i startup and i'm the primary start the service MYNAME_DG - all clients (more...)
I have just realised that the number of posts about RAC 12c Release 1 on this blog is rather too small. And since I’m a great fan of RAC this has to change :) In this mini-series I am going to share my notes about creating a Data Guard setup on my 2 node 188.8.131.52.161018 RAC primary + identical 2 node RAC standby system in the lab.
NOTE: As always, (more...)
I've recently requested to be removed from the Oracle ACE program and move to the "Alumni" status.
I've already felt for a quite a while now that my area of expertise and interest as well as my public profile (no Twitter etc.) is no longer really a good fit to the ACE program.
The most recent changes to the ACE program then just have made my decision easier to step back.
All the best (more...)
It’s time to announce the next webinar in the Gluent New World series. This time I will deliver it myself (and let’s have some fun :-)
GNW05 – Extending Databases With the Full Power of Hadoop: How Gluent Does It
NB! If you want to move to the "New World" - offload your data and workloads to Hadoop, without having to re-write your existing applications - check out Gluent. We are making history! (more...)
Every so often a DSS query that usually takes 10 minutes ends up taking over an hour. (or one that takes an hour never seems to finish)
Why would this happen?
When investigating the DSS query, perhaps with wait event tracing, one finds that the query which is doing full table scans and should be doing large multi-block reads and waiting for “db file scattered read” is instead waiting for single block reads, ie (more...)
Just learned about this specifically to identify whether disk is being used by ASMLib
blkid – command-line utility to locate/print block device attributes
Oracle Linux Server release 6.4
# ll /etc/*release*
-rw-r--r--. 1 root root 32 Feb 22 2013 /etc/oracle-release
-rw-r--r--. 1 root root 55 Feb 22 2013 /etc/redhat-release
lrwxrwxrwx. 1 root root 14 Nov 29 2014 /etc/system-release -> oracle-release
-rw-r--r--. 1 root root 45 Feb 22 2013 /etc/system-release-cpe
# cat /etc/system-release
Richard Foote has published a couple of articles in the last few days on the new (licensed under the advanced compression option) compression mechanism in 12.2 for index leaf blocks. The second of these pointed out that the new “high compression” mechanism was even able to compress single-column unique indexes – a detail that doesn’t make sense and isn’t allowed for the older style “leading edge deduplication” mechanism for index compression.
In 12.2 (more...)
So the conference season is all over for another year. I have had a bumper crop of conferences and have been a very lucky man to attend and present and learn.
OUGN – The Boat – a 2 day conference on a ship. We’re all in it together, and nobody can sneak off after the last talk and avoid the party as we (more...)
SPOILER ALERT: This particular blog post is a blatant self promotion for me and the various Oracle database services I am offering.
I may not have mentioned it explicitly before but I have left the corporate world of permanent employment and have gone independent to offer my services direct to clients (at reasonable rates, of course). I'm doing this through my newly created company Bottleneck Data Solutions
, which has its own associated, obligatory web (more...)
The time has come for me to plan the upcoming 2017 UKOUG Special Interest Groups.
I am chairman of the RAC, Cloud, Infrastructure and Availability (RAC-CIA) SIG and I’m after presentations for the 3 joint SIGs we will be putting on with the RDBMS SIG, plus the stand-alone SIG will we will having in the autumn.
A SIG is a single day one-or-two stream conference which we take around the UK to make it (more...)
In Part I, I introduced the new Index Advanced Compression default value of “HIGH”, which has the potential to significantly compress indexes much more than previously possible. This is due to new index compression algorithms that do more than simply de-duplicate indexed values within a leaf block. Previously, any attempt to completely compress a Unique […]
This is just a prototype of a queue-based concurrent statistics implementation - using the same basic implementation I've used a a couple of years ago to create indexes concurrently
.There are reasons why such an implementation might be useful - in 11.2.0.x the built-in Concurrent Stats feature might turn out to be not really that efficient by creating lots of jobs that potentially attempt to gather statistics for different sub-objects of the (more...)
I nipped out to the local supermarket this lunch time to get stuff. I use one of those self-use barcode scanners to log all the goods I put in my basket (apart from the bottle of whisky I was stealing). I then go to the payment machine, scan the “finish shopping” barcode and try to pay. I can’t pay.
I can’t pay as I bought some paracetamol (note to US readers, you know it as (more...)
A Book on Oracle 12c New features for administrators
It’s our pleasure to announce the availability of our first book – OCP 12c upgrade 1Z0-060 Exam Guide
The book covers the new features of the Oracle Database 12c for the DBAs from the OCP 12c upgrade exam standpoint. Book is available WW in kindle format as well as paperback.
Link to Amazon.com (more...)
How to Configure Extract on Standalone Active Data Guard System if Primary is RAC Multipe Nodes (Doc ID 1962336.1)
Configuring Classic Capture in Oracle Active Data Guard Only Mode