0 Shares 0 Facebook 0 Twitter 0 Linkedin 0 Facebook-messenger 0 Whatsapp 0 Email By Francisco Munoz Alvarez Important points about LOGGING and NOLOGGING Despite the importance of the redo entries, Oracle gave users the ability to limit redo generation on tables and indexes by setting them in NOLOGGING mode. NOLOGGING affect the recoverability….
Month: July 2008
Australia 2008 National Conference Series
0 Shares 0 Facebook 0 Twitter 0 Linkedin 0 Facebook-messenger 0 Whatsapp 0 Email I’m pleased to confirm that my paper ” Logging or Nologging: That is the Question!” submitted to the Perth and Gold Coast conferences was accepted. See you at: October,6 and 7 – AUSOUG National Conference Series at Perth, AU October,13…
What I need to know to become a DBA?
0 Shares 0 Facebook 0 Twitter 0 Linkedin 0 Facebook-messenger 0 Whatsapp 0 Email About the DBA job: 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. After all,…
LOGGING or NOLOGGING, that is the question – Part II
0 Shares 0 Facebook 0 Twitter 0 Linkedin 0 Facebook-messenger 0 Whatsapp 0 Email By Francisco Munoz Alvarez Redo Generation and Recoverability The purpose of redo generation is to ensure recoverability. This is the reason why, Oracle does not give the DBA a lot of control over redo generation. If the instance crashes, then…
LOGGING or NOLOGGING, that is the question – Part I
0 Shares 0 Facebook 0 Twitter 0 Linkedin 0 Facebook-messenger 0 Whatsapp 0 Email By Francisco Munoz Alvarez Introduction The main question about NOLOGGING I hear all the time is: does creating a table with the NOLOGGING option means there is “no generation of redo ever”, or just that the initial creation operation has no…