db_info_v11lunix.sql

set doc on
set heading off
set feedback off
set verify off
column listfile heading "Listfile"  new_value listfile format a40;

spool db_info_spool.lst
select 'spool db_info_'||name||'_'||to_char(sysdate,'YYYYMMDD_HH24_MI') listfile 
from v$database;

spool off
@db_info_spool.lst

variable listfile varchar2(40);
begin 
  :listfile := '&listfile';
end;
/

remark AAA$READ.ME
doc

	Generate quick database overview
	spoolfile : db_info.lst
	
        Version 11g: 26/04/2007

#

set linesize 80
-- set pagesize 200
set heading on
set feedback on

@@info01_v10.sql

@@info02.sql

@@cangrow

@@info03_v9.sql
@@info04_v8.sql
--@@info05_v8.sql
@@info05
@@info06.sql
@@info07.sql
@@info08_v10.sql
@@info09_v10.sql

@@info_patches

spool off

prompt Listfile is in &listfile..lst