Coskan’s Approach to Oracle

December 31, 2009

Summary for 2009, Plans for 2010

Filed under: Diary — coskan @ 5:44 pm

2009  was a bit silent year for me I did not find interesting topics to write, but I read too many interesting and new topics as you follow from blogroll report posts and book reviews. I think I did a good job with blogroll reports  by them. I now have a very nice indexed Oracle Blogosphere for half of 2009. Blog reached over quarter million hits (when I say 250 000 it is not looking that big 🙂 )  with average 400 visits a day.   By your support,  blog provided over 2500 gallons of clear water for people around the world,  I want to thank you all who visited and supported the social vibe link at the bottom of the page.

From career perspective, In 2009 I mostly focused on performance tuning and backup recovery.  I fully understood how Oracle Engine works in terms of performance management. I quit using TOAD and started to use sqlplus for %90 of my daily routine. I love  Toad but i can’t stand slowness of it and after Tanel Poders script library plus my own scripts I find it far more easy to use sqlplus.

Because of dealing with performance,  I started to be  more  obsessive about anything running slow and this obsessiveness made me quit Windows OS  start using Ubuntu 9.10 Karmic Koala as desktop. After 3 months of usage, I am quite happy about my decision. By Running Ubuntu on  my new Quad Code CPU and 8GB ram desktop I can say that I now have my dream speed and lab. Migration was not painful as much as I expected I can do 95% + more of the things I was able to do on windows,  I  wish I have the same option with the laptop I am using for job but no chance.

I also quit firefox and sage rss reader and start using chrome as browser  and google reader as reader with igoogle I highly recommend this combo to all of you.

For networking , I am still a bit shy when it comes to socializing at user group events. Normally I am a very social bloke, but I have a problem of introducing myself at meetings 😦  it is something i need to work on harder.

I always had a fear of giving  presentation even in Turkish and to sort  this problem, I got a course for presentation skills in 2009 and I learned all the tricks of a good presentation. I also did a presentation at the course and  I proved to myself that I am able to do presentation in English.  Now I need a good topic to prepare a presentation to test my new skills.

I think thats about it for 2009 summary, and  now it is time to talk about 2010 plans.

For the blog, I am planning to share more information in this blog from the sources I follow and read and from my own researches on top of them. I  want to write a tool maybe a plugin for swingbench to generate common performance problems for new DBAs to test their troubleshooting skills. I also want to write  possible crash  recovery scenarios series.

For Oracle knowledge, I plan to learn Streams and Analytic functions. It is a shame for me that I never really cared much about these two.

For the books,  I plan to read the ones below and I hope upcoming Apple Tablet will be affordable price to be my ebook reader.  I wish I will finish at least half of them.

  • Practical Oracle 8i from Jonathan Lewis– I am in the middle of this book and what I discovered so far is that most of the information Jonathan shares from his blog is based on this book. I can say it is a must.
  • Expert Oracle Practices Oracle Database Administration from the Oak_Table– I read two chapters so far and to be honest it is not as good as I expected but book is in alpha stage so my thoughts can still change.
  • Scaling Oracle 8i by James Morle
  • SQL Tuning by Dan Tow
  • Relational Database Index Design and the Optimizers by Tapio Lahdenmaki and Michael Lech
  • RMAN Recipes for Oracle Database 11g by Darl Kuhn , Sam R. Alapati , Arup Nanda
  • Oracle Data Guard 11G Handbook by Larry Carpenter , Joseph Meeks , Charles Kim , Bill Burke , Sonya Carothers , Joydip Kundu , Mike Smith , Nitin Vengurlekar
  • Linux Recipes for Oracle DBAs by Darl Kuhn, Charles Kim, Bernard Lopuz
  • Secrets of the Oracle Database by Norbert Debes
  • Oracle Automatic Storage Management: Under-the-Hood & Practical Deployment Guide by Nitin Vengurlekar , Murali Vallath , Rich Long
  • Pro Oracle Database 10g RAC on Linux: Installation, Administration, and Performance by Julian Dyke , Steve Shaw

I never be active enough at Oracle Forums and Oracle-L and they are also on top of my to-do list this year.

For linux desktop , I need to get used to use vi for every kind of text editing and because I don’t have system admin group luxury at home, I need to learn more about managing linux as a system admin.

I will start to give internal presentations to my team mates if it works maybe you can watch a presentation of me after second half of the year.

Well these are my plans of 2010 and I hope next year on 31st of December I will still be here and telling you that all of my plans went well.

