OraNA :: Oracle News Aggregator

Today I have fixed an issue related with serial direct path reads.
There is 11.2 database

SQL> select * from v$version where rownum = 1;

BANNER
——————————————————————————–
Oracle Database 11g …

THE WICKED WITCH OF THE WEST NEEDS HELP BE IT KNOWN BY THESE PRESENTS that the Wicked Witch of the West needs your help to create a magic spell to ensure that the Third Annual Witching & Wizarding Ball is a grand success. A great tournament has bee…

I hate having to type my email address, so I created a long one-liner to do the trick of getting my email from Exchange and copying it in my clipboard

powershell -noprofile -command "$o=New-Object DirectoryServices.DirectorySearcher; $o.SearchRoo…

When i try to increase the size primary volume group , it show following error.

[root@testser dev]# pvscan

Couldn’t find device with uuid ’6fq50M-M4b8-mV4b-10ff-UKHA-CgDE-ojFbn0′.
PV /dev/sda2 VG VolGroup00 lvm2 [24.88 GB / 0 free]
PV unknown device …

Discussion on how to create sql_patch with force_match=true in Oracle 11g and related topics.SQL patches have recently saved the day for me in a production issue where a given SQL had suddenly changed execution plan causing IO overload (a full scan was…

Oracle Database provides data dictionary views and PL/SQL packages that allow you to display information about the space usage of schema objects.
DBMS_SPACE : refer here
Just a example :

SQL> VARIABLE total_blocks NUMBER
SQL> VARIABLE total_byt…

Martin Berger suggested to create this page to keep track of blog posts related SLOB IO testing. Here it is Martin If you are seriously interested to get a good understanding of your IO subsystem performance characteristics then one of the tools …

I really thought I’d blogged about this before, but it appears not!
First of all, this isn’t something I’ve worked out, I’m just recycling something that John Beresniewicz (who seems to be better known as JB) shared during one of his presentat…

Earlier i used to maintain different sql script files for one function for every database version. As some of the older release dont have some of columns available in new release’s view/tables. I started updating my scripts to maintain a single scrip…

May 20, 2012 An interesting quirk was recently brought to my attention by Mich Talebzadeh.  He generated a 10046 trace at level 8 for a session, executed some SQL statements, disabled the trace, and then processed the resulting trace file with TKPROF….

In my previous post CURRENT_SCN and CHECKPOINT_CHANGE#, I had asked : “In which scenarios could the checkpoint_change# value differ between V$DATAFILE and V$DATAFILE_HEADER ?” Here’s a little demo :SQL> create tablespace NEWTBS datafile '/tmp/ne…

The tough challenge that seems to have been faced by this developer was that the ID, name and value passed into the procedure needed to be either applied as an update if the name existed, or else inserted as a new row. You might think you could just us…

If you are wondering what I am busy with then this post explains it. As you may noticed I am still testing one of the Oracle systems using the SLOB framework and learning on my way. I ran several tests with the same parameters (Readers 24) and I noti…

Harbingers is the tenth book in the Repairman Jack series by F. Paul Wilson.
The last of Jack’s relatives are gone. Are his girlfriend (Gia), her daughter (Vicky) and Jack’s unborn child the next in line? Is there anything Jack can do to protec…

How to make the good design databases? That is the hard question. In my opinion, You were supposed to understand the theory, that can help. Database Design theory, Like Normalization or Normal Form.  Anyway, You can find out about them in the internet…

>> Means URL opens in new window.
>> Upgrade from 11.2.0.2.0 to 11.2.0.3.0 & Apply PSU 11.2.0.3.2 Notes
>> Best approach for Oracle database patching sequence to latest/required patch set along with CPU/PSU/any-other-one-off patch…

Steps 1: Install Oracle 11.2 server/client on the host
You can download oracle from download.oracle.com

Steps 2: Install Perl on the host.
Check if perl is already installed on the host:
# perl -v
Most hosts have perl already installed.
You can d…

I have a confession to make: I hate webinars. I find it difficult to concentrate on a disembodies voice. I typically get distracted and find myself checking email and blogs even during the best webinars. Watching a webinar is a bit like watching DVD of…

It is evident and beyond doubt now that the new media technologies like Twitter and Facebook are not going to wipe-out the blogs, rather they are complimenting each other very nicely and it seems they were made for each other. This Log Buffer Edition e…

After completing your Oracle VM and Oracle VM Manager installation (see my previous blog posts here) you are ready to start your friendship with Oracle VM technology. However to make your life and experience even more enjoyable I would suggest you to f…