Neil Chandler's DB Blog

    • About Neil
    • Consultancy Services
    • Presentations
    • SQL Scripts
    • Video Tutorials
      • Why Has My Plan Changed. Top 7 Plan Stability Pitfalls and How To Avoid Them!
      • Oracle Database Stats – the easy way!
      • Oracle Database Statistics – When It’s Harder
      • Histograms Are Evil like Chocolate is Evil
      • Oracle Execution Plan Changes
      • Using JSON in Oracle
    • MASH Program

SQL Scripts

perf_sqlobj.sql – show object information associated with a SQL_ID

perf_sqlobj.sqlDownload

MASH Program Logo
Help for Public Speaking

subscribe

  • Mail

Recent posts

  • Performance: Clustering Data

    Performance: Clustering Data

  • Performance: Index Clustering Factor

    Performance: Index Clustering Factor

  • Oracle Transparent Hugepages

    Oracle Transparent Hugepages

  • Oracle Database: Global Stats Changes After Partition Truncate

    Oracle Database: Global Stats Changes After Partition Truncate

  • ORA-04021 timeout occurred while waiting to lock object during stats gather

    ORA-04021 timeout occurred while waiting to lock object during stats gather

  • Infinity – Old Oracle Numbers

    Infinity – Old Oracle Numbers

Create a website or blog at WordPress.com

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Subscribe Subscribed
    • Neil Chandler's DB Blog
    • Join 133 other subscribers
    • Already have a WordPress.com account? Log in now.
    • Neil Chandler's DB Blog
    • Subscribe Subscribed
    • Sign up
    • Log in
    • Copy shortlink
    • Report this content
    • View post in Reader
    • Manage subscriptions
    • Collapse this bar