Take the 2-minute tour ×
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.

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

 
discard

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

Browse other questions tagged or ask your own question.