Oracle healthcheck report 32886 32887 32888 32889 32890 32891 32892 32893 32894 32895 32896 32897 32898 32899 32900 32901 32902 32903 32904 32905 32906 32907 32908 32909 32910 32911 32912 32913 32914 32915 32916 32917 32918 32919 32920 32921 32922 32923 32924

? 2009-06-19 16:45:02 2009-06-19 17:45:03 2009-06-19 17:45:03 2009-06-19 18:45:02 2009-06-19 18:45:02 2009-06-19 19:45:03 2009-06-19 19:45:03 2009-06-19 20:45:03 2009-06-19 20:45:03 2009-06-19 21:19:33 2009-06-19 21:19:33 2009-06-19 21:45:02 2009-06-19 21:45:02 2009-06-19 22:45:02 2009-06-19 22:45:02 2009-06-19 23:45:01 2009-06-19 23:45:01 2009-06-20 00:45:02 2009-06-20 00:45:02 2009-06-20 01:45:02 2009-06-20 01:45:02 2009-06-20 02:45:02 2009-06-20 02:45:02 2009-06-20 03:45:02 2009-06-20 03:45:02 2009-06-20 04:45:02 2009-06-20 04:45:02 2009-06-20 05:45:02 2009-06-20 05:45:02 2009-06-20 06:45:02 2009-06-20 06:45:02 2009-06-20 07:00:17 2009-06-20 07:00:17 2009-06-20 07:45:02 2009-06-20 07:45:02 2009-06-20 08:45:02 2009-06-20 08:45:02 2009-06-20 09:45:02 2009-06-20 09:45:02 0 60 0 60 0 60 0 60 0 34 0 25 0 60 0 60 0 60 0 60 0 60 0 60 0 60 0 60 0 60 0 15 0 45 0 60 0 60 0 Page 25 of 57

32885 32886 32887 32888 32889 32890 32891 32892 32893 32894 32895 32896 32897 32898 32899 32900 32901 32902 32903 32904 32905 32906 32907 32908 32909 32910 32911 32912 32913 32914 32915 32916 32917 32918 32919 32920 32921 32922 32923 Service doc

)

2009-06-19 16:45:02 2009-06-19 16:45:02 2009-06-19 17:45:03 2009-06-19 17:45:03 2009-06-19 18:45:02 2009-06-19 18:45:02 2009-06-19 19:45:03 2009-06-19 19:45:03 2009-06-19 20:45:03 2009-06-19 20:45:03 2009-06-19 21:19:33 2009-06-19 21:19:33 2009-06-19 21:45:02 2009-06-19 21:45:02 2009-06-19 22:45:02 2009-06-19 22:45:02 2009-06-19 23:45:01 2009-06-19 23:45:01 2009-06-20 00:45:02 2009-06-20 00:45:02 2009-06-20 01:45:02 2009-06-20 01:45:02 2009-06-20 02:45:02 2009-06-20 02:45:02 2009-06-20 03:45:02 2009-06-20 03:45:02 2009-06-20 04:45:02 2009-06-20 04:45:02 2009-06-20 05:45:02 2009-06-20 05:45:02 2009-06-20 06:45:02 2009-06-20 06:45:02 2009-06-20 07:00:17 2009-06-20 07:00:17 2009-06-20 07:45:02 2009-06-20 07:45:02 2009-06-20 08:45:02 2009-06-20 08:45:02 2009-06-20 09:45:02 Oracle healthcheck report 2009-06-20 10:45:01 2009-06-20 10:45:01 2009-06-20 11:45:02 2009-06-20 11:45:02 2009-06-20 12:45:01 2009-06-20 12:45:01 2009-06-20 13:45:02 2009-06-20 13:45:02 2009-06-20 14:45:01 2009-06-20 14:45:01 2009-06-20 15:45:02 2009-06-20 15:45:02 2009-06-20 16:45:02 2009-06-20 16:45:02 2009-06-20 17:45:02 2009-06-20 17:45:02 2009-06-20 18:45:02 2009-06-20 18:45:02 2009-06-20 19:45:02 2009-06-20 19:45:02 2009-06-20 20:45:02 2009-06-20 20:45:02 2009-06-20 21:45:02 2009-06-20 21:45:02 2009-06-20 22:45:02 2009-06-20 22:45:02 ?60 0 60 0 60 0 60 0 60 0 60 0 60 0 60 0 60 0 60 0 60 0 60 0 60 0 32924 32925 32926 32927 32928 32929 32930 32931 32932 32933 32934 32935 32936 32937 32938 32939 32940 32941 32942 32943 32944 32945 32946 32947 32948 32949 32950 2009-06-20 09:45:02 32925 2009-06-20 10:45:01 32926 2009-06-20 10:45:01 32927 2009-06-20 11:45:02 32928 2009-06-20 11:45:02 32929 2009-06-20 12:45:01 32930 2009-06-20 12:45:01 32931 2009-06-20 13:45:02 32932 2009-06-20 13:45:02 32933 2009-06-20 14:45:01 32934 2009-06-20 14:45:01 32935 2009-06-20 15:45:02 32936 2009-06-20 15:45:02 32937 2009-06-20 16:45:02 32938 2009-06-20 16:45:02 32939 2009-06-20 17:45:02 32940 2009-06-20 17:45:02 32941 2009-06-20 18:45:02 32942 2009-06-20 18:45:02 32943 2009-06-20 19:45:02 32944 2009-06-20 19:45:02 32945 2009-06-20 20:45:02 32946 2009-06-20 20:45:02 32947 2009-06-20 21:45:02 32948 2009-06-20 21:45:02 32949 2009-06-20 22:45:02 32950 2009-06-20 22:45:02 3.3.7. Tablepace and datafile information

