Subscribe to Posts by Email

Subscriber Count

    696

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

Oracle Cursor Sharing Examples

In the previous post we discussed about the Parent & Child Cursors in Oracle and how do they work or shared.

To get into deeper, Oracle controls the sharing of cursors with parameter called cursor_sharing. It has three values

EXACT SIMILAR FORCE

In this post we will create a table which has some records with […]

Shared Pool: Parent & Child Cursors in Shared Pool

What are PARENT AND CHILD CURSORS IN ORACLE

A cursor is a memory area in library cache allocated to a SQL statement which stores various info about the SQL statement like its text, execution plan, statistics etc.

Each SQL statement has

One Parent cursor One or more child cursors

PARENT CURSOR

It […]

Turn off or disable the adaptive cursor sharing in 11g

Adaptive cursor sharing as you all aware , This was introduced in 11gR1 to address issues related to bind variable peeking. See support note 740052.1 and documentation for details.

You may have weird behaviors of your sql’s after upgrade to 11g , this may be due to no proper testing done, or optimizer features […]

Adaptive Cursor Sharing: What is Adaptive Cursor Sharing?

The following is the direct extract from the documentation on adaptive cursor sharing.

The adaptive cursor sharing feature enables a single statement that contains bind variables to use multiple execution plans. Cursor sharing is "adaptive" because the cursor adapts its behavior so that the database does not always use the same plan for […]

Change in LGWR behavior , living with beast or best?

If you are experiencing the log file sync wait after an upgrade to 11.2.0.3 and most importantly that as there are no other symptoms of issues with I/O or in other areas, the problem could be with excessive switching between post/wait and polling wait methods.

While writing previous post, came across the another interesting note […]

Quiz Post #10: What are the meanings for different letter for awr base tables WR#

Oracle 10g provides the Automatic Worload Repository. The AWR is a repository of performance information collected by the database to aid in the tuning process for DBAs. The main focus for the Oracle database in version 10g is self-manageability. AWR is  the place where the data to aid in self-management is stored.

WHAT DOES […]

11g SQL Monitoring: Real Time sql monitoring

All,

I have got a chance to speak about this nice cool feature in an other practical demo session to my colleagues, but few questions on the same remind to post and read something on this.

Typically as usual my post flow, What, How, How to, Important note?

What is SQL Monitoring?

If a query […]

Performance Tuning: Oracle Top Wait events, Causes, Resolutions

Hello,

In case you want to know more about Oracle Wait events please read here

What are the causes for those wait event and how you can troubleshoot and resolve the same was neatly written in this document.

This document is very good, structured (apologies I do not remember the source and who written it,  […]

Dynamic Sampling: Use,Levels,10g-11g behavior,

We all know that Oracle Optimizer use object statistics to determine the cost of accessing that object. What if, if that object has missed statistics or the columns or the

Hence Oracle introduced Dynamic sampling in 9i and has changed significantly through 11g.

Definition:-

Dynamic sampling augments missing or insufficient optimizer statistics. Using dynamic sampling […]

Cardinality Feedback: What is it? When it will be used? 10g vs 11g

What is cardinality?

CBO estimate of the number of rows produced by a row source or combination of row sources.

What are different types of cardinality?

Cardinality

Cardinality represents the number of rows in a row set. Here, the row set can be a base table, a view, or the result of a join […]