Like a cat on Hot tin roof changing sdu size


On one of the projects there is a performance dip between Midnight and 05:00 and I have been asked to investigate the environment.  The Oracle database I am working with is a 920.6 32 bit version on HP UNIX.  I have used Stats pack as tool to do analyses. These stats packs are running in 15 minutes intervals in the database. During the intervals at night the top wait events are very often:

Event                                               Waits    Time (s) Ela Time
-------------------------------------------- ------------ ----------- --------
SQL*Net more data to client                        77,119          74    31.11
CPU time                                                           63    26.36


Continue reading

The Good , the bad and the Gui Listener


Sometimes it is almost funny how old habits indeed seldom die.  At the Customers site where I am working there still seems to be a culture in which it is not that common to use Gui solutions offered by Oracle to do day-to-day jobs. In Dutch there is an  expression telling unknown things  makes things disliked. Well this week i came across nice behavior of the NETCA tool in an environment where Grid Infrastructure is running and I must say I really liked it.

My environment is a four Node Cluster on Redhat Linux 5.5, my Grid Infra structure is

Continue reading

Rman Recovery of a Rac Database


As part of a QA  process I am restoring a Rac database.  Rman as a back-up recovery that  has been around some time now (I started working with it as from Oracle 8) will be used for it.  Even though I am aware of debates that this could be done much easier via the Gui I am still tempted to use command line ( scripting for it).  This is the general information about the  environment where this will happen today: The 2 Instance Rac Database is on Linux servers on two nodes. Backups are performed to tape directly using Rman. We are using Networker for that. The environment  i am working with is a with ASM. As part of sharing information below are the steps I performed with some add-on comment.

Continue reading

Oracle Database Wrap-up from Oracle OpenWorld 2012

Oracle Database Wrap-up from Oracle OpenWorld 2012

Maybe  you have missed this on the web  i do like it a lot cause it gives us a nice insight in the direction Oracle is moving  to . Three  brilliant speakers will give you a great insight in the way of the future:

Very exciting information to see and listen too also cause  it will tell you more about Oracle release 12C.

Happy watching and reading,


Logical Standby Database an implementation


For my colleagues at Atos I have set up a Presentation of my experience with the Logical standby database. Since I truly believe in modern media like Twitter and sharing knowledge via the Web this one has to be put out here as well. As always  you have to investigate if my approach can be yours as well. And as a quote that I have learned on the web, never regard every challenge as a nail requiring only a hammer.

One main point I have to make is that the complete set up was performed using sqlplus . I did not use the broker at first when setting things up. And as often once you choose a direction .. Looking back now and reading posts on twitter it would have been an interesting twist to do the same while using the broker. Maybe that can be your challenge and after that there will be a nice blog coming  from that too then.

Happy Reading,


My Implementation of a logical Standby Database