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...)
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...)
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...)
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...)
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
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...)
This post is part of an ongoing series:
(very interested in real life experiences and (more...)
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 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...)
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...)
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...)
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...)
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...)
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...)
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...)
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...)
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...)