I am currently helping some organization with the performance of its Oracle database. They use Oracle 11gR2 Standard Edition in Windows 2008. As there are no business performance packages available in this standard edition, I had to use v $ sql to query the most running ones to identify bottlenecks in performance. Using the following query:
SELECT * SINCE ( SELECT sql_text, sql_id, time elapsed, plsql_exec_time, cpu_time, executions search charges buffer_gets, elapsed time / executions FROM v $ sql - order by elapsed time / executions)) where rownum <= 10;
I returned some queries that I will analyze, but there are two rows in the results that I can not understand the reason why they should exist here:
As you can see, the query runs in
sys.job $, so it must be related to the Oracle works established in this database. My questions are:
1) What do these two rows mean? I must consult
dba_jobs table for more information? How should I consult them and what should I look for?
2) Both consultations seem identical, why are they repeated twice in the query result?