Migrating Windows PuTTY registry to Linux

I have over 100+ saved sessions in PuTTY running on Windows and was looking for a way to move those session to Linux.

Here’s a demo on how to move those PuTTY sessions.

First, download pwin2lin.pl on Linux from https://code.google.com/p/pwin2lin/

Next, install PuTTY on Linux from http://pkgs. (more...)

Parallel Full Database Export and Interactive-Command Mode

Data Pump is much faster than the old exp and imp client commands. Data Pump has a feature that helps to make it even faster by trading performance for resource consumption (CPU); this feature is called the “parallel” option. With this option, Data Pump will dump data and metadata using (more...)

OVM V2V – Converting ESX VM to OVM using ISO boot CD

In this blog post we will learn how to convert an ESX VM to OVM  3.1 (V2V) using an ISO boot CD. Basically all you need to do to achieve this objective is to follow the following steps:

1. Uninstall VMtools from VM

2. Attache OVS-3.1.1-524.iso (more...)

SQL Gone Bad – But Plan Not Changed?

Last week an interesting issue popped up on a mission critical production app (MCPA). A statement that was run as part of a nightly batch process ran long. In fact, the statement never finished and the job had to be killed and restarted. This particular system is prone to plan (more...)

How to Rename an Oracle Tablespace

In Oracle 9 you got an error if you tried to rename a tablespace: 

SQL> l
  1* alter tablespace users rename to andrew
SQL> /
alter tablespace users rename to andrew
                              *
ERROR at line 1:
ORA-01904: DATAFILE keyword expected
 
SQL>

… but from Oracle 10 (more...)

Delphix

If you’ve been keeping an eye on my Public Appearances page you’ll know that I was scheduled to go on line with Kyle Hailey for a second (more technical) discussion about Delphix and virtual databases on 13th June. Unfortunately we’ve had to move this on to 19th June, something came (more...)

Database Thin Cloning: Allocate on Write (ZFS)

This post is part of an ongoing series:

(very interested in real life experiences and (more...)

Experts say enterprises need to simplify the data center architecture

Many enterprise IT teams are struggling to keep up with changing trends, accelerating storage demands and emerging tools. In order to capitalize on new solutions, such as cloud computing, to enhance infrastructure performance and scale, companies will need to leverage dba services to develop a new approach to designing and (more...)

Big data continues to be a major disruptive technology

Big data has dramatically transformed the way that businesses manage, analyze and use information. As enterprises look to capitalize on considerable potential insight from new data sources and channels, however, the right combination of skills and analytics technologies are crucial. With the help of database experts, firms can develop a (more...)

Cloud still a top priority, but skills gap challenges benefits

Enterprises of all sizes and sectors have increasingly adopted cloud computing initiatives in order to maintain a competitive edge. As businesses look to address the challenges that come with the emergence of big data, mobile technologies and social media, cloud solutions can be particularly valuable. However, some firms are still (more...)

Getting the Most Out of ASH online seminar

Just a little reminder – next week (10-11th June) I’ll be delivering my last training session before autumn – a short 1-day (2 x 0.5 days actually) seminar about Getting the Most Out of Oracle’s Active Session History. In the future it will act as sort of a prequel (more...)

Database Thin Cloning: WAFL (Netapp)

Following the upon the previous two blog entries on database thin cloning

Write Anywhere File Layout (WAFL)

With EMC, thin cloning can only be achieved by using backup technology; in essence, the process has to be architected manually in order to support databases. How can the (more...)

EM12c Disk Busy Alert for Oracle Database Appliance V1 & X3-2

Oracle Just Published a Document ID 1558550.1 that talks about an issues that i've had an SR out for 6 months now.
Due to a Linux iostat bug  BUG: 1672511 (unpublished)  - oda - disk device sdau1 & sdau2 are 100% busy due to avgqu-sz value
This forces host (more...)

Salesforce.com Real Time integration with Oracle using Informatica PowerCenter 9.5

In this post I will describe how you can integrate your Salesforce.com org with a relational database, like Oracle in real time, or better 'near' real time!

Many times I come across the requirement of quickly propagating changes from cloud platforms like Salesforce.com to on-premise data stores. You (more...)

ORA-01623, ORA-01624 and ORA-01567

This was tested on an Oracle 11.2.0.2.7 database. The output below shows that this database had 3 online redo log groups. You can only drop a redo log group if its STATUS is INACTIVE so when I tried to drop the CURRENT redo log group, I (more...)

Database Thin Cloning: Copy on Write (EMC)

Continuing from the previous blog post : http://dboptimizer.com/2013/06/03/database-thin-cloning/

Copy on Write

Copy on write is a filesystem mechanism that allows filesystems to create snapshots at specific points in time. Whereas Clonedb is a little known and rarely used option, filesystem snapshot technologies are widely known and used in the (more...)

Oracle RAC Timezone woes and solution


Recently had a timezone issue with an Oracle 11gR2 RAC cluster. Even though I had set the host time and date, for some reason it did not get propagated to the Oracle RAC configuration.

There are couple of ways to set timezone for an Oracle 11.2 RAC cluster. First (more...)

Clustering Factor Calculation Improvement Part III (Too Much Rope)

In my previous post, I discussed how for larger tables that really do have randomised data, not even setting the new TABLE_CACHED_BLOCKS to its 255 maximum value is going to make any real difference to the resultant Clustering Factor (CF) of an index. The 255 maximum value here protects us (more...)

TROUG 2013 DW/BI SIG

Selam, ikinci Türk Oracle Kullanıcıları Derneği, BI/DW özel ilgi grubu toplantımız 21 Haziran günü İTÜ Maslak ‘da gerçekleşecek. Draft plan şu şekilde: 09:00 – 09:30 Kayıt ve açılış 09:30 – 10:15 Ersin İhsan Ünkar / Oracle Big Data Appliance & Oracle Big Data Connectors – Hadoop Introduction 10:30 – 11:15 (more...)

Database Thin Cloning

A production database is full of data that makes sense for its purpose. There are metadata tables for important business facts, tables that hold history, and tables that are used for processing transactions. Whether the database is 10GB or 10TB, the data it contains is the data it needs (with (more...)