OraSASH visualization

Database Management and Performance
| Oct 25, 2013

Hello,

I started working on that project 2 years ago and at that stage I created a JavaScript code to display real time graphs and parse JSON code. The backend providing JSON data from Oracle Database was based on PHP and I didn't like that solution as it required to (more...)

New release candidate of OraSASH

Database Management and Performance
| Oct 25, 2013
Hi,

 There is a new release candidate of OraSASH 2.4 available on github - https://github.com/pioro/orasash/tree/v2.4-rc2

 This version is providing much more views and it's easier to use your existing AWR queries against OraSASH. 

regards,
Marcin 

How to improve VMware performance on your PC

Database Management and Performance
| Jul 30, 2013
I found very interesting post here - VMware Performance Enhancing Tweaks (Over-the-Counter Solutions). I used it on my VMware Player and Workstation and when I disabled vmem file my laptop it stopped blinking HDD led for 5 - 10 min every time it wake up from sleep mode.

 regards,
Marcin

DataGuard – Far Sync – part 12 – Data Guard Broker

Database Management and Performance
| Jul 28, 2013
Oracle introduced Far Sync Data Guard configuration which I described briefly in this post. Now is time for part two and using Data Guard Broker to add Far Sync instance.
Assuming that you have basic Data Guard Broker configuration ready (as described in - How to quickly build standby database (more...)

How to quickly build standby database and setup DataGuard configuration using Oracle 12c

Database Management and Performance
| Jul 27, 2013
With every release of Oracle database there are new possibilities to build a required solution (ex. standby database) faster and with fewer steps. This is not official guide but rather a mix of Oracle 12c functionality used to build DataGuard configuration using RMAN and DataGuard Broker.

Assumptions:

DataGuard – Far Sync – part 1 – simple configuration

Database Management and Performance
| Jul 16, 2013
Oracle introduced a new feature for DataGuard called Far Sync. This configuration is design to support synchronous redo transport between primary and standby database which are far apart. In usual configuration synchronous redo transport between data centre in Europe and US is possible but inefficient from the primary database performance (more...)

Oracle 12c – incremental backup for DataGuard over network

Database Management and Performance
| Jul 9, 2013
If you have DataGuard or standby database in your organization you probably will love that new RMAN feature. Since 12c it is possible to catchup standby database using incremental backup using one command. Additional space and time need to run incremental backup, copy over to standby and restore can be (more...)

PL/SQL function in SQL – short example – Oracle 12c

Database Management and Performance
| Jun 29, 2013
This is my first post about Oracle 12c. When I first time heard about PL/SQL functions inside SQL my first thought was - can I use it in my topaas.sql script to run it in loop ? I decided to give PL/SQL functions in SQL a quick try to and (more...)

DataGuard FastStart Failover configuration with Oracle Wallet

Database Management and Performance
| Jun 7, 2013
Last two months were very busy for me with lot of work and moving house as well. There is a lot of thoughts in my head I want to write about but some of them have to wait until my lab will be online again.Recently I was working on (more...)

dbms_dnfs and clone.pl

Database Management and Performance
| Mar 29, 2013
If you are using to use dbms_dnfs to clone your database as described in MOS note 1210656.1 or on Tim's Hall blog - Direct NFS (DNFS) Clonedb in Oracle Database 11g Release 2 (Patchset 11.2.0.2) and your database version is 11.2.0.3 there is (more...)

Next OakTable 2012 video is online

Database Management and Performance
| Mar 20, 2013
Hi,

 This time Alex Gorbachev presentation about ASM failures - next videos on the way.

regards,
Marcin

New OakTable World 2012 video is published

Database Management and Performance
| Mar 3, 2013
Just published Kevin Closson video from OakTable World 2012.
Enjoy,

 Marcin

Oracle on AIX – where’s my cpu time ?

Database Management and Performance
| Feb 21, 2013
This story begins couple of weeks ago when I was asked to look on performance problem for critical processes before go-live. There were differences between run times between different test systems and between runs with 10046 trace enabled or not.

First of all I started with tracing issue. I have checked server CPU and disk utilization using NMON (tool name is important here). There wasn’t any problem with CPU utilization – or at least this is what I was thinking at that time. Tracing was enabled with level 12 (bind and wait) and it generate 2 GB of trace file (more...)

OakTable World 2012 – Greg Rahn video

Database Management and Performance
| Feb 9, 2013
New video from OakTable World 2012 is available - Greg Rahn - Beyond Relational Databases

 

regards
Marcin

New OakTable Video – Delphix presenation

Database Management and Performance
| Feb 1, 2013
New OakTable World 2012 video from Kyle Hailey presentation has been uploaded into YouTube.

regards,
Marcin

How dNFS database clone works – part 1

Database Management and Performance
| Jan 27, 2013
There is new feature in Oracle 11.2.0.2 called dNFS clone. It has been described by Kevin Closson on his blog post - Oracle Database 11g Direct NFS Clonedb Feature  and very good configuration description has been posted by Tim Hall on his blog - Direct NFS (DNFS) Clonedb in Oracle Database 11g Release 2 (Patchset 11.2.0.2). I have played with it just after I found both blogs but never think how Oracle implemented that feature. I came back to it when my colleague asked me if I ever use that in production environment (more...)

Oracle Linux and ESX hot add cpu and memory

Database Management and Performance
| Jan 15, 2013
I'm still quite new in Vmware ESX environment and features which I'm using now as my lab (curiosity of VMWare Guru Program).
This time I decided to test hot add CPU and memory functionality. It looks very interesting and in past years hot cpu / memory games where restricted to sophisticated hardware only - now everybody can test is at home.

 My lab is basesd on Intel 4 cores and VM are running Oracle Linux 6.3 with or without Oracle Enterprise Kernel. Here are my findings:

 1. Hot add CPU / memory is disabled by default and has to (more...)

Oaktable videos

Database Management and Performance
| Jan 13, 2013
Hi,

 Short update - I have upload new video from OakTable World 2012 - Brendan Gregg -- USE Method for Performance Tuning.

All videos and presentations can be found here - OakTable world

 regards,
Marcin

How to rename NIC in OEL 6.X

Database Management and Performance
| Nov 8, 2012
This is a quick note about host cloning and network interface (ethX) renaming.
As I wrote in my last post I have ESX lab now and I create a template of OEL 6.3 with all my settings and I would like use it for adding new VM (including RAC nodes). It is easy but there is one small issue – every time you clone VM network devices are renamed. Well MAC address is unique so it doesn’t surprise me but I would like to keep interface names like eth0, eth1 and eth2 and I got eth0, eth3, eth4 instead. (more...)

New lab setup

Database Management and Performance
| Nov 4, 2012
After couple of month playing with Oracle VM I decided to install and configure VMWare. Thanks to VMware Guru Program I’m able to test ESX 5i with one year license. This is excellent opportunity for me to get more familiar with newest VMware solutions. I have been using VMware tools for years and I remember times when I deployed my first Oracle RAC 9i on Workstation 3.x and had to "hack" configuration file to change disk.locking parameter to false.
When I start instalation I have run into couple of issues as I decided to leave my current disk (more...)