Explore >> Select a destination
|
You are here 
|
jonathanlewis.wordpress.com | ||
| | | | |
savvinov.com
|
|
| | | | | In this post, I continue on the topic of examining SQL plans. I will talk about one DBMS_XPLAN function, DISPLAY_CURSOR (because it's probably the most useful one when troubleshooting ongoing performance issues, and also because other functions have a lot of similiarity to it). I will discuss frequently used options and some common problems. Preparation... | |
| | | | |
datubazes.wordpress.com
|
|
| | | | | SQL teikumu izpildes pl?ns (query execution plan) - kur? gan nopietni interes?joties par datub?zu izstr?di t?du terminu nav dzird?jis? Vaic?jums l?ni str?d? - paskaties izpildes pl?nu! Tiesa gan vairum? gad?jumu tiek pa?as par sevi pie?emtas divas (varb?t pat tr?s) lietas: persona zin, k? izpildes pl?nu dab?t; persona zin, ko ieg?tais izpildes pl?ns noz?m?; persona zin,... | |
| | | | |
tonyhasler.wordpress.com
|
|
| | | | | When a table is accessed by multiple members of a parallel query server set, the execution plan may show the use of block range granules (PX BLOCK ITERATOR) or partition granules (PX PARTITION [RANGE|LIST|HASH] ITERATOR or PX PARTITION [RANGE|LIST|HASH] ALL). The basic ideas surrounding these concepts are discussed in numerous blogs and books, including my... | |
| | | | |
tonyhasler.wordpress.com
|
|
| | | Note that there is a follow up to this post here that you should read after this post. Stored outlines were introduced in Oracle 9i as a way of helping stabilise execution plans. In 11gR1 these are deprecated in favour of enterprise-edition-only SQL Baselines (sorry standard edition users )-:) but as of 11gR2 neither facility... | ||
