It was a long journey of hard work and team work that now has finished, as a result you will find my book Oracle Database 12c Backup and Recovery Survival Guide that I wrote with the help of my good friend Aman Sharma. I would also take this opportunity to recognize the great work done…
Category: Interview Tips
Some very Good Interview Tips and Example of possible questions you can be asked on a real job interview
Once again, How to Improve your Oracle Career
The main question about the DBA job I hear all the time is: How can I became a successful DBA? Most of the people that I talk to who have difficulties starting out in their DBA career really have an issue trying to absorb the mountainous volumes of information that a DBA needs to know…
LOGGING or NOLOGGING, that is the question – Part VIII
By Francisco Munoz Alvarez How to find Sessions Generating Lots of Redo To find sessions generating lots of redo, you can use either of the following methods. Both methods examine the amount of undo generated. When a transaction generates undo, it will automatically generate redo as well. The methods are: 1) Query V$SESS_IO. This view…
How to migrate from 32 bit to 64 bit using RMAN?
This procedure can be used for single instance or RAC (9i to 11g): In the 32 bit source server : Start making a full backup of the database including all archivelogs: RMAN> run { allocate channel c1 type disk; allocate channel c2 type disk; backup database plus archivelog; backup current controlfile; } In the target 64 bit server:1)…
Learning and Preparing to a DBA Interview
“The main idea of this article is to help you to prepare to an Oracle DBA Interview and at the same time help you to learn and understand the most important basic points that a good Oracle DBA need to know. “ Advice: Be brief and stick to the topic in your answers. The interviewer will ask…