Oracle database internals by Riyaj

Discussions about Oracle performance tuning, RAC, Oracle internal & E-business suite.

Presentations at SIOUG and DOUG

Posted by Riyaj Shamsudeen on November 6, 2008

I recently traveled to Europe to present at a few conferences. The Slovenia Oracle User Group (SIOUG) conducted an Oracle conference in Portoroz, a port city in Adriatic Sea.

Thanks to my friend Joze Senegacnik, I had wonderful time in Slovenia. We also visited the city of Venice while we were there. Of course, we all knew that Venice is the city of bridges—over a hundred small islands connected by bridges. But visiting Venice in person had a dramatic effect on us. We were mesmerized by the beauty, culture, and architecture, in particular the Basilica of St.Mark. Venice is indeed the Queen of the Adriatic.

Back to reality. I presented a few papers for the Dallas Oracle Users Group (DOUG) for their October tech meeting too. All these papers can be accessed following these links:

1. Performance specific new features in 11g

2. Battle of the nodes: RAC Performance myths

3. Cost Based Query Transformations

4. Performance tuning: Scientific approach to bottleneck identification

Also, if you are planning to attend the UKOUG Conference & Exhibition in December, please attend my presentation on “Cost based query transformation” on Thursday of that week.

4 Responses to “Presentations at SIOUG and DOUG”

  1. reader said

    just went over your presentation on “RAC performance myths”. Excellent..just no other word to describe.

    Please keep up the good work

  2. Hi
    Thank you very much for reading my blog and your kind words.

    Cheers
    Riyaj

  3. k_roy said

    Riyaj,

    Your papers were a great read. Thank you for your contributions.

  4. Hi Riyaj,

    Thanks for the RAC presentation.

    There is one more aspect to LMS/LGWR apart from high priority. Since you have shown examples specific to solaris (priocntl/psrset), you would also benefit from increasing the time-quanta to these processes (LGWR/LMS). FX class would be sufficient and not probably require to be changed to RT class. By changing time-quanta, you can eliminate involuntary context switches completely.

    On Linux, changing the priority automatically increases the time-quanta available for a process.

    Thanks
    Krishna Manoharan

Leave a reply to reader Cancel reply