/explore
|
You are here 
|
tanelpoder.com | ||
| | | | |
rwijk.blogspot.com
|
|
| | | | | ||
| | | | |
www.dbaglobe.com
A blog about on new technologie. Hands-on note about Hadoop, Cloudera, Hortonworks, NoSQL, Cassandra, Neo4j, MongoDB, Oracle, SQL Server, Linux, etc. |
|
| | | | | ||
| | | | |
jonathanlewis.wordpress.com
[More on dbms_xplan.display_cursor()] If you're using 9i and haven't learned about the dbms_xplan package, then you should take a good look atit right away. It's(usually) a much better wayof getting execution plans from your system thanwriting yourown queries against the plan_table. If you'vebeen using dbms_xplan, and upgraded from 9i to 10g, make sure that you... |
|
| | | | | ||
| | | | |
dioncho.wordpress.com
I hit following OTN forum article which was a discussion on typical SQL sharing problem. There are so many reasons why Oracle does not share the same statement. Oracle records the reason in v$sql_shared_cursor view. In my local 10.2.0.1 database, v$sql_shared_cursor has 53 reasons of unshareability. But I have a big complaint on v$sql_shared_cursor view.... |
|
| | | |||
