43 lines
986 B
SQL
43 lines
986 B
SQL
/*
|
|
*
|
|
*
|
|
* 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'
|
|
/
|
|
|
|
|
|
|