Urgent.News

What's breaking now, across thousands of outlets.

More in Tech

Bind Variables: The Hard-Parse Storm That Melts Your Shared Pool

The database is pinned at 90% CPU, the app team swears nothing changed, and AWR is topped by cursor: pin S wait on X and a parse-heavy profile. Nobody wrote a slow query.

  • Hard parse consumes shared pool memory and is time-consuming.
  • Bind variables prevent hard-parse storm by reusing parsed queries.
  • Use literals for infrequent, skewed data warehouse queries.

More from Sunday 27 September →