

----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
******************** Section2 ********************
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------


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


******************** TOPIC 1.1 ********************


******************** TOPIC 1.2 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 22:22:34 2015

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

SQL> Connected.
SQL> SQL> SQL> SQL> SQL> SQL> ****************************
SQL> The database open mode here:
SQL> ****************************
SQL> SQL> 
D
-
X
SQL> 
OPEN_MODE
----------
READ WRITE
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


R102000=2


A: READ WRITE


******************** TOPIC 1.3 ********************
Connection closed by foreign host.
tcp        0      0 0.0.0.0:4889                0.0.0.0:*                   LISTEN      1433/httpd          
Trying 127.0.0.1...
Connected to localhost.localdomain (127.0.0.1).
Escape character is '^]'.


R103001=0.5


A: tcp        0      0 0.0.0.0:4889                0.0.0.0:*                   LISTEN      1433/httpd          
tcp        0      0 0.0.0.0:4889                0.0.0.0:*                   LISTEN      1433/httpd          
Trying 127.0.0.1...
Connected to localhost.localdomain (127.0.0.1).
Escape character is '^]'.


R103002=2.5


A: Escape character is '^]'.


******************** TOPIC 1.4 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 22:22:35 2015

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

SQL> Connected.
SQL> SQL> SQL> SQL> SQL>   2    3  
KEY_VALUE
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
dbsnmp
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


R104000=0.2


A: dbsnmp


******************** TOPIC 1.5 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 22:22:35 2015

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

SQL> Connected.
SQL> SQL> SQL> SQL> SQL>   2    3  
KEY_VALUE
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
dbsnmp
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


R105000=0.2


A: dbsnmp


******************** TOPIC 1.6 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 22:22:36 2015

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

SQL> Connected.
SQL> SQL> SQL> SQL> SQL> SQL> 
USER_NAME					   SYSTEM_USER	 DELETING
-------------------------------------------------- ----------- ----------
EMADMIN 						     0		0
SYSMAN							     1		0
MGMT_VIEW						     0		0
SYS							     1		0
SYSTEM							     1		0
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


R106000=0.2


A: EMADMIN 						     0		0


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


******************** TOPIC 2.1 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 22:22:36 2015

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

SQL> SQL> Connected.
SQL> 
VALUE
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
19713228

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


R201001=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 22:22:36 2015

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

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


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


R201002=0.1


A: 0


******************** TOPIC 2.2 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 22:22:37 2015

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

SQL> SQL> Connected.
SQL> 
VALUE
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
0

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


R202001=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 22:22:37 2015

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

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


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


R202002=0


A: 0


******************** TOPIC 2.3 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 22:22:37 2015

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

SQL> SQL> Connected.
SQL>   2  
no rows selected

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


R203001=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 22:22:38 2015

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

SQL> SQL> Connected.
SQL>   2  
no rows selected

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


R203002=0


A: 0


******************** TOPIC 2.4 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 22:22:38 2015

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

SQL> Connected.
SQL> SQL> 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


R204000=0


A: 0


******************** TOPIC 2.5 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 22:22:38 2015

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

SQL> SQL> Connected.
SQL> 
no rows selected

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


R205000=0


A: no rows selected


******************** TOPIC 2.5.1 ********************


R205010=0




******************** TOPIC 2.5.2 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 22:22:39 2015

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

SQL> SQL> Connected.
SQL> 
no rows selected

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


R205020=0


A: 0


******************** TOPIC 2.5.3 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 22:22:39 2015

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

SQL> SQL> Connected.
SQL> 
no rows selected

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


R205030=0


A: 0


******************** TOPIC 3 ********************


******************** TOPIC 3.1 ********************


******************** TOPIC 3.2 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 22:22:39 2015

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

SQL> SQL> Connected.
SQL> 
SCHEDULE_NAME
------------------------------
DAILY_PURGE_SCHEDULE

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


R302000=0


A: 0


******************** TOPIC 3.3 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 22:22:40 2015

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

SQL> SQL> Connected.
SQL> 
no rows selected

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


R303000=0


A: 0


******************** TOPIC 3.4 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 22:22:40 2015

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

SQL> SQL> Connected.
SQL> 
PROGRAM_NAME
------------------------------
AUTO_SPACE_ADVISOR_PROG
GATHER_STATS_PROG
PURGE_LOG_PROG

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


R304001=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 22:22:41 2015

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

SQL> SQL> Connected.
SQL> 
no rows selected

SQL> 
 ANALYZEDT
----------
16445.9324

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: 16445


R304002=0




******************** TOPIC 3.5 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 22:22:42 2015

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

SQL> SQL> Connected.
SQL> 
no rows selected

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


R305001=0


A: no rows selected

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 22:22:42 2015

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

SQL> SQL> Connected.
SQL> 
no rows selected

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


R305002=0


A: 0


******************** TOPIC 3.6 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 22:22:43 2015

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

SQL> SQL> Connected.
SQL> 
no rows selected

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


R306000=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 22:22:43 2015

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

SQL> SQL> Connected.
SQL> 
no rows selected

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


R306000=0


B: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 22:22:43 2015

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

SQL> SQL> Connected.
SQL> 
no rows selected

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


R306000=0


C: 0


******************** TOPIC 3.7 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 22:22:43 2015

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

SQL> SQL> Connected.
SQL> 
no rows selected

SQL> 
no rows selected

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


R307001=0



SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 22:22:44 2015

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

SQL> SQL> Connected.
SQL> 
no rows selected

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


R307002=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jan 10 22:22:44 2015

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

SQL> SQL> Connected.
SQL> 
no rows selected

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


R307003=0


A: 0
****************************************************************************************************


R102000: 2 full is 2 2
R103001: 0.5 full is 0.5 2.5
R103002: 2.5 full is 2.5 5
R104000: 0.2 full is 0.2 5.2
R105000: 0.2 full is 0.2 5.4
R106000: 0.2 full is 0.2 5.6
R201001: 0 full is 0.1 5.7
R201002: 0.1 full is 0.1 5.8
R202001: 0 full is 0.1 5.9
R202002: 0 full is 0.1 6
R203001: 0 full is 0.15 6.15
R203002: 0 full is 0.15 6.3
R204000: 0 full is 0.3 6.6
R205000: 0 full is 0.1 6.7
R205010: 0 full is 0.1 6.8
R205020: 0 full is 0.1 6.9
R205030: 0 full is 0.1 7
R302000: 0 full is 0.2 7.2
R303000: 0 full is 0.3 7.5
R304001: 0 full is 0.2 7.7
R304002: 0 full is 0.55 8.25
R305001: 0 full is 0.2 8.45
R305002: 0 full is 0.25 8.7
R306000: 0 full is 0.2 8.9
R307001: 0 full is 0.5 9.4
R307002: 0 full is 0.3 9.7
R307003: 0 full is 0.3 10
full of this section:
RESULT:
5.7


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