

----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
******************** Section8 ********************
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------


******************** TOPIC 1 ********************
export ORACLE_SID=PROD
.bash_profile OK



# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
	. ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export ORACLE_SID=PROD
export TNS_ADMIN=$ORACLE_HOME/network/admin
export PATH=$ORACLE_HOME/jdk/bin:$ORACLE_HOME/bin:$PATH
export LANG=en_US

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 18 13:06:14 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
NAME				     TYPE			      VALUE
------------------------------------ -------------------------------- ------------------------------
db_unique_name			     string			      PROD
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R100001=0.1


A: db_unique_name			     string			      PROD

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 18 13:06:15 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
DB_UNIQUE_NAME
--------------------
PROD

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R100002=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 18 13:06:15 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
NAME	  DATABASE_ROLE
--------- ----------------
PROD	  PRIMARY

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R100003=0.7


A: PROD	  PRIMARY

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 18 13:06:15 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
OPEN_MODE
----------
READ WRITE

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R100004=1


A: READ WRITE

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 18 13:06:16 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
  COUNT(*)
----------
	 0

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
VALUE_A: 	 0


R999999=0


A=0
R100005=.25

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 18 13:06:16 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
  COUNT(*)
----------
	 0

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
VALUE_A: 	 0


R999999=0


A=0
R100006=.25

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 18 13:06:16 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> SQL> 
NAME
-----------------------------------------------------------------
/u01/app/oracle/oradata/PROD/Disk1/control01.ctl
/u01/app/oracle/oradata/PROD/Disk2/control02.ctl
/u01/app/oracle/oradata/PROD/Disk3/control03.ctl

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
VALUE_A: 3


R100007=0.3



SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 18 13:06:17 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> SQL> SQL> SQL> SQL> ***************************
SQL> The database datafile here:
SQL> ***************************
SQL> SQL> SQL> SQL> SQL> 
TABLESPACE_NAME 	       STATUS
------------------------------ ---------------
SYSTEM			       ONLINE
SQL> 
FILE_NAME							  STATUS
----------------------------------------------------------------- ---------------
/u01/app/oracle/oradata/PROD/Disk1/system01.dbf 		  AVAILABLE
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R100008=0.1


A: /u01/app/oracle/oradata/PROD/Disk1/system01.dbf 		  AVAILABLE

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 18 13:06:17 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> SQL> SQL> SQL> SQL> ***************************
SQL> The database datafile here:
SQL> ***************************
SQL> SQL> SQL> SQL> SQL> 
TABLESPACE_NAME 	       STATUS
------------------------------ ---------------
SYSAUX			       ONLINE
SQL> 
FILE_NAME							  STATUS
----------------------------------------------------------------- ---------------
/u01/app/oracle/oradata/PROD/Disk2/sysaux01.dbf 		  AVAILABLE
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R100009=0.1


A: /u01/app/oracle/oradata/PROD/Disk2/sysaux01.dbf 		  AVAILABLE

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 18 13:06:18 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> SQL> SQL> SQL> SQL> ***************************
SQL> The database datafile here:
SQL> ***************************
SQL> SQL> SQL> SQL> SQL> SQL> SQL> 
TABLESPACE_NAME 	       STATUS
------------------------------ ---------------
UNDOTBS01		       ONLINE
SQL> 
FILE_NAME							  STATUS
----------------------------------------------------------------- ---------------
/u01/app/oracle/oradata/PROD/Disk3/undotbs01.dbf		  AVAILABLE
SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R100010=0.1


A: /u01/app/oracle/oradata/PROD/Disk3/undotbs01.dbf		  AVAILABLE

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 18 13:06:18 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
     VALUE
----------
	 1

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
VALUE_A: 	 1


R100011=0.15



SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 18 13:06:18 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
VALUE
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
service="(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=station12.example.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=STDBY_XPT)(INSTANCE_NAME=STDBY)(SERVER=dedicated)))",	 ARCH SYNC NOAFFIRM delay=0 OPTIONAL max_failure=0 max_connections=1   reopen=300 db_unique_name="STDBY" register net_timeout=180  valid_for=(online_logfile,primary_role)

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R100012=0


A: 0


******************** TOPIC 2 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 18 13:06:19 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> SQL> Connected.
SQL> ORA-00604: error occurred at recursive SQL level 3
ORA-01219: database not open: queries allowed on fixed tables/views only


SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R200001=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 18 13:06:19 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> SQL> Connected.
SQL> select DB_UNIQUE_NAME from st_test order by STANDBY_BECAME_PRIMARY_SCN desc
                           *
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only


SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R200002=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 18 13:06:19 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> SQL> Connected.
SQL> select NAME,DATABASE_ROLE from v$database
                               *
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 3
ORA-01219: database not open: queries allowed on fixed tables/views only


SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R200003=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 18 13:06:20 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> SQL> Connected.
SQL> select	open_mode from v$database
                       *
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 3
ORA-01219: database not open: queries allowed on fixed tables/views only


SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R200004=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 18 13:06:20 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> SQL> Connected.
SQL> select	count(*)  from dba_tablespaces where status <> 'ONLINE'
                       *
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only


SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R999999=0


VALUE_A: 


R999999=0


A=0
R200005=.25

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 18 13:06:20 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> SQL> Connected.
SQL> SQL> SP2-0734: unknown command beginning "sub_db_soc..." - rest of line ignored.
SQL> select count(*) from v$datafile where status not in ('SYSTEM', 'ONLINE')
                     *
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 3
ORA-01219: database not open: queries allowed on fixed tables/views only


SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R999999=0


VALUE_A: 


R999999=0


A=0
R200006=.25

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 18 13:06:21 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> SQL> Connected.
SQL> SQL> select name from v$controlfile
                 *
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 3
ORA-01219: database not open: queries allowed on fixed tables/views only


SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R200007=0


VALUE_A: 0


R200007=0



SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 18 13:06:21 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> SQL> Connected.
SQL> SQL> SQL> SQL> SQL> ***************************
SQL> The database datafile here:
SQL> ***************************
SQL> SQL> SQL> SQL> SQL> select tablespace_name,status from dba_tablespaces where tablespace_name='SYSTEM'
                                   *
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only


SQL> select file_name,status from dba_data_files where tablespace_name='SYSTEM'
                             *
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only


SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R200008=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 18 13:06:21 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> SQL> Connected.
SQL> SQL> SQL> SQL> SQL> ***************************
SQL> The database datafile here:
SQL> ***************************
SQL> SQL> SQL> SQL> SQL> select tablespace_name,status from dba_tablespaces where tablespace_name='SYSAUX'
                                   *
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only


SQL> select file_name,status from dba_data_files where tablespace_name='SYSAUX'
                             *
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only


SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R200009=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 18 13:06:22 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> SQL> Connected.
SQL> SQL> SQL> SQL> SQL> ***************************
SQL> The database datafile here:
SQL> ***************************
SQL> SQL> SQL> SQL> SQL> select tablespace_name,status from dba_tablespaces t, v$parameter p where t.tablespace_name=p.value and p.name='undo_tablespace'
                                                      *
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 3
ORA-01219: database not open: queries allowed on fixed tables/views only


SQL> select file_name,status from dba_data_files d, v$parameter p where d.tablespace_name=p.value and p.name='undo_tablespace'
                                               *
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 3
ORA-01219: database not open: queries allowed on fixed tables/views only


SQL> select tablespace_name,status from dba_tablespaces where tablespace_name like 'UNDO%'
                                   *
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only


SQL> select file_name,status from dba_data_files where tablespace_name like 'UNDO%'
                             *
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only


SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R200010=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 18 13:06:22 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
     VALUE
----------
	 1

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
VALUE_A: 	 1


R200011=0.5



SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 18 13:06:22 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> SQL> Connected.
SQL> select	name from v$datafile
                  *
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 3
ORA-01219: database not open: queries allowed on fixed tables/views only


SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R200012=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 18 13:06:23 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> SQL> Connected.
SQL> select member from v$logfile where type='ONLINE'
                   *
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 3
ORA-01219: database not open: queries allowed on fixed tables/views only


SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R200013=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 18 13:06:23 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
  COUNT(*)
----------
	 4

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
VALUE_A: 	 4


R888888=0



SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 18 13:06:23 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> SQL> Connected.
SQL> select count(*) from v$datafile
                     *
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 3
ORA-01219: database not open: queries allowed on fixed tables/views only


SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R777777=0


VALUE_A: 


R777777=0


R200014=0

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 18 13:06:24 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
  COUNT(*)
----------
	 3

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
VALUE_A: 	 3


R888888=0



SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 18 13:06:24 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> SQL> Connected.
SQL> select count(*) from v$tempfile
                     *
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 3
ORA-01219: database not open: queries allowed on fixed tables/views only


SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R777777=0


VALUE_A: 


R777777=0


R200015=0
****************************************************************************************************


R100001: 0.1 full is 0.1 0.1
R100002: 0 full is 1.5 1.6
R100003: 0.7 full is 0.7 2.3
R100004: 1 full is 1 3.3
R100005: .25 full is 0.25 3.55
R100006: .25 full is 0.25 3.8
R100007: 0.3 full is 0.3 4.1
R100008: 0.1 full is 0.1 4.2
R100009: 0.1 full is 0.1 4.3
R100010: 0.1 full is 0.1 4.4
R100011: 0.15 full is 0.15 4.55
R100012: 0 full is 0.35 4.9
R200001: 0 full is 0.5 5.4
R200002: 0 full is 1 6.4
R200003: 0 full is 0.7 7.1
R200004: 0 full is 0.3 7.4
R200005: .25 full is 0.25 7.65
R200006: .25 full is 0.25 7.9
R200007: 0 full is 0.3 8.2
R200008: 0 full is 0.2 8.4
R200009: 0 full is 0.2 8.6
R200010: 0 full is 0.2 8.8
R200011: 0.5 full is 0.5 9.3
R200012: 0 full is 0.1 9.4
R200013: 0 full is 0.1 9.5
R200014: 0 full is 0.4 9.9
R200015: 0 full is 0.1 10
full of this section:
RESULT:
4.05


****************************************************************************************************
