usage.sql
Download SQL script
usage.sql
-- ----------------------------------------------------------------------------- -- 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 (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 -- /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
