I am currently helping some organization with their Oracle database performance. They are using Oracle 11gR2 Standard Edition in Windows 2008. As there are no enterprise performance packages available on this standard edition, I've had to use v$sql to query longest-running ones to identify performance bottlenecks. Using the query below :
SELECT * FROM ( SELECT sql_text, sql_id, elapsed_time, plsql_exec_time, cpu_time, executions, fetches, loads, buffer_gets, elapsed_time / executions FROM v$sql -- order by elapsed_time / executions) ) where rownum <= 10;
It returned some queries which I will look into, but there are two rows in the results that I cannot understand the reason why they should exist here:
As you can see, the query executes on
sys.job$, so it should be related to oracle jobs set on this database. My questions are :
1) What does these two rows mean? Should I query
dba_jobs table for more information? How should I query them and what should I look for?
2) Both of the queries look identical, why they are echoed twice in the query result?