Re: DBWR summed scan depth

abdoul85 wrote:
> hello,
> I'm writing a simple script which shows informations about database.
> The problem is that I have excecute:
>
> select * from v$sysstat dssd where dssd.name='DBWR summed scan depth'
>
> On database ver 9 everything is allright but on ver 10 the row with
> name value = 'DBWR summed scan depth' doesnt' exist.
> How to enable 'DBWR summed scan depth' in my database ?
> or is there any posibility to encourage SELECT to return for example
> "NOT EXIST" string instead of NULL when 'DBWR summed scan depth'
> doesn,t exist ?

Likely never will again. You need to write your query in a manner that is version specific.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org