Posts Categorized: Technical Blog
I have experienced a handful of Oracle’s replication solutions as far back as version 5 of the database in the mid to late 1980′s. Will GoldenGate be the golden gate? If one ends up answering in the affirmative to most of the following questions, I think so.
Use NOLOCK hint to avoid block – this is what I have often heard/see in many forums I participate in, during local user group events and meetings. I have always advised that its not that good idea to use hints, as it may cause data corruption and blocking. And anyways, there are many things that you can do to avoid blocking, like:
For the final day of UKOUG there are quite a few Pythian presentations. Unfortunately a lot of them happen at the same time, so it won’t be possible to attend them all live.
On tap for Tuesday is a 2-hour master class from Michael Abbey, along with an all-day drop-in RAC attack workshop with Alex Gorbachev and the RAC SIG.
Another December has started and you know what it means right? It’s the Christmas time? NO! It’s time for UKOUG Technology and e-Business Suite 2011 conference! There are not many things that can make a passionate Apps DBA more excited than that. UKOUG Tech & eBS conferences are the only ones in Europe that have such a rich content for Application DBAs and this year it will not be different.
I have seen lots of questions floating in the msdn forums about SSPI Handshake error, the main question is around error code 0×80090311 which is indicative of the authentication failure error. Apart from this, there are many other reasons for SSPI Handshake error to appear in error logs. I cover them here.
For those of you attending UKOUG today, there is a healthy dose of Pythian presentations on tap this afternoon. Actually, you can do it wall to wall 2:30pm to 6:30pm if you like.
Off to the UKOUG general session then a fun-filled day of presentations. It wraps up later this afternoon with my rman best practices event at 5:45pm.
I would like to share some of my tips/notes about patching Oracle Exadata, based on my experiences and not less important, research and googling.
In this blog, I am going to demonstrate how we can use the wait event category sqlos.wait_info* to track the wait resources the queries running in a particular session undergo.