Saturday, December 20, 2014

Log Buffer #402, A Carnival of the Vanities for DBAs

This Log Buffer edition hits the ball out of park by smashing yet another record of surfacing with a unique collection of blog posts from various database technologies. Enjoy!!!


EM12c and the Optimizer Statistics Console.
OBIEE and ODI on Hadoop : Next-Generation Initiatives To Improve Hive Performance.
Oracle Bundle Patching.
Performance Issues with the Sequence NEXTVAL Call.

SQL Server:

GUIDs GUIDs everywhere, but how is my data unique?
Questions About T-SQL Transaction Isolation Levels You Were Too Shy to Ask.
Introduction to Advanced Transact SQL Stairway and Using the CROSS JOIN Operator.
Introduction to Azure SQL Database Scalability.
What To Do When the Import and Export Wizard Fails.


Orchestrator 1.2.9 GA released.
Making HAProxy 1.5 replication lag aware in MySQL.
Monitor MySQL Performance Interactively With VividCortex.
InnoDB’s multi-versioning handling can be Achilles’ heel.
Memory summary tables in Performance Schema in MySQL 5.7.

Also published here.

Thursday, October 16, 2014

NZOUG14 Beckons

New Zealand is famous for Kiwis, pristine landscape, and New Zealand Oracle User Group (NZOUG) conference.  The location of choice is New Zealand when it comes to making Lord of the Rings and making Oracle Lord of the Databases.

NZOUG 2014 will be held 19–21 November in the Owen G. Glenn Building at the University of Auckland. The main conference will be held on the 20th and 21st, preceded by a day of workshops on the 19th. It's one of the premier Oracle conferences in Southern hemisphere.

Where there is Oracle, there is Pythian. Pythian will be present in full force in NZOUG 2014.

Following are Pythian sessions at NZOUG14:

12c Multi-Tenancy and Exadata IORM: An Ideal Cloud Based Resource Management
Fahd Mirza Chughtai

Everyone Talks About DR – But Why So Few Implement It
Francisco Munoz Alvarez

DBA 101: Calling All New Database Administrators
Gustavo Rene Antunez

My First 100 Days with an Exadata
Gustavo Rene Antunez

Do You Really Know the Index Structures?
Deiby Gómez

Oracle Exadata: Storage Indexes vs Conventional Indexes
Deiby Gómez

Oracle 12c Test Drive
Francisco Munoz Alvarez

Why Use OVM for Oracle Database
Francisco Munoz Alvarez
Please check the full agenda of NZOUG14 here.

Wednesday, June 4, 2014

RMAN-07518: Reason: Foreign database file DBID

While cloning a database to another system through RMAN in an 11.2 database on a Linux system, there was a need to catalog the backups after putting the destination instance in mount status, before the restore/recover process could be started.

Sunday, May 25, 2014

My Session Evaluation from Collaborate14 in Las Vegas Arrived :)

Dear Fahd Chughtai,

Thank you for presenting at COLLABORATE 14 – IOUG Forum in Las Vegas, Nevada. We hope that you will consider presenting at future IOUG events. You can view your evaluation results for the following session below: 194- 12c Multi-Tenancy and Exadata IORM: An Ideal Cloud Based Resource Management

Note: Session evaluations were based on a 1-5 scoring scale. (1 being the lowest and 5 being the highest)

Primary speaker was knowledgeable about the material
The primary speaker's presentation skills were satisfactory
The slides and materials presented in the session were satisfactory
The agenda abstract and objectives were accurate to the session presentation
I learned a lot of new information in this session.
I can apply what I learned in this session to my job
Overall, how would you rate this session?

Sunday, April 13, 2014

From Las Vegas to Ottawa

After a very engaging session at Collaborate14 in sunny Las Vegas amidst the desert of Nevada, I just arrived in not-so-bitterly cold Ottawa, the capital of Canada. Looking forward meeting with various Pythian colleagues and hanging out with the friends I cherish most.

