/*
*
*
*  This query gives the start name of following type of tables in OEM
*  historical information.
*
*  <table_start>_BASE
*  <table_start>_HOUR
*  <table_start>_DAY
*  <table_start>_WEEK
*  <table_start>_MONTH
*  <table_start>_YEAR
*
*
*/

SELECT s.HOST
     , S.NAME
     , M.MODULE_LABEL
     , c.CLASS_LABEL
     , c.CONTAINER_CLASS_LABEL
     , r.RES_LABEL
     ,  'VP_' || c.IS_UDS || '_' ||  S.SVC_ID || '_' || M.MOD_ID || '_' || C.CLS_ID "Tables" 
FROM   VP_SERVICE_REF s
     , VP_MODULE_REF M
     , VP_CLASS_REF C 
     , VP_RESOURCE_REF R 
WHERE  S.SVC_ID = M.SVC_ID 
  AND  C.SVC_ID = S.SVC_ID 
  AND  C.MOD_ID = M.MOD_ID 
  AND  R.CLS_ID = C.CLS_ID 
  AND  R.MOD_ID = M.MOD_ID 
  AND  R.SVC_ID = S.SVC_ID 
  AND  s.HOST = 'DB01.WHISTLER.SERVISTA.COM' 
  AND  s.NAME = 'DB01.WHISTLER.SERVISTA.COM' 
--  AND  C.CONTAINER_CLASS_LABEL = 'Storage' 
--  AND  C.CLASS_LABEL = 'Tablespace'
--  AND  R.RES_COL = 'Used Blocks'
/