Explore >> Select a destination
|
You are here 
|
jhdba.wordpress.com | ||
| | | | |
blog.yannickjaquier.com
|
|
| | | | | SQL Plan Management feature overview through concrete example and its interactions with Adaptive Cursor Sharing (ACS) and SQL Profile | |
| | | | |
carlos-sierra.net
|
|
| | | | | If you have access to some other graphical tool that displays time series on multiple dimensions for one or a set of SQL statements from an Oracle database, then you may not need "SQL Stats Analytics". In the other hand, if you have no such tool, or even more restricting, if you can only access... | |
| | | | |
jonathanlewis.wordpress.com
|
|
| | | | | Here's a little thing that Dan Morgan mentioned to me some time ago. It's a little routine from a package (owned by sys) that appeared in 11.2.0.3 that gives you some idea of the mess hidden behind a query that uses views. The procedure is called dbms_sql2.expand_sql_text and it takes two (CLOB) parameters: an IN | |
| | | | |
jonathanlewis.wordpress.com
|
|
| | | Here's a simple detail about bind peeking (during optimisation) that makes a big difference to "fetch first/next" queries. The optimizer knows about your bind types, and can peek at the bind values - but that doesn't mean it will do something sensible with them. Here's a little model to demonstrate the problem - starting with... | ||
