Oracle database Internal Mechanism

This blog Oracle Database Internal Mechanism is solely intended to share oracle internals with the fraternity.

During our journey as a DBA (specially during the initial stage), we struggle a little with understanding the internals of Oracle even when there are tons of documents, white papers, articles, presentations etc just because it’s very difficult to understand the internals as it gets complicated once we dig deeper. But we noticed that once you get past that, the internals are very interesting to learn and also  provides an added advantage dealing with various complicated issues.

Hence comes this blog, here we write posts covering interesting topics on Oracle Database explaining the internals BUT in as simple manner as we can so that the reader can get the flavour of the concept and thus can generate interest to go through the documentation part, thus making a boring documentation to an interesting article.

Please comment below if you want our authors to cover any topic for which you are interested to know the internals.

Also every reader has the right to ask questions on the post no matter how basic or complicated the questions is, and we’ll try our best to come back with a satisfactory answer.

  1. Himanshu says:

    Really nice blog, many thanks for sharing the knowledge.

    God bless you

    Liked by 1 person

  2. mohd mudassir ahmed khan says:

    nice blog nitish thanks alot … please do share some interview questions and answers. And some topics like 1}Undo & FB-Qry & FB-Table & FB-Version Qry 2}RMAN 3} DATA GUARD CLONING 4} ASM ….Sorry if i am asking more thank u in adnavce..!!!

    Liked by 1 person

    • Hi Mudassir,

      Thanks for reading the blog, really glad you liked it.

      Regarding your topics I’ll surely include those in my To-Do list. Some of which are already in my draft. so I guess soon you’ll see that published in this blog.


  3. sagar says:

    Thanks Nitish.

    please share some post on 12c. which will help us for improve new DB version knowledge.

    Liked by 1 person

  4. Markus says:

    Hi Nitish, greetings from Germany🙂
    Nice pages ! Will definitely go through them.

    Liked by 1 person

  5. Sagar says:

    Hi Nitish,

    Please share some post on RAC Q&A. and also share more interesting 12c administrative features. Thanks

    Liked by 1 person

    • Hi Sagar,

      Working on the 12c administrative features so you’ll get some of those very soon, but regarding RAC Q&A have put them on my list but that can take time.

      Thanks for reading.



  6. Hadley says:

    Hi Nitish,

    Your post all very helpful already since you asked here I’d like you to post performance-related pieces of stuff. Here we people are using EBS application though its application, 90% of performance is related how the database is tuned right.

    For example, (in 11gr1/r2 databases)

    1. Going for AMM parameter is good or wrong ? any other suggested parameters ?
    2. Adding /*+ RESULT_CACHE */ in query really works?
    3. Using parallel execution in a query really works?
    4. In what scenario we use AWR, ASH and ADDM reports ? and how to use.
    5. and so on..

    Thanks in advance for the consideration.

    T.A Hadley

    Liked by 1 person

  7. AR says:

    Hi Nitish,
    I’m so interested on this subject.
    Congratulations for the initiative.

    Liked by 1 person

  8. aamir says:

    Nitin, the work you are doing is awesome, I am interested in more details on listner issues we face every day. Thanks

    Liked by 1 person

    • Hi Aamir, Thanks for your words.
      We would try to cover the day-to-day issues regarding listener, tns etc as soon as possible.
      Meanwhile if there are any specific errors, please feel free to comment and we would try to provide the troubleshooting guidelines.



  9. Luz says:

    Wow! You rock!!! Thanks a lot for your sharing. I went through Dataguard docs.

    Liked by 1 person

    • Hi Luz,

      Thanks for your words, happy to know the docs helped, please feel free to comment if in case you face any issues during your chase with dataguard and we’ll try to assist you on the same. This way others would also benefit.



  10. Prasanth says:

    I had read your 12c post which was very helpful.

    Can you share any docs on explain plans to identify costly operations and how to resolve them

    Liked by 1 person

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s