Ban Spam <ban-spam_at_operamail.com> wrote in message news:<Xns9130AFD2EDD32SunnySD_at_24.0.3.73>...
> dong.wang_at_core.ca (Dong) wrote in
> news:772ee5fa.0110041246.70c977cc_at_posting.google.com:
>
> > Hi there,
> >
> > Can somebody help me on this?
> >
> > I'm going to submit some jobs(with the same PL/SQL stored procedure)
> > to the job queue, and inside the stored procedure, I need a way to get
> > current session id (not DBMS_SESSION.UNIQUE_SESSION_ID) or its own job
> > number. Either way would be helpful. I don't have any input from the
> > parameter list.
> >
> > Thanks in advance,
> > Dong
>
> SQL> desc dba_jobs_running
> Name Null? Type
> ------------------------------- -------- ----
> SID NUMBER
> JOB NUMBER
> FAILURES NUMBER
> LAST_DATE DATE
> LAST_SEC VARCHAR2(8)
> THIS_DATE DATE
> THIS_SEC VARCHAR2(8)
>
> select distinct sid from v$mystats;
Thank you very much, the view "v$mystat" works.
Received on Fri Oct 05 2001 - 07:48:52 CDT
