Enter your query, example: how not cry when slicing onion or how to enter an Free Italian Sex Webcams?
Home » Video » ...

Tkprof explain plan Videos

Review Actual Plan with DBMS_XPLAN.DISPLAY_CURSOR PART-2

Review Actual Query Execution Plan Using DBMS_XPLAN.DISPLAY_CURSOR PART-2 covers Set up & view execution plan using Display_Cursor. Overview ...

User Comments

https://gp6.googleusercontent.com/-G5AkUf8Yc7Q/AAAAAAAAAAI/AAAAAAAAAAA/suHP9vaCvrw/s48-c-k-no/photo.jpg?sz=64
Anindya Das commented on 24 Sep 2013
In execution plan, the execution starts at right most operation in operation field. Suppose in 1st step some operation spent 5 second. In A-Time it will show 5 seconds. Then in 2nd step some operation spent 55 seconds. So for this A-Time will show 5+55=60 seconds. Then in 3rd step some operation spent 30 seconds. So for this A-Time will show 60+30=1 min 30 seconds.. In this way its cumulative.While using gather_plan_statistics hint, its may not show A-time properly. Thanks. @Himangsu
https://gp4.googleusercontent.com/-Dbk6ZjvkGug/AAAAAAAAAAI/AAAAAAAAAAA/ZKhkgEQS5r0/s48-c-k-no/photo.jpg?sz=64
Himansu Pathak commented on 24 Sep 2013
What do you mean by cumulative value of A-time ?( around 8:00 min)
https://gp3.googleusercontent.com/-LvECpkfg8DE/AAAAAAAAAAI/AAAAAAAAAAA/vWJW4GdMOsY/s48-c-k-no/photo.jpg?sz=64
Anamika Roy commented on 24 Sep 2013
Very well explained..covers lots of detail

Oracle SQL Tuning - Data Warehouse Star Transformations, Even with Standard Edition!

Joining large tables in a Data Warehouse will often generate star transformations in the execution plan. So, what is a star transformation? And, what if you don't ...

Viewing executions plans in Oracle database - Hebrew presentation by Eran Koren

In this hebrew presentation I show some of the ways to view execution plans of SQL statements in Oracle: * Autotrace in SQL*Plus * DBMS_XPLAN procedures ...

Oracle SQL Plan Monitoring - Hebrew - ניטור תכניות פעולה באורקל

אחרי שבשיעור הקודם ראינו כיצד ניתן לקבל תכניות פעולה ב-Oracle, השיעור השני בסדרה מציג את היכולות שלנו לנטר את...

Oracle Cost Based Optimizer Advanced Session

Presented by Randolf Geist 01 August 2012 Summary Building on the previous Cost-Based Optimizer Basics webinar, in this almost "zero-slide" session we'll ...
Sign up for free to join this conversation on fsaved.com.
Already have an account? Sign in to comment