carlos-sierra.net/2013/06/17/using-dbms_xplan-to-display-cursor-plans-for-a-sql-in-all-rac-nodes

Preview meta tags from the carlos-sierra.net website.

Linked Hostnames

11

Thumbnail

Search Engine Appearance

Google

https://carlos-sierra.net/2013/06/17/using-dbms_xplan-to-display-cursor-plans-for-a-sql-in-all-rac-nodes

Using DBMS_XPLAN to display Cursor Plans for a SQL in all RAC nodes

Just sharing a lightweight script that uses DBMS_XPLAN.DISPLAY_CURSOR to display Execution Plans for a given SQL_ID out of all RAC nodes. Nothing fancy, just a workaround to the lack of "instance" parameter on this API. Sample Output



Bing

Using DBMS_XPLAN to display Cursor Plans for a SQL in all RAC nodes

https://carlos-sierra.net/2013/06/17/using-dbms_xplan-to-display-cursor-plans-for-a-sql-in-all-rac-nodes

Just sharing a lightweight script that uses DBMS_XPLAN.DISPLAY_CURSOR to display Execution Plans for a given SQL_ID out of all RAC nodes. Nothing fancy, just a workaround to the lack of "instance" parameter on this API. Sample Output



DuckDuckGo

https://carlos-sierra.net/2013/06/17/using-dbms_xplan-to-display-cursor-plans-for-a-sql-in-all-rac-nodes

Using DBMS_XPLAN to display Cursor Plans for a SQL in all RAC nodes

Just sharing a lightweight script that uses DBMS_XPLAN.DISPLAY_CURSOR to display Execution Plans for a given SQL_ID out of all RAC nodes. Nothing fancy, just a workaround to the lack of "instance" parameter on this API. Sample Output

  • General Meta Tags

    10
    • title
      Using DBMS_XPLAN to display Cursor Plans for a SQL in all RAC nodes | Carlos Sierra's Tools and Tips
    • Content-Type
      text/html; charset=UTF-8
    • robots
      max-image-preview:large
    • google-site-verification
      13QuM_MO5_UcJBJ0DKFwCm4Ckpfe6wrz5vxRIDzA4kg
    • generator
      WordPress.com

  • Open Graph Meta Tags

    10
    • og:type
      article
    • og:title
      Using DBMS_XPLAN to display Cursor Plans for a SQL in all RAC nodes
    • og:url
      https://carlos-sierra.net/2013/06/17/using-dbms_xplan-to-display-cursor-plans-for-a-sql-in-all-rac-nodes/
    • og:description
      Just sharing a lightweight script that uses DBMS_XPLAN.DISPLAY_CURSOR to display Execution Plans for a given SQL_ID out of all RAC nodes. Nothing fancy, just a workaround to the lack of “inst…
    • og:site_name
      Carlos Sierra's Tools and Tips

  • Twitter Meta Tags

    5
    • twitter:creator
      @csierra_usa
    • twitter:site
      @csierra_usa
    • twitter:text:title
      Using DBMS_XPLAN to display Cursor Plans for a SQL in all RAC nodes
    • twitter:image
      https://secure.gravatar.com/blavatar/6264a2da4c316b18e02179c53e8d9a2494ab7e878905f19c4b24f4e1392dc185?s=240
    • twitter:card
      summary

  • Link Tags

    33
    • EditURI
      https://carlossierradotnet1.wordpress.com/xmlrpc.php?rsd
    • alternate
      https://carlos-sierra.net/feed/
    • alternate
      https://carlos-sierra.net/comments/feed/
    • alternate
      https://carlos-sierra.net/2013/06/17/using-dbms_xplan-to-display-cursor-plans-for-a-sql-in-all-rac-nodes/feed/
    • alternate
      https://public-api.wordpress.com/oembed/?format=json&url=https%3A%2F%2Fcarlos-sierra.net%2F2013%2F06%2F17%2Fusing-dbms_xplan-to-display-cursor-plans-for-a-sql-in-all-rac-nodes%2F&for=wpcom-auto-discovery

Emails

2
  • ?subject=%5BShared%20Post%5D%20Using%20DBMS_XPLAN%20to%20display%20Cursor%20Plans%20for%20a%20SQL%20in%20all%20RAC%20nodes&body=https%3A%2F%2Fcarlos-sierra.net%2F2013%2F06%2F17%2Fusing-dbms_xplan-to-display-cursor-plans-for-a-sql-in-all-rac-nodes%2F&share=email
  • [email protected]?Subject=Question%20from%20Wordpress

Links

46