Re: DBA_JOBS_RUNNING view in OPS environment

From: zhu chao <zhuchao_at_gmail.com>
Date: Mon, 21 Mar 2005 13:40:52 +0800
Message-ID: <962cf44b05032021406af0c14@mail.gmail.com>

create or replace view DBA_JOBS_RUNNING as   select v.SID, v.id2 JOB, j.FAILURES,
    LAST_DATE, substr(to_char(last_date,'HH24:MI:SS'),1,8) LAST_SEC,     THIS_DATE, substr(to_char(this_date,'HH24:MI:SS'),1,8) THIS_SEC,     j.field1 INSTANCE
  from sys.job$ j, v$lock v
  where v.type = 'JQ' and j.job (+)= v.id2 /

create or replace view v_$lock as select * from v$lock; create or replace public synonym v$lock for v_$lock;

SQL> select * from V$FIXED_VIEW_DEFINITION where view_name='V$LOCK';

VIEW_NAME

---

VIEW_DEFINITION

---

V$LOCK
select ADDR , KADDR , SID , TYPE , ID1 , ID2 , LMODE , REQUEST , CTIME , BLOCK from GV$LOCK where inst_id = USERENV('Instance')

On Sun, 20 Mar 2005 15:08:03 -0500, Sami Seerangan <dba.orcl_at_gmail.com> wrote:
> 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
>

-- 
Regards
Zhu Chao
www.cnoug.org
--
http://www.freelists.org/webpage/oracle-l

Received on Mon Mar 21 2005 - 00:44:27 CST