Main Tables Views Materialized Views Indexes Constraints Triggers Procedures Functions Packages Sequences Java Sources Sanity Check Index DDL scrips
FK indexes Invalid objects

Sanity Check

No indexes on columns involved in foreign key constraints

You should almost always index foreign keys. The only exception is when the matching unique or primary key is never updated or deleted. For more information take a look on Concurrency Control, Indexes, and Foreign Keys.

The sql file which will generate these indexes is created for you

"Unindexed" foreign keys

Table NameConstraint nameColumns
DB_CHANGE_SCRIPT_PARSED DBCSP_DBCSC_BUG_ID_SEQ_NO_FK BUG_ID, SEQ_NO
RHNACTION RHN_ACTION_AT_FK ACTION_TYPE
RHNACTIONCONFIGFILENAME RHN_ACTIONCF_FAILURE_ID_FK FAILURE_ID
RHNACTIONCONFIGFILENAME RHN_ACTIONCF_NAME_CFNID_FK CONFIG_FILE_NAME_ID
RHNACTIONCONFIGREVISION RHN_ACTIONCR_FAILID_FK FAILURE_ID
RHNACTIONKICKSTART RHN_ACTIONKS_KSTID_FK KSTREE_ID
RHNACTIONKICKSTARTGUEST RHN_ACTIONKS_XENGUEST_KSID_FK KS_SESSION_ID
RHNACTIONKICKSTARTGUEST RHN_ACTIONKS_XENGUEST_KSTID_FK KSTREE_ID
RHNACTIONPACKAGE RHN_ACT_P_EVR_FK EVR_ID
RHNACTIONPACKAGE RHN_ACT_P_NAME_FK NAME_ID
RHNACTIONPACKAGE RHN_ACT_P_PAID_FK PACKAGE_ARCH_ID
RHNACTIONPACKAGEDELTA RHN_ACT_PD_PDID_FK PACKAGE_DELTA_ID
RHNACTIONPACKAGEREMOVALFAILURE RHN_APR_FAILURE_CAPID_FK CAPABILITY_ID
RHNACTIONPACKAGEREMOVALFAILURE RHN_APR_FAILURE_EID_FK EVR_ID
RHNACTIONPACKAGEREMOVALFAILURE RHN_APR_FAILURE_NID_FK NAME_ID
RHNACTIONPACKAGEREMOVALFAILURE RHN_APR_FAILURE_SUGGESTED_FK SUGGESTED
RHNARCHTYPEACTIONS RHN_ARCHTYPEACTS_ACTID_FK ACTION_TYPE_ID
RHNBLACKLISTOBSOLETES RHN_BL_OBS_EID_FK EVR_ID
RHNBLACKLISTOBSOLETES RHN_BL_OBS_INID_FK IGNORE_NAME_ID
RHNBLACKLISTOBSOLETES RHN_BL_OBS_PAID_FK PACKAGE_ARCH_ID
RHNCHANNEL RHN_CHANNEL_CAID_FK CHANNEL_ARCH_ID
RHNCHANNEL RHN_CHANNEL_CPID_FK CHANNEL_PRODUCT_ID
RHNCHANNEL RHN_CHANNEL_PRODUCT_NAME_CH_FK PRODUCT_NAME_ID
RHNCHANNELARCH RHN_CARCH_ATID_FK ARCH_TYPE_ID
RHNCHANNELCOMPS RHN_CHANNELCOMPS_CID_FK CHANNEL_ID
RHNCHANNELFAMILY RHN_CHANNEL_FAMILY_ORG_FK ORG_ID
RHNCHANNELNEWESTPACKAGE RHN_CNP_EID_FK EVR_ID
RHNCHANNELNEWESTPACKAGE RHN_CNP_PAID_FK PACKAGE_ARCH_ID
RHNCHANNELPARENT RHN_CP_PARENT_CH_FK PARENT_CHANNEL
RHNCHANNELPERMISSION RHN_CPERM_RID_FK ROLE_ID
RHNCHANNELPERMISSION RHN_CPERM_UID_FK USER_ID
RHNCLIENTCAPABILITY RHN_CLIENTCAP_CAP_NID_FK CAPABILITY_NAME_ID
RHNCONFIGCHANNEL RHN_CONFCHAN_CTID_FK CONFCHAN_TYPE_ID
RHNCONFIGFILE RHN_CONFFILE_CFNID_FK CONFIG_FILE_NAME_ID
RHNCONFIGFILE RHN_CONFFILE_SID_FK STATE_ID
RHNCONFIGREVISION RHN_CONFREVISION_CCID_FK CONFIG_CONTENT_ID
RHNCONFIGREVISION RHN_CONFREVISION_CID_FK CHANGED_BY_ID
RHNCONFIGREVISION RHN_CONFREVISION_CIID_FK CONFIG_INFO_ID
RHNCONFIGREVISION RHN_CONF_REV_CFTI_FK CONFIG_FILE_TYPE_ID
RHNCPU RHN_CPU_CAID_FK CPU_ARCH_ID
RHNCRYPTOKEY RHN_CRYPTOKEY_CKTID_FK CRYPTO_KEY_TYPE_ID
RHNCUSTOMDATAKEY RHN_CDATAKEY_CB_FK CREATED_BY
RHNCUSTOMDATAKEY RHN_CDATAKEY_LMB_FK LAST_MODIFIED_BY
RHNDISTCHANNELMAP RHN_DCM_CAID_FK CHANNEL_ARCH_ID
RHNDISTCHANNELMAP RHN_DCM_CID_FK CHANNEL_ID
RHNDOWNLOADS RHN_DL_CFID_FK CHANNEL_FAMILY_ID
RHNDOWNLOADS RHN_DL_DLTYPE_FK DOWNLOAD_TYPE
RHNDOWNLOADS RHN_DL_FID_FK FILE_ID
RHNEMAILADDRESS RHN_EADDRESS_SID_FK STATE_ID
RHNERRATA RHN_ERRATA_OID_FK ORG_ID
RHNERRATA RHN_ERRATA_SEVID_FK SEVERITY_ID
RHNERRATAFILE RHN_ERRATAFILE_TYPE_FK TYPE
RHNERRATAFILEPACKAGESOURCE RHN_EFILEPS_PID_FK PACKAGE_ID
RHNERRATAFILETMP RHN_ERRATAFILETMP_TYPE_FK TYPE
RHNERRATANOTIFICATIONQUEUE RHN_ENQUEUE_OID_FK ORG_ID
RHNERRATATMP RHN_ERRATATMP_OID_FK ORG_ID
RHNFAQ RHN_FAQ_CLASS_FK CLASS_ID
RHNFILE RHN_FILE_OID_FK ORG_ID
RHNFILEDOWNLOAD RHN_FILEDL_FID_FK FILE_ID
RHNFILELISTMEMBERS RHN_FLMEMBERS_CFNID_FK CONFIG_FILE_NAME_ID
RHNGRAILCOMPONENTS RHN_GRAIL_COMP_ROLE_TYPE_FK ROLE_REQUIRED
RHNKICKSTARTABLETREE RHN_KSTREE_CID_FK CHANNEL_ID
RHNKICKSTARTABLETREE RHN_KSTREE_IT_FK INSTALL_TYPE
RHNKICKSTARTABLETREE RHN_KSTREE_KSTREETYPE_FK KSTREE_TYPE
RHNKICKSTARTCHILDCHANNEL RHN_KS_CC_KSD_FK KSDATA_ID
RHNKICKSTARTCOMMAND RHN_KSCOMMAND_KCNID_FK KS_COMMAND_NAME_ID
RHNKICKSTARTDEFAULTS RHN_KSD_KVT_FK VIRTUALIZATION_TYPE
RHNKICKSTARTDEFAULTS RHN_KSD_SPID_FK SERVER_PROFILE_ID
RHNKICKSTARTPACKAGE RHN_KSPACKAGE_PNID_FK PACKAGE_NAME_ID
RHNKICKSTARTSESSION RHN_KSS_KVT_FK VIRTUALIZATION_TYPE
RHNKICKSTARTSESSION RHN_KS_SESSION_AID_FK ACTION_ID
RHNKICKSTARTSESSION RHN_KS_SESSION_KSID_FK KICKSTART_ID
RHNKICKSTARTSESSION RHN_KS_SESSION_KSSSID_FK STATE_ID
RHNKICKSTARTSESSION RHN_KS_SESSION_KSTID_FK KSTREE_ID
RHNKICKSTARTSESSION RHN_KS_SESSION_SCHED_FK SCHEDULER
RHNKICKSTARTSESSION RHN_KS_SESSION_SPID_FK SERVER_PROFILE_ID
RHNKICKSTARTSESSIONHISTORY RHN_KS_SESSIONHIST_AID_FK ACTION_ID
RHNKICKSTARTSESSIONHISTORY RHN_KS_SESSIONHIST_STAT_FK STATE_ID
RHNMESSAGE RHN_M_MT_FK MESSAGE_TYPE
RHNMESSAGE RHN_M_PRIORITY_FK PRIORITY
RHNMONITOR RHN_MONITOR_GRANULARITY_FK GRANULARITY
RHNORGCHANNELSETTINGS RHN_ORGCSETTINGS_CID_FK CHANNEL_ID
RHNORGCHANNELSETTINGS RHN_ORGCSETTINGS_SID_FK SETTING_ID
RHNORGENTITLEMENTS RHN_ORG_ENT_EID_FK ENTITLEMENT_ID
RHNORGINFO RHN_ORGINFO_DGT_FK DEFAULT_GROUP_TYPE
RHNPACKAGE RHN_PACKAGE_EID_FK EVR_ID
RHNPACKAGE RHN_PACKAGE_GROUP_FK PACKAGE_GROUP
RHNPACKAGE RHN_PACKAGE_PAID_FK PACKAGE_ARCH_ID
RHNPACKAGE RHN_PACKAGE_SRCRPMID_FK SOURCE_RPM_ID
RHNPACKAGEARCH RHN_PARCH_ATID_FK ARCH_TYPE_ID
RHNPACKAGEDELTAELEMENT RHN_PDELEMENT_TPID_FK TRANSACTION_PACKAGE_ID
RHNPACKAGENEVRA RHN_PKGNEVRA_EID_FK EVR_ID
RHNPACKAGENEVRA RHN_PKGNEVRA_PAID_FK PACKAGE_ARCH_ID
RHNPACKAGESENSEMAP RHN_PKG_SENSEMAP_SID_FK SENSE_ID
RHNPACKAGESIGNATURE RHN_PKG_SIG_TID_FK TYPE_ID
RHNPACKAGESOURCE RHN_PKGSRC_GROUP_FK PACKAGE_GROUP
RHNPACKAGESOURCE RHN_PKGSRC_OID_FK ORG_ID
RHNPRODUCT RHN_PRODUCT_CAT_FK PRODUCT_LINE_ID
RHNPROXYINFO RHN_PROXY_INFO_PEID_FK PROXY_EVR_ID
RHNPUSHCLIENT SYS_C005068 STATE_ID
RHNREGTOKENCHANNELS RHN_REG_TOK_CHN_SGS_FK CHANNEL_ID
RHNREGTOKENENTITLEMENT RHN_REG_TOK_ENT_SGTID_FK SERVER_GROUP_TYPE_ID
RHNREGTOKENGROUPS RHN_REG_TOK_GRP_SGS_FK SERVER_GROUP_ID
RHNSATELLITEINFO RHN_SATELLITE_INFO_EID_FK EVR_ID
RHNSATELLITESERVERGROUP RHN_SATSG_SGTYPE_FK SERVER_GROUP_TYPE
RHNSAVEDSEARCH RHN_SAVEDSEARCH_TYPE_FK TYPE
RHNSERVER RHN_SERVER_PSID_FK PROVISION_STATE_ID
RHNSERVER RHN_SERVER_SAID_FK SERVER_ARCH_ID
RHNSERVERACTION RHN_SERVER_ACTION_STATUS_FK STATUS
RHNSERVERACTIONPACKAGERESULT RHN_SAP_RESULT_APID_FK ACTION_PACKAGE_ID
RHNSERVERACTIONVERIFYMISSING RHN_SACTIONVM_AID_FK ACTION_ID
RHNSERVERACTIONVERIFYMISSING RHN_SACTIONVM_PAID_FK PACKAGE_ARCH_ID
RHNSERVERACTIONVERIFYMISSING RHN_SACTIONVM_PCID_FK PACKAGE_CAPABILITY_ID
RHNSERVERACTIONVERIFYMISSING RHN_SACTIONVM_PEID_FK PACKAGE_EVR_ID
RHNSERVERACTIONVERIFYMISSING RHN_SACTIONVM_PNID_FK PACKAGE_NAME_ID
RHNSERVERACTIONVERIFYRESULT RHN_SACTIONVR_AID_FK ACTION_ID
RHNSERVERACTIONVERIFYRESULT RHN_SACTIONVR_PAID_FK PACKAGE_ARCH_ID
RHNSERVERACTIONVERIFYRESULT RHN_SACTIONVR_PCID_FK PACKAGE_CAPABILITY_ID
RHNSERVERACTIONVERIFYRESULT RHN_SACTIONVR_PEID_FK PACKAGE_EVR_ID
RHNSERVERACTIONVERIFYRESULT RHN_SACTIONVR_PNID_FK PACKAGE_NAME_ID
RHNSERVERARCH RHN_SARCH_ATID_FK ARCH_TYPE_ID
RHNSERVERCUSTOMDATAVALUE RHN_SCDV_CB_FK CREATED_BY
RHNSERVERCUSTOMDATAVALUE RHN_SCDV_LMB_FK LAST_MODIFIED_BY
RHNSERVERGROUPTYPEFEATURE RHN_SGT_FID_FK FEATURE_ID
RHNSERVERPACKAGE RHN_SERVERPACKAGE_EID_FK EVR_ID
RHNSERVERPACKAGE RHN_SERVERPACKAGE_NID_FK NAME_ID
RHNSERVERPACKAGE RHN_SERVERPACKAGE_PAID_FK PACKAGE_ARCH_ID
RHNSERVERPROFILE RHN_SERVER_PROFILE_PTYPE_FK PROFILE_TYPE_ID
RHNSERVERPROFILEPACKAGE RHN_SPROFILE_EVRID_FK EVR_ID
RHNSERVERPROFILEPACKAGE RHN_SPROFILE_NID_FK NAME_ID
RHNSGTYPEBASEADDONCOMPAT RHN_SGT_BAC_AID_FK ADDON_ID
RHNSGTYPEBASEADDONCOMPAT RHN_SGT_BAC_BID_FK BASE_ID
RHNSNAPSHOT RHN_SNAPSHOT_INVALID_FK INVALID
RHNSNAPSHOTPACKAGE RHN_SNAPSHOTPKG_NID_FK NEVRA_ID
RHNSOLARISPATCH RHN_SOLARIS_P_PT_FK PATCH_TYPE
RHNSOLARISPATCHEDPACKAGE RHN_SOLARIS_PATCHEDP_PID_FK PATCH_ID
RHNSOLARISPATCHEDPACKAGE RHN_SOLARIS_PATCHEDP_PNID_FK PACKAGE_NEVRA_ID
RHNTAG RHN_TAG_NID_FK NAME_ID
RHNTEXTMESSAGE RHN_TM_MESSAGE_ID_FK MESSAGE_ID
RHNTRANSACTIONELEMENT RHN_TRANSELEM_TPID_FK TRANSACTION_PACKAGE_ID
RHNTRANSACTIONPACKAGE RHN_TRANSPACK_EID_FK EVR_ID
RHNTRANSACTIONPACKAGE RHN_TRANSPACK_NID_FK NAME_ID
RHNTRANSACTIONPACKAGE RHN_TRANSPACK_PAID_FK PACKAGE_ARCH_ID
RHNUSERINFO RHN_USER_INFO_TZID_FK TIMEZONE_ID
RHNUSERINFOPANE RHN_USR_INFO_PANE_PID_FK PANE_ID
RHNUSERMESSAGE RHN_UM_MESSAGE_ID_FK MESSAGE_ID
RHNUSERMESSAGE RHN_UM_STATUS_FK STATUS
RHNVERSIONINFO RHN_VERSIONINFO_EID_FK EVR_ID
RHNVIRTUALINSTANCEEVENTLOG RHN_VIEL_ET_FK EVENT_TYPE
RHNVIRTUALINSTANCEEVENTLOG RHN_VIEL_NEW_STATE_FK NEW_STATE
RHNVIRTUALINSTANCEEVENTLOG RHN_VIEL_OLD_STATE_FK OLD_STATE
RHNVIRTUALINSTANCEINFO RHN_VII_IT_FK INSTANCE_TYPE
RHNVIRTUALINSTANCEINFO RHN_VII_STATE_FK STATE
RHNVIRTUALINSTANCEINSTALLLOG RHN_VIIL_KS_SID_FK KS_SESSION_ID
RHNWEBCONTACTCHANGELOG RHN_WCON_CL_CSID_FK CHANGE_STATE_ID
RHNWEBCONTACTCHANGELOG RHN_WCON_CL_WCON_FROM_ID_FK WEB_CONTACT_FROM_ID
RHN_COMMAND RHN_CMMND_CMDGR_GROUP_NAME_FK GROUP_NAME
RHN_COMMAND RHN_CMMND_COMCL_CLASS_NAME_FK COMMAND_CLASS
RHN_COMMAND RHN_CMMND_SYS_REQS_FK SYSTEM_REQUIREMENTS
RHN_COMMAND_PARAMETER RHN_CPARM_SDTYP_NAME_FK DATA_TYPE_NAME
RHN_COMMAND_PARAMETER RHN_CPARM_WDGT_FLD_WDGT_N_FK FIELD_WIDGET_NAME
RHN_COMMAND_PARAM_THRESHOLD RHN_COPTR_CMD_ID_CMD_CL_FK COMMAND_ID, COMMAND_CLASS
RHN_COMMAND_PARAM_THRESHOLD RHN_COPTR_M_THR_M_CMD_CL_FK COMMAND_CLASS, THRESHOLD_METRIC_ID
RHN_COMMAND_PARAM_THRESHOLD RHN_COPTR_THRTP_THRES_TYPE_FK THRESHOLD_TYPE_NAME
RHN_COMMAND_QUEUE_EXECS RHN_CQEXE_SATCL_NSAINT_ID_FK NETSAINT_ID, TARGET_TYPE
RHN_CONFIG_PARAMETER RHN_CONFP_SCRTY_SEC_TYPE_FK SECURITY_TYPE
RHN_CONTACT_GROUPS RHN_NTFMT_CNTGP_ID_FK NOTIFICATION_FORMAT_ID
RHN_CONTACT_METHODS RHN_CMETH_NTFMT_ID_FK NOTIFICATION_FORMAT_ID
RHN_CONTACT_METHODS RHN_CMETH_PAGER_TYPE_ID_FK PAGER_TYPE_ID
RHN_DB_ENVIRONMENT RHN_DBENV_ENVIR_ENVIRONMENT_FK ENVIRONMENT
RHN_HOST_CHECK_SUITES RHN_HSTCK_CKSUT_SUITE_ID_FK SUITE_ID
RHN_OS_COMMANDS_XREF RHN_OSCXR_CMMND_COMMANDS_ID_FK COMMANDS_ID
RHN_PROBE_PARAM_VALUE RHN_PPVAL_CMD_ID_PARM_NM_FK COMMAND_ID, PARAM_NAME
RHN_REDIRECT_CRITERIA RHN_RDRCR_RDRMT_MATCH_NM_FK MATCH_PARAM
RHN_SAT_CLUSTER RHN_SATCL_CMDTG_RECID_TAR_FK RECID, TARGET_TYPE
RHN_SAT_CLUSTER RHN_SATCL_PHSLC_PHYS_LOC_FK PHYSICAL_LOCATION_ID
RHN_SAT_NODE RHN_SATND_CMDTG_RID_TAR_TY_FK RECID, TARGET_TYPE
RHN_SERVER_MONITORING_INFO RHN_HOST_SERVER_NAME_FK OS_ID
VALID_COUNTRIES_TL VALID_COUNTRIES_TL_CODE CODE
WEB_CUSTOMER_NOTIFICATION WEB_CUST_NOT_OID_FK ORG_ID
WEB_USER_CONTACT_PERMISSION CONTPERM_WBUSERID_FK WEB_USER_ID
WEB_USER_PERSONAL_INFO PERSONAL_INFO_WEB_USER_ID_FK WEB_USER_ID
WEB_USER_PERSONAL_INFO WUPI_PREFIX_FK PREFIX
WEB_USER_SITE_INFO WUSI_TYPE_FK TYPE

Invalid objects

Invalid object does not mean a problem sometimes. Sometimes will fix itself as is is executed or accessed. But if there is an error in USER_ERRORS table, you are in trouble then...

The sql file which will compile these objects is created for you.

Invalids

Object nameTypeErrorAt line
COMMAND_PARAMETER_THRESHOLDSYNONYMNo error. It will be fixed itself later. 
Generated by OraSchemaDoc, (c) Petr Vanek, 2005; Aram Kananov, 2002, on Fri Jun 13 14:06:14 2008