estimated rows vs actual rows
Hi,
I know that query explain plan shows the phases the CBO guess it has to go through and also shows the number of estimated rows(guesstimate) before the actual query execution.
Is there any way , I can get one to one mapping of the :
This will help us to know what and where execution went wrong during the query execution.
I know that oracle support can find out the same help of any of the following tools : SQLT or TRACE( 10046 or 10053 )
If anyone knows where and how please let me know !!!!
I know that query explain plan shows the phases the CBO guess it has to go through and also shows the number of estimated rows(guesstimate) before the actual query execution.
Is there any way , I can get one to one mapping of the :
- actual steps andthe CBO actually went after the execution of the query.
- actual rows
This will help us to know what and where execution went wrong during the query execution.
I know that oracle support can find out the same help of any of the following tools : SQLT or TRACE( 10046 or 10053 )
If anyone knows where and how please let me know !!!!
0