16.1
How
to delete unwanted Integration Services (seen in wf Monitor)
1 Take back up of the following tables
Create table
OPB_SESS_TASK_LOG_20151020 as select * from OPB_SESS_TASK_LOG ;
Create table
OPB_SWIDGINST_LOG_20151020 as select * from OPB_SWIDGINST_LOG ;
Create table
OPB_DTL_SWIDG_LOG_20151020 as select * from OPB_DTL_SWIDG_LOG ;
Create table
OPB_TASK_INST_RUN_20151020 as select * from OPB_TASK_INST_RUN ;
Create table
OPB_WFLOW_VAR_RUN_20151020 as select * from OPB_WFLOW_VAR_RUN ;
Create table
OPB_WFLOW_DEP_RUN_20151020 as select * from OPB_WFLOW_DEP_RUN ;
Create table
OPB_WFLOW_CACHE_20151020 as select * from OPB_WFLOW_CACHE ;
Create table
OPB_WFLOW_RUN_20151020 as select * from OPB_WFLOW_RUN ;
2. Perform the below delete statements to delete log
tables.
DELETE FROM OPB_SESS_TASK_LOG;
DELETE FROM OPB_SWIDGINST_LOG;
DELETE FROM OPB_DTL_SWIDG_LOG;
DELETE FROM OPB_TASK_INST_RUN;
DELETE FROM OPB_WFLOW_VAR_RUN;
DELETE FROM OPB_WFLOW_DEP_RUN;
DELETE FROM OPB_WFLOW_CACHE;
DELETE FROM OPB_WFLOW_RUN;
COMMIT;
3. Execute the below query for the list of integration
services list under the repository
SELECT * FROM OPB_SERVER_INFO;
4. Delete the duplicate/unwanted integration service
based on the least server id
(ex: 2 – Integration_ABC, 5 - Integration_ABC, perform
delete on 2)
Delete from OPB_SERVER_INFO where server_id in ( 2,5)
-- least server id as it is outdated
16.2 Total
Count of workflows assigned to each Integration Services
SELECT SERVER_NAME,
COUNT(1) AS WF_COUNT
FROM
(SELECT SUBJECT_ID,
WORKFLOW_NAME,
SERVER_NAME,
TRUNC(START_TIME) AS START_TIME,
RANK() OVER (PARTITION BY SUBJECT_ID,
WORKFLOW_NAME ORDER BY START_TIME DESC ) RNK
FROM OPB_WFLOW_RUN
)
WHERE RNK=1
GROUP BY SERVER_NAME
--ORDER BY 1,2,3
SELECT (SELECT REPOSITORY_NAME FROM
OPB_REPOSIT_INFO) AS REPO,
TRUNC (START_TIME) AS START_TIME,
A.SERVER_NAME AS INTEGRATION_SERVICE,
COUNT (*) WF_COUNT
FROM OPB_WFLOW_RUN A
WHERE TRUNC (START_TIME) = ( SELECT MAX (TRUNC (AA.START_TIME))
FROM
OPB_WFLOW_RUN AA
WHERE
AA.WORKFLOW_NAME = A.WORKFLOW_NAME
GROUP BY
A.WORKFLOW_NAME)
GROUP BY
SERVER_NAME,TRUNC (START_TIME)
--ORDER BY 1, 2, 3
16.3 List
of workflows running on each Integration Service
select * from (
select
(SELECT repository_name FROM OPB_REPOSIT_INFO) AS REPO,
subject_id, workflow_name,server_name, trunc(start_time) as
start_time,
rank() over (partition by subject_id, workflow_name order by
start_time desc ) rnk
from OPB_WFLOW_RUN
) where rnk=1
order by 1,2,3
Can you add informatica Repository Tables such as OPB_SESS_TASK_LOG as a source in Informatica? Thanks
ReplyDeleteBig data is a term that describes the large volume of data – both structured and unstructured – that inundates a business on a day-to-day basis. big data projects for students But it’s not the amount of data that’s important. Project Center in Chennai It’s what organizations do with the data that matters. Big data can be analyzed for insights that lead to better decisions and strategic business moves.
ReplyDeleteSpring Framework has already made serious inroads as an integrated technology stack for building user-facing applications. Corporate TRaining Spring Framework the authors explore the idea of using Java in Big Data platforms.
Specifically, Spring Framework provides various tasks are geared around preparing data for further analysis and visualization. Spring Training in Chennai
The Angular Training covers a wide range of topics including Components, Angular Directives, Angular Services, Pipes, security fundamentals, Routing, and Angular programmability. The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training
Đại lý vé máy bay Aivivu
ReplyDeletevé máy bay đi Mỹ bao nhiêu
vé máy bay tết giá rẻ
mua vé máy bay đi Pháp
vé máy bay đi hàn quốc khứ hồi bao nhiêu tiền
vé máy bay đi nhật bản bao nhiêu
thời gian bay từ Hà Nội sang Anh
săn vé máy bay giá rẻ ở đâu
vé máy bay đi San Francisco giá rẻ 2020
gia ve may bay di Los Angeles
combo nha trang 4 ngày 3 đêm 2020
Mua vé máy bay Aivivu, tham khảo
ReplyDeletevé máy bay đi Mỹ giá bao nhiêu
vé máy bay từ los angeles về việt nam
khi nào có chuyến bay từ nhật về việt nam
vé máy bay từ canada về việt nam
thank you for this blog.it helps me to know more about integrated services
ReplyDeletePython Training in chennai | Python Classes in Chennai
Thanks for posting the best information and the blog is very helpful.Amazon Web Services Training in Chennai
ReplyDeleteAwesome post Python Training in Chennai
ReplyDelete