Strange query occuring on database accessed by a job
Posted: Fri Jul 22, 2011 8:37 am
Hello,
This week we have observed a strange query consuming a lot of CPU on our database (50% on 8-CPU database server)
After some investigation it appears that the process launching this query is OSH, so the query is originating clearly from DataStage.
We have a identified two cyclic jobs (every 15 minutes) that connect to a lot of tables in the database. After observing those jobs we do not find the strange query within those jobs. So we think that this query is performed by DataStage itself.
Did you observed this query on your database ? Is this query legit ? Can we do something to muzzle this query ?
Thanks for your response, I'll respond to all your questions if you have some.
This week we have observed a strange query consuming a lot of CPU on our database (50% on 8-CPU database server)
Code: Select all
SELECT TABLE_NAME
FROM ALL_TABLES
WHERE ( TABLE_NAME = UPPER('DBA_EXTENTS' )
AND OWNER = UPPER('SYS') )
OR EXISTS
(SELECT view_name
FROM ALL_VIEWS
WHERE ( VIEW_NAME = UPPER('DBA_EXTENTS')
AND OWNER =UPPER('SYS') )
)
We have a identified two cyclic jobs (every 15 minutes) that connect to a lot of tables in the database. After observing those jobs we do not find the strange query within those jobs. So we think that this query is performed by DataStage itself.
Did you observed this query on your database ? Is this query legit ? Can we do something to muzzle this query ?
Thanks for your response, I'll respond to all your questions if you have some.