My Exadata IORM session went well. Lots of follow back discussion plus questions are still pouring in. I promise I will answer them as soon as I return to Australia after couple of weeks. That reminds me of my flight from one corner of the globe to the other, but well I need to learn as how to sleep like a baby during flights. Any ideas?

Ottawa reminds me of Australian capital Canberra. It's quite a change after neon-city Vegas. Where Vegas was bathing in lights, simmering with shows, bubbling with bars, swarming with party-goers, and rattling with Casinos; Ottawa is laid-back, quiet, peaceful, and small. Restaurants and cafes look cool. Ottawa River is mostly still frozen and mounds of snow are evident along the road sides with leafless trees.

But spring is here, and things look all set to rock.

Monday, March 17, 2014

DBRM for 12c Container Database in Multi-tenant Environment

In multi-tenant environment, Database Resource Manager (DBRM), at the Container Database (CDB) level enables us to manage the resources like CPU usage and number of parallel execution servers among the plugabble databases (PDBs). Then within each PDB, DBRM enables us to manage resources like CPU, parallelism and managing the runaway queries which exceed the certain thresholds of CPU, physical IO, logical IO or elapsed time.

Tuesday, February 11, 2014

Speaking at Collaborate14 in Las Vegas

12c Multi-Tenancy and Exadata IORM: An Ideal Cloud Based Resource Management

Cloud database enables administrators to scale up and down the resource usage according to the business requirements. Oracle 12c renders multi-tenancy to manage multiple pluggable databases within a multi-tenant container database. In an Exadata, at the compute nodes, the resource manager controls the resources among pluggable databases, and all this resource management is trickled down to the storage servers, where IORM controls the resources. This presentation lucidly explains as how a business can leverage the benefits of 12C multi-tenancy, DBRM, and IORM in an Exadata realm to have an ideal cloud based resource management.


Following is the welcome page for the Collaborate14.

Thursday, February 6, 2014

IORM Architecture in Exadata

From the database notes, the I/O requests are sent to the cell nodes. These requests go through the intelligent iDB protocol containing information pieces like database name, category name, consumer group etc. These I/O requests are placed in the CELLsrv I/O queues in the order they are received. Then these I/O requests are passed to the IORM, which prioritize these requests on the basis of IORM plan and then places them accordingly into the Cell disk queues.

Monday, January 27, 2014

Most Simplest Example of Big Data Ever

When I have to travel by air to somewhere, I go to a specific website to search and book my flight. Every time I visit that website, I encounter the same experience. I have to go through the same steps according to my same preferences, every time I need to book the flight.

Here is what I always do to book my flight at that website on each visit:

  1. Sign in with my userid
  2. Type in my origin and destination (90% of time same)
  3. Type in dates
  4. Sort the results by lowest price
  5. Search for flights with lowest price and least hops (Direct are ideal)
  6. I prefer red eye flights, so I also look for them.
  7. After searching for long time, I come close to what I want and then book it.
Despite of my log-in, despite of my usual pattern of purchase, website doesn't know what I am looking for. After my log-in, all they present to me is my personal details, limited travel history, reward points, and offers based on those reward points.

In other words, they present me with Small Data.

How nice would it be, if after sign-up they ask me in simple words:

Hey Fahd, are you still your old miser-self and want to get the cheapest direct flight(s) from Darwin to Sydney at that godforsaken time at night?

I would then just laugh, click yes, give me travel dates, and they would present me with options tailored to me habits. I know they would have to go through lots of data, anlayze it, slice it, dice it, and then come up with that above statement. I know I am not their only customer, and so they have to do the same for hundreds of thousands of their customers with more complex patterns, along with sifting through data of their partner airlines, may be hotels, car rentals, etc.

In other words, they have to go through Big Data.

Saturday, January 25, 2014

My Article on SearchOracle about Exadata Administration

The massive explosion in data, combined with an ever-increasing hunger to boost processing speeds while keeping costs low, has led to engineered systems in data centers.

Read More