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 flavor of the concept and thus can generate interest to go through the documentation part, thus making a boring documentation 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.
Disclaimer:- The opinions expressed here are mine and mine alone. They may not necessarily reflect that of my employers and customers – both past or present. The comments left by the reviewers are theirs alone and may not reflect my opinion whether implied or not. None of the advice is warranted to be free of errors and omission. Please use at your own risk and after thorough testing in your environment.
Really nice blog, many thanks for sharing the knowledge.
God bless you
LikeLiked by 1 person
Many Thanks for your words, and Glad it helped.
LikeLike
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..!!!
LikeLiked 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.
LikeLike
Thanks Nitish.
please share some post on 12c. which will help us for improve new DB version knowledge.
LikeLiked by 1 person
Thanks Sagar,
The good news is I have few posts in draft on 12c, so hopefully would give you couple of interesting articles to read on the same.
LikeLiked by 1 person
Hi Nitish, greetings from Germany 🙂
Nice pages ! Will definitely go through them.
Cheers
LikeLiked by 1 person
Hey Markus,
It got your attention, mission successful…
Regards
Nitish
LikeLike
Hi Nitish,
Please share some post on RAC Q&A. and also share more interesting 12c administrative features. Thanks
LikeLiked 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.
Regards
Nitish
LikeLike
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.
Regards,
T.A Hadley
LikeLiked by 1 person
Hi Hadley,
Thanks for reading, point noted, would share a series of posts covering these performance tuning aspects soon, STAY TUNED.
Regards
Nitish
LikeLike
Hi Nitish,
I’m so interested on this subject.
Congratulations for the initiative.
Regards,
AR
LikeLiked by 1 person
Thanks for reading, glad you sound this interesting.
Let me know if there is any topic in particular you want us to cover.
Regards
Nitish
LikeLike
Nitin, the work you are doing is awesome, I am interested in more details on listner issues we face every day. Thanks
LikeLiked 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.
Regards
Nitish
LikeLike
Wow! You rock!!! Thanks a lot for your sharing. I went through Dataguard docs.
LikeLiked 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.
Regards
Nitish
LikeLike
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
LikeLiked by 1 person
Hi Prasanth,
Thanks for reading, good to know you find these helpful.
For explain plan, I have written a post on how to interpret explain plan:-
https://nitishanandsrivastava.wordpress.com/oracle-database-internals/interpreting-an-explain-plan/
LikeLike
need more information about Oracle High availability Architecture (OHA)
LikeLike
Excellent write up, helps understand the internals so easily and generate interest to learn more.
Do you provide coaching ?
LikeLike
Thanks Shalini, good to know that this generated your interest in learning further, that was the intention behind this blog. And no I do not provide any coachings or trainings and I have no intention to do so too. The best coaching you can get is through your own lab and Oracle documentation.
LikeLiked by 1 person
Hi Nitish,
Great blog, good to know the internals, how does they work.
Could you please also share RMAN internals.
LikeLiked by 1 person
Hi Shankar,
Adding RMAN Internals to the list, stay tuned
LikeLike
Excellent Blog… Got to know a lot of cool stuff… Keep posting.
LikeLike
Hi Vivek, Thanks for stopping by, glad it helped.
Keep Learning…!!!
LikeLike
Great Blog Man, you rock…!!!!!
LikeLike
Thanks Shashank 🙂
LikeLike
Hi Nitish,
Appreciate your work, these posts are really helpful.
Could you please cover ASM too.
LikeLike
Thanks, I have a draft on ASM, I’ll finalize that and share soon… Stay Tuned…
LikeLike
Excellent blog.
LikeLike
Thanks
LikeLike
Hi Nitish,
Your posts on Oracle RAC are awesome…!!!! Please keep posting…
LikeLike
Thanks, stay tuned for some posts on 12c RAC
LikeLike
Just read your posts on Datapump, you have got yourself a new follower. 🙂
LikeLike
Thanks
LikeLike
Nice for including different Database technologies.. please try to add PostgreSQL, if possible.
LikeLiked by 1 person
Thanks for sharing your knowledge it helped me lot ..
LikeLiked by 1 person
Hello Nitish,
It’s wonderful to read your blog, thank you for spending your precious time to sharing the knowledge to the world.
Could you please make detailed article on reading the AWR report in depth which would help DBA’s to figure out the daily performance issues.
Thank you & Regards,
Naveen Singh
LikeLiked by 1 person
Very nice document Nitish … Please add some more documents….waiting eagerly.
LikeLiked by 1 person
Hi you have a user friendly site It was very easy to post easy to understand
LikeLiked by 1 person
Hi you have a fine website It was very easy to post it’s nice
LikeLiked by 1 person
You, my friend, are a life saver!!! I love how you explain things!
LikeLiked by 1 person
Hi Nitesh ,
This blog is really good , however after AUg 21 i didn’t see much updates on it.
Actually i was excepting oracle 19c and 21c info and more on SQL Server.
I hope this site will get updated very soon.
LikeLike