Wish you and for the ones you love,  a very good year.


  1. Wow! Many books to read.

    Enjoy & Happy New Year 😉

    Comment by Surachart Opun — December 31, 2009 @ 6:31 pm

  2. nice article

    Comment by Paresh Sarma — December 31, 2009 @ 7:12 pm

  3. May be you forgot or finished reading book “Troubleshooting oracle performance”

    Comment by Taral Desai — December 31, 2009 @ 9:04 pm

    • I already read and review it but it is also in my list to re-read:)

      Comment by coskan — December 31, 2009 @ 9:47 pm

  4. Happ news year too Coşkan.
    I’m surprised about How do you find time to do all this work.I’m sure that time management is very important for you and you have some methods To use time efficiently. Maybe you should write an article that mentioned it.
    See you Take care

    Comment by Ümit — January 1, 2010 @ 12:29 pm

    • Thanks Umit. I can find time because I can do parallel processing and also by using right and lightweigt tools for daily operations and keyboard shortcuts I probably save at least one two weeks total of time in a year. sometimes sums of seconds can add huge amount of times in a year time.

      I also continue work at home as well. You need to sacrifice from your private life for being good enough

      Comment by coskan — January 2, 2010 @ 5:18 pm

  5. Hi Coskan,

    you’ve got nice book list here – it goes in my bookmarks as must read.

    I can recommend “RMAN Recipes for Oracle Database 11g” as the best RMAN related book. This book comes in top 5 books for me – always available on desktop as reference 😉

    I wish you happy, healthy and successful new year…


    Comment by Marko Sutic — January 1, 2010 @ 9:49 pm

  6. “I quit using TOAD and started to use sqlplus for %90 of my daily routine.”

    You are almost in my camp. Try 100%.

    Comment by Hemant K Chitale — January 2, 2010 @ 4:10 pm

    • Thanks for stopping by Hemant. I use Toad only when Toad fans are around at job and sometimes I really find it very handy to get the ddls but I think I am getting used to sqlplus maybe next year it will be %100.

      Comment by coskan — January 2, 2010 @ 5:14 pm

  7. Happy new year Coskan.
    The blogroll reports are great – thanks.
    We share a few goals for the coming year – presenting to co-workers being one of them (English being my only option ). Perhaps if we both manage that one for 2010 we may catch each other “up front” at a UKOUG SIG in 2011 🙂
    Jonathan Lewis’ Practical Oracle 8i is a great book and was a watershed moment for me.
    Good luck with the resolutions for the coming year.

    Comment by Neil Johnson — January 3, 2010 @ 11:51 am

  8. Hi Coskan,

    Happy New Year to u too. Thank’s for sharing the book list.

    Streams and analytic functions ..Even i need to read these..but not sure if it makes sense to read Streams or Goldengate replication ..


    Comment by Amit — January 3, 2010 @ 1:14 pm

  9. Coskan,

    I really appreciate your effort of doing blogroll. I think it is an asset to our Oracle communities. Good luck with 2010 plan.


    Comment by Ittichai Chammavanijakul — January 4, 2010 @ 5:41 pm

  10. Happy new year

    for the book “Expert Oracle Practices by oak people”, chapters 8 and 9 are really great.

    Comment by Kostas Hairopoulos — January 15, 2010 @ 2:49 am

  11. Hi,

    As you said you use tools to reduce time .. can you name some of the tools you use for performance tuning and for administration .

    How to get the tools which you recommend 🙂



    Comment by Balakrishna — January 15, 2010 @ 3:27 am

    • I personally use nearly all of the Tanel Poder Scripts they are really time saver and I heard that he is working on mother of all tuning scripts script.

      I use OEM for tuning if I have license for tuning pack

      I also use scripts from certain guys like Riyaj Shamsudeen and Kerry Osborne.

      Charles Hooper shares very nice tools running with vbs.
      I was using Quest Performance Analyzer but I really feel more faster and powerfull when I am on command line and sqlplus. I think Embercado technologies produce decent performance tools as well

      For statspack I use Tanels Perfstat Sheet
      and Tim Gormans scripts for statspack analyzing

      Thats all I can say

      Search for the names I mentioned and chek their own websites for the scripts / tools

      Comment by coskan — January 15, 2010 @ 11:20 am

  12. Good post. I learn one thing tougher on completely different sites everyday. It’s going to at all times be stimulating to read content material from other writers and apply a bit of something from their store. I’d desire to use some with the content on my site. whether or not you don’t mind. Natually I’ll provide you with a link back to ironwork

    Comment by CoiscexClasia — April 25, 2011 @ 3:43 am

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Blog at

%d bloggers like this: