New Features for DBA’s

Subscribe to Posts by Email


 

Subscriber Count

    699

Disclaimer

All information is offered in good faith and in the hope that it may be of use for educational purpose and for Database community purpose, but is not guaranteed to be correct, up to date or suitable for any particular purpose. db.geeksinsight.com accepts no liability in respect of this information or its use. This site is independent of and does not represent Oracle Corporation in any way. Oracle does not officially sponsor, approve, or endorse this site or its content and if notify any such I am happy to remove. Product and company names mentioned in this website may be the trademarks of their respective owners and published here for informational purpose only. This is my personal blog. The views expressed on these pages are mine and learnt from other blogs and bloggers and to enhance and support the DBA community and this web blog does not represent the thoughts, intentions, plans or strategies of my current employer nor the Oracle and its affiliates or any other companies. And this website does not offer or take profit for providing these content and this is purely non-profit and for educational purpose only. If you see any issues with Content and copy write issues, I am happy to remove if you notify me. Contact Geek DBA Team, via geeksinsights@gmail.com

Pages

Performance Troubleshooting Series : Identifying or Estimating How much PGA needed by Session/Query

Have got a question from one of fellow DBA that how much PGA the session will use or needed.

Well to answer this, first we need to know what PGA looks like and what it used for?

The follow shows the components of a PGA, the little space used for Stack, Env Variables and Private […]

May 24th, 2016 | Tags: , , | Category: 12c Database | Comments are closed

Performance Troubleshooting Series: Query Parsing & Execution Times

As we all know, optimizer parse the statement to provide a plan, but to provide that Oracle Optimizer has to go through different phases called Parse, Execute, Fetch.

1. Parsing has three phases again,

Compiler: Compiles the statement to oracle readable format or oracle understandable state.

Estimator: Look out the […]

May 24th, 2016 | Tags: , , , | Category: 12c Database | Comments are closed

Configuring RAC on Amazon Cloud

Hello All,

This post is specifically for those who works on Amazon Cloud and want to build a RAC on Amazon EC2 Instances (machines).

There is a very good article in the AWS Documentation Articles (here), but the linux instances taken and built were very large and per hour it cost around 4$ each […]

May 15th, 2016 | Tags: , , , | Category: 12c Database, AWS | Comments are closed