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
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 220.127.116.11 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 18.104.22.168.0.
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 22.214.171.124 with ASM. As part of sharing information below are the steps I performed with some add-on comment.
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,
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.
My Implementation of a logical Standby Database