This is a very short post about something I though I had already blogged about.
I like SQL Monitoring active reports. The are graphical, and still very light. There is only one thing I don't like about it in 11g and it has been improved in 12c
Some time ago I pulled off the apocryphal “from 2 hours to 10 seconds” trick for a client using a technique that is conceptually very simple but, like my example from last week, falls outside the pattern of generic SQL. The problem (with some camouflage) is as follows: we have a data set with 8 “type” attributes which are all mandatory columns.
I am an ardent believer of “show me how it works” principle and usually, I have demos in my presentation. So, I was presenting “Tools for advanced debugging in Solaris and Linux” with demos in IOUG Collaborate 2015 in Las Vegas on April 13 and my souped-up laptop (with 32G of memory, SSD drives, and an high end video processor etc ) was not responding when I tried to access folder to open my presentation files.
We don’t write blogs purely for ourselves — we write them to be read. For people who live far from family and friends, blogs serve twin readerships: they give the intrepid traveler a simultaneous way to chronicle travels for a broad audience and update those back at home.
We love following the worldly adventures of these four expats and nomads, and we’re sure their friends appreciate the virtual lifeline, too!
It’s been a while since my last post but I was really busy working on a number of projects.
The purpose of this post is to highlight an issue I had while building a standby database. The environment we had – three 126.96.36.199 databases at host A (primary) and same were restored from backup on another host B (standby), both hosts were running Linux. It’s important to mention that both hosts were located in different Data Centers.
Creating an efficient backup strategy is important to reduce your recover time. If your system is critical, the backup procedure must be setup accordingly to meet the SLA requirements.
For OCM exam, I have no idea what they will ask. Keep in mind to trace some plan to restore/recover what you need in the most efficient way.
An interesting mathematics based question from a Singapore high school exam has been doing the internet rounds in the past few days. Considering it’s aimed at high school students, it’s a tricky one and obviously designed to filter out the better students, in a country with a very good reputation for churning out mathematically gifted […]
Today I've implemented an approach to monitor OGG latency. Here I will describe what I've done.
1. Create a table gg_latency in source and target databases:
create table gg_latency
alter table gg_latency add constraint gg_latency_pk primary key(extr, pump, repl) using index;
2. Create a procedure that is used to update the latency table:
In Part 1, we discussed a bit about the differences in AWS EC2 instances and AWS RDS instances; then it was right into the facts about how to set up replication from on premise to the cloud. In the Dbvisit Replicate release 2.7, the setup wizard was enhanced to have specific information for AWS RDS […]