Strange query occuring on database accessed by a job

niremy · Post by **niremy** » 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)

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') )
  )

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.