SET PAGESIZE     9999
SET VERIFY       OFF
SET SERVEROUTPUT ON  SIZE 500000 FORMAT WORD_WRAPPED
SET FEEDBACK     OFF
SET TRIMSPOOL    ON
SET LINESIZE 3500
SET PAGESIZE 35000

COLUMN FILE_NAME FORMAT A70

ALTER SESSION set nls_numeric_characters = ',.';

-- Disect the input argument, and get the owner filter and table filter into two seperate 
-- substitution variables. The owner filter defaults to the current user.

DEFINE InputTablespaceFilter = ' '
COLUMN Tablespace NOPRINT NEW_VALUE InputTablespaceFilter

COLUMN PROPERTY_VALUE FORMAT A30
COLUMN DESCRIPTION FORMAT A60

SELECT * FROM DATABASE_PROPERTIES ORDER BY PROPERTY_NAME;

column name format a10
column CHECKPOINT_CHANGE# format 999999999999999999
column ARCHIVE_CHANGE# format 999999999999999999
column CONTROLFILE_SEQUENCE# format 999999999999999999
column CONTROLFILE_CHANGE# format 999999999999999999
column ARCHIVELOG_CHANGE# format 999999999999999999
column CURRENT_SCN format 999999999999999999


select dbid,name,CHECKPOINT_CHANGE#,ARCHIVE_CHANGE#,CONTROLFILE_SEQUENCE#,CONTROLFILE_CHANGE#,ARCHIVELOG_CHANGE#,CURRENT_SCN from v$database;

SET FEEDBACK ON
SET PAGESIZE 9999
