-- -----------------------------------------------------------------------------
--                 WWW.PETEFINNIGAN.COM LIMITED
-- -----------------------------------------------------------------------------
-- Script Name : usage.sql
-- Author      : Pete Finnigan
-- Date        : November 2007, 2009
-- -----------------------------------------------------------------------------
-- Description : Use this script to assess features used in the database. 
-- -----------------------------------------------------------------------------
-- Maintainer  : Pete Finnigan (http://www.petefinnigan.com)
-- Copyright   : Copyright (C) 2007, 2009 PeteFinnigan.com Limited. All rights
--               reserved. All registered trademarks are the property of their
--               respective owners and are hereby acknowledged.
-- -----------------------------------------------------------------------------
-- License     : This software is free software BUT it is not in the public
--               domain. This means that you can use it for personal or 
--               commercial work but you cannot remove this notice or copyright
--               notices or the banner output by the program or edit them in any
--               way at all. You also cannot host/distribute/copy or in anyway 
--               make this script available through any means either in original
--               form or any derivitive work based on it. The script is 
--               only available from its own webpage 
--               http://www.petefinnigan.com/usage.sql or any other 
--               page that PeteFinnigan.com Limited hosts it from.
--               This script cannot be incorporated into any other free or 
--               commercial tools without permission from PeteFinnigan.com 
--               Limited.
--
--               In simple terms use it for free but dont make it available in
--               any way or build it into any other tools. 
-- -----------------------------------------------------------------------------
-- Version History
-- ===============
--
-- Who         version     Date      Description
-- ===         =======     ======    ======================
-- P.Finnigan  1.0         Nov 2007  First Issue.
-- P.Finnigan  1.1         Sep 2009  Update for Oak Table book
-- -----------------------------------------------------------------------------
--whenever sqlerror exit rollback

set feed off
spool usage.sql


col name for a37 head "Name"
col version for a10 head "Version"
col currently_used for a6 head "Used"
col first_usage_date for a9 head "First"
col last_usage_date for a9 head "Last"
col detected_usages for 999 head "Det"
select     substr(name,1,37) name,
   version,
   currently_used,
   first_usage_date,
   last_usage_date,
   detected_usages
from dba_feature_usage_statistics
where first_usage_date is not null
/

spool off
set feed on