DBWR summed scan depth

From: abdoul85 <abdoul85_at_gmail.com>
Date: Tue, 09 Oct 2007 09:03:05 -0700
Message-ID: <1191945785.003622.164310@r29g2000hsg.googlegroups.com>

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 ? Received on Tue Oct 09 2007 - 11:03:05 CDT