Oracle VM Consulting
view counter

Database Feed

Oracle Database, Oracle 10g, Oracle 11g, Oracle XE, Oracle RAC, Oracle Instant Client, Oracle Data Guard and Oracle Exadata resources, news, and support articles.

SQL Monitor report little improvement in 12c

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

Cartesian join

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.

Demos do fail.

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.

Keep Connected! Expats and Nomads Blog Around the World

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!

Smart firewalls

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 11.2.0.3 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.

OCM 11g Preparation – Use Recovery Manager to perform database backups

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.
Thus, practice:

Good Singapore Maths Students Would Likely Make Good Oracle DBAs (Problems)

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 […]

Monitoring Oracle GoldenGate Latency

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
(
extr varchar2(10),
pump varchar2(10),
repl varchar2(10),
update_time date
);



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: 

Report In The Cloud Part 2

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 […]

view counter