DBA_JOBS_RUNNING view in OPS environment

From: Sami Seerangan <dba.orcl_at_gmail.com>
Date: Sun, 20 Mar 2005 15:08:03 -0500
Message-ID: <f09dd62805032012083bbccb6d@mail.gmail.com>

I thought all the DBA_ views are global(will dipplay all nodes information) in OPS/RAC environment. Is it an expetced behavior?

INST1

---

SQL> select * from dba_jobs_running;
no rows selected  

INST2

---

SQL> select * from dba_jobs_running;  

       SID JOB FAILURES LAST_DATE LAST_SEC
---------- ---------- ---------- ----------------- ------------------------

THIS_DATE         THIS_SEC                   INSTANCE


----------------- ------------------------ ----------

        10        479          0 02/21/05 12:23:57 12:23:57
03/07/05 12:23:58 12:23:58                          0

Thanks
--Sami
--

http://www.freelists.org/webpage/oracle-l Received on Sun Mar 20 2005 - 15:11:53 CST