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
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

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.