oracle 巡检 健康检查模版 - 图文 下载本文

Oracle healthcheck report ?3.3.10. Db objects information

Owne XSDDEV1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 PUBLIC 3.3.11. invalid objects

OWNER No invalid objects OBJECT_NAME STATUS Object type SYNONYM FUNCTION INDEX LOB PACKAGE PACKAGE BODY PROCEDURE SEQUENCE TABLE VIEW SYNONYM counts 1583 3 806 7 43 43 710 4 783 2 1595

3.3.12. index info

OWNER XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 Service doc

)

TABLE_NAME XSDABW_JUCHU_J XSDABW_MZAN_001 XSDABW_MZAN_M XSDABW_NYUKIN_J XSDABW_PROKAN_TOUGETU_WK XSDABW_SOHIN_J XSDABW_URIAGE_J XSDABW_UZAN_001 XSDABW_UZAN_002 XSDABW_UZAN_NOBARAI XSDABW_ZEIZAN_001 XSDAB_JUCHU_H XSDAB_JUCHU_J XSDAB_JUCHU_M XSDAB_MAEKIN_M XSDAB_MINYUKIN_M

COUNT(INDEX_NAME) 1 1 1 1 1 1 1 1 1 1 1 1 5 1 1 2 Page 29 of 57

Oracle healthcheck report 1 1 1 6 1 3 1 1 1 1 2 1 5 1 1 1 2 2 6 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1

?XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 Service doc

)

XSDAB_MINYUKIN_MINAOSHI XSDAB_MZAN XSDAB_MZAN_MAE XSDAB_NYUKIN_J XSDAB_PRANT_SUMI XSDAB_PROKAN XSDAB_PROKAN_TOUGETU XSDAB_RENKETSU_CD XSDAB_SEIKYU_REMIND XSDAB_SEIKYU_REMIND_KITEN XSDAB_SHUKKA_H XSDAB_SHUKKA_M XSDAB_SOHIN_J XSDAB_SOKATU_J XSDAB_STS_JUCHU_M XSDAB_STS_ZEI_M XSDAB_TEGATAZAN XSDAB_TEGATAZAN_ZENGETSU XSDAB_URIAGE_J XSDAB_UZAN XSDAB_UZAN_MAE XSDAB_UZAN_MZAN XSDAB_UZAN_MZAN_MAE XSDAB_ZEIZAN XSDAB_ZEI_SEIKYU_J XSDBCW_FURIKAETXT_001 XSDBCW_HIKIATE_FURI_M XSDBCW_MAEKIN_KONKAIWK XSDBCW_MAEKIN_LISTWK XSDBCW_MZANSWK XSDBCW_NOBE_JUCHU_SOGAKU1 XSDBCW_NOBE_JUCHU_SOGAKU2 XSDBCW_NOBE_SCHEDULE XSDBCW_NOBE_SEIKYU_MOTO_H XSDBCW_NOBE_SEIKYU_MOTO_M XSDBCW_NYUKINW_J_WK XSDBCW_NYUKIN_QUEUING XSDBCW_SAISEIKYU_001 XSDBCW_SAISEIKYU_002 Page 30 of 57

Oracle healthcheck report 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 3 1 1 1 1 1 2 1 1 1 1 1 1 1

?XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 Service doc

)

XSDBCW_SHUNOTXT_001 XSDBCW_SHUNO_M XSDBCW_SHUNO_M_TXT_001 XSDBCW_UZANHWK XSDBCW_UZANSWK XSDBCW_V61L116_001 XSDBCW_ZAIMU_001 XSDBCW_ZAIMU_002 XSDBCW_ZAIMU_003 XSDBCW_ZAIMU_004 XSDBCW_ZEI_SEIKYU_M XSDBC_FURIKAE_CHECK XSDBC_HIKIATE_FURI_M XSDBC_HIKIATE_H XSDBC_HIKIATE_KANJO_CHECK XSDBC_HIKIATE_M XSDBC_HIKIATE_NO_SAIBAN XSDBC_LC XSDBC_LCZAN XSDBC_LC_NO_SAIBAN XSDBC_MAEKIN_LIST XSDBC_MAEKIN_M XSDBC_MAEKIN_TEISHI XSDBC_NAATENIN XSDBC_NETTING_FILE_SEQ XSDBC_NYUKIN_M XSDBC_NYUKIN_QUEUING XSDBC_NYUKIN_QUEUING_R XSDBC_SCHEDULE_H XSDBC_SCHEDULE_J XSDBC_SCHEDULE_M XSDBC_SEIKYU_H XSDBC_SEIKYU_NO_SAIBAN XSDBC_SHOHIZEI_OSHIHARAI XSDBC_SHUNO_H XSDBC_SHUNO_M XSDBC_SHUNO_NO_SAIBAN XSDBC_SHUNO_TANTOSHA XSDBC_TEGATA Page 31 of 57

Oracle healthcheck report 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1

?XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 XSDOWN1 Service doc

)

XSDBC_TEGATA_GINKO_KOZA XSDBC_TEGATA_NO_SAIBAN XSDBC_TEGATA_QUEUING XSDBC_TEGATA_QUEUING_R XSDBC_TORITATE_GINKO XSDBC_URIAGEMODOSHI_TAISHO XSDBC_ZAIMU_HOUKOKU_SHIRYO XSDCDW_D1A01_001 XSDCDW_D1A01_003 XSDCDW_D1A01_901 XSDCDW_D1A06_001 XSDCDW_JUCHU_J_WK XSDCDW_KANI_KOBAI_001 XSDCDW_KANI_KOBAI_002 XSDCDW_L1A01_001 XSDCDW_L1A02_001 XSDCDW_L1A02_002 XSDCDW_L1A02_003 XSDCDW_L1A02_004 XSDCDW_L1A02_005 XSDCDW_L1A02_101 XSDCDW_L1A03_001 XSDCDW_L1A04_001 XSDCDW_L1A04_002 XSDCDW_L1A04_003 XSDCDW_M1A02_001 XSDCDW_SHONIN_001 XSDCDW_SHUKKA_001 XSDCDW_SHUKKA_002 XSDCDW_SHUKKA_003 XSDCDW_SHUKKA_004 XSDCDW_SHUKKA_006 XSDCDW_SHUKKA_007 XSDCDW_SHUKKA_008 XSDCDW_SHUKKA_009 XSDCDW_SHUKKA_011 XSDCDW_SHUKKA_012 XSDCDW_SHUKKA_014 XSDCDW_SHUKKA_015 Page 32 of 57