3.3.7.1 Tablespace Storage parameter

TABLESPACE NAME SYSTEM UNDO TEMP TOOLS Service doc

)

INITIAL EXTENT 65536 65536 1048576 65536 MAX EXTENTS 2147483645 2147483645 2147483645

BLOCK SIZE 8192 8192 8192 8192 EXTENT MANAGEMENT LOCAL LOCAL LOCAL LOCAL SEGMENT_SPACE_MANAGEMENT MANUAL MANUAL MANUAL AUTO Page 26 of 57

Oracle healthcheck report 1048576 1048576 2147483645 2147483645 8192 8192 LOCAL LOCAL AUTO AUTO ?DATA INDX

3.3.7.2 Tablespace free size

TABLESPACE NAME DATA INDX SYSTEM TOOLS UNDO

3.3.7.3 Data File

FILES TOTAL SIZE（M） 10 7 1 1 2 20000 14000 511 1023 2046 FREE—SIZE 7396 9313 225 924 2008 USE—SIZE(M） 12604 4687 286 99 38 % Free 36.98 66.52 44.10 90.34 98.12 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 /home/oracle9i/ora9i/oradata/XXXX01/system01.dbf /home/oracle9i/ora9i/oradata/XXXX01/undo01.dbf /home/oracle9i/ora9i/oradata/XXXX01/undo02.dbf /home/oracle9i/ora9i/oradata/XXXX01/tools01.dbf /home/oracle9i/ora9i/oradata/XXXX01/data11.dbf /home/oracle9i/ora9i/oradata/XXXX01/data12.dbf /home/oracle9i/ora9i/oradata/XXXX01/data13.dbf /home/oracle9i/ora9i/oradata/XXXX01/data14.dbf /home/oracle9i/ora9i/oradata/XXXX01/data21.dbf /home/oracle9i/ora9i/oradata/XXXX01/data22.dbf /home/oracle9i/ora9i/oradata/XXXX01/data23.dbf /home/oracle9i/ora9i/oradata/XXXX01/data24.dbf /home/oracle9i/ora9i/oradata/XXXX01/data25.dbf /home/oracle9i/ora9i/oradata/XXXX01/data26.dbf /home/oracle9i/ora9i/oradata/XXXX01/idx11.dbf /home/oracle9i/ora9i/oradata/XXXX01/idx12.dbf /home/oracle9i/ora9i/oradata/XXXX01/idx13.dbf /home/oracle9i/ora9i/oradata/XXXX01/idx21.dbf /home/oracle9i/ora9i/oradata/XXXX01/idx22.dbf /home/oracle9i/ora9i/oradata/XXXX01/idx23.dbf /home/oracle9i/ora9i/oradata/XXXX01/idx24.dbf 511 1023 1023 1023 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 AVAILABLE AVAILABLE AVAILABLE AVAILABLE AVAILABLE AVAILABLE AVAILABLE AVAILABLE AVAILABLE AVAILABLE AVAILABLE AVAILABLE AVAILABLE AVAILABLE AVAILABLE AVAILABLE AVAILABLE AVAILABLE AVAILABLE AVAILABLE AVAILABLE Service doc

)

Page 27 of 57

Oracle healthcheck report ?3.3.8. Temporary tablespace information

1 temp segment configuration information

FILE_NAME TABLESPACE_NAME /home/oracle9i/ora9i/oradata/XXTEMP XX01/temp01.dbf /home/oracle9i/ora9i/oradata/XXTEMP XX01/temp02.dbf

2 Temp segement using information BYTES(M) STATUS 1023 AVAILABLE 1023 AVAILABLE TABLESPACE_NAME SUM(BLOCKS) SUM(USER_BLOCKS) free blocks TEMP SUM(MAXBLOCKS) 0 261888 261632 256 3.3.9. Undotablespace information

1 undotablespace configuration information

TABLESPACEFILE NAME NAME UNDO /home/oracle9i/ora9i/oradata/XXXX01/undo01.dbf UNDO /home/oracle9i/ora9i/oradata/XXXX01/undo02.dbf

2 undo tablespace using information BYTES(M) STATUS 1023 AVAILABLE 1023 AVAILABLE USN EXTENTS 0 7 1 5 2 6 3 5 4 4 5 3 6 6 7 5 8 6 9 6 10 5 OPTSIZE HWMSIZE WRAPS STATUS 450560 0 ONLINE 3268608 0 ONLINE 3334144 0 ONLINE 3268608 0 ONLINE 2220032 0 ONLINE 8511488 0 ONLINE 4317184 0 ONLINE 3268608 0 ONLINE 4317184 0 ONLINE 4317184 0 ONLINE 3268608 0 ONLINE Service doc

)

Page 28 of 57