Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have some profiling scripts which work in some environments, but not others; the odd thing is that it doesn't seem terribly consistent across versions, so I'm guessing there's some patch or feature that has to be toggled to turn this on.

share|improve this question

closed as off-topic by Max Vernon, RolandoMySQLDBA, Phil, Erik, ypercubeᵀᴹ Mar 24 at 16:33

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Too localized - this could be because your code has a typo, basic error, or is not relevant to most of our audience. Consider revising your question so that it appeals to a broader audience. As it stands, the question is unlikely to help other users (regarding typo questions, see this meta question for background)." – Max Vernon, RolandoMySQLDBA, Phil
If this question can be reworded to fit the rules in the help center, please edit the question.

Are you saying the column doesn't exist, has NULL values, or has zero values? – Leigh Riffel Jan 20 '12 at 18:18
Could be the parameter TIMED_STATISTICS set to false on some DBs. See also the STATISTICS_LEVEL parameter. This query will tell you what's enabled stat-wise: select statistics_name, session_status, system_status, activation_level, session_settable v$statistics_level order by statistics_name; – Phil Jan 24 '12 at 17:29
@LeighRiffel The column simply does not exist. – TML Jan 24 '12 at 23:17
@Phil "Timed OS Statistics" is off, but "Timed Statistics" is on; would that explain it? – TML Jan 24 '12 at 23:17
@TML No, timed_os_statistics is set to 0 on my systems and the column exists. – Leigh Riffel Jan 25 '12 at 15:05

Browse other questions tagged or ask your own question.