OraFAQ Forum: SQL & PL/SQL » all_scheduler_job_run_details session_id column

Home » SQL & PL/SQL » SQL & PL/SQL » all_scheduler_job_run_details session_id column (Oracle 11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

all_scheduler_job_run_details session_id column [message #640017]

Tue, 21 July 2015 06:58

dag1ngapr1nce
Messages: 19
Registered: June 2012
Location: UK

Junior Member

Hi anyone / everyone

I'm running an Oracle concurrent job parrellellized to run a main process and 2 slave processes - This creates 2 entries in all_scheduler_job_run_details for the slave processes. The session_id entries for these 2 records is as follows:

SESSION_ID
281,367
519,159

I can link 281 and 519 to V$SESSION as the SID (Session Id), however I don't know what 367 and 159 values represent!

It is not the serial Id and this is not a RAC instance

Can anyone advise?

Thanks

Report message to a moderator

Re: all_scheduler_job_run_details session_id column [message #640018 is a reply to message #640017]

Tue, 21 July 2015 07:17

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Can anyone advise?

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use [code] tags and make your code easier to read

Report message to a moderator

Re: all_scheduler_job_run_details session_id column [message #640019 is a reply to message #640017]

Tue, 21 July 2015 07:24

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

1) Yes, this is the sid
2) Are you sure this is not serial#?

Report message to a moderator

Re: all_scheduler_job_run_details session_id column [message #640038 is a reply to message #640019]

Tue, 21 July 2015 08:46

dag1ngapr1nce
Messages: 19
Registered: June 2012
Location: UK

Junior Member

Select j.SESSION_ID
  From all_scheduler_job_run_details j
  Where j.JOB_NAME In ('VT_450_1_ASGN', 'VT_450_2_ASGN', 'VT_450_1_TRXN', 'VT_450_2_TRXN');

$Z:\MyDev\print1.jpg$

[Updated on: Tue, 21 July 2015 08:48]

Report message to a moderator

Re: all_scheduler_job_run_details session_id column [message #640039 is a reply to message #640038]

Tue, 21 July 2015 08:48

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

And?

Report message to a moderator

Re: all_scheduler_job_run_details session_id column [message #640040 is a reply to message #640039]

Tue, 21 July 2015 08:50

dag1ngapr1nce
Messages: 19
Registered: June 2012
Location: UK

Junior Member

see attached

Attachment: print1.jpg
(Size: 17.22KB, Downloaded 686 times)

[Updated on: Tue, 21 July 2015 08:51]

Report message to a moderator

Re: all_scheduler_job_run_details session_id column [message #640041 is a reply to message #640040]

Tue, 21 July 2015 08:52

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Retry.
Do not use "Quick Reply", use Reply -> Browse -> Upload File

Report message to a moderator

Re: all_scheduler_job_run_details session_id column [message #640042 is a reply to message #640040]

Tue, 21 July 2015 08:54

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

dag1ngapr1nce wrote on Tue, 21 July 2015 15:50

see attached

OK, And now?

Note: you should use SQL*Plus, it is easier to post text and you do not depend on your program bugs.

Report message to a moderator

Re: all_scheduler_job_run_details session_id column [message #640044 is a reply to message #640042]

Tue, 21 July 2015 08:57

dag1ngapr1nce
Messages: 19
Registered: June 2012
Location: UK

Junior Member

ok, please bear with me, thanks for patience

Report message to a moderator

Re: all_scheduler_job_run_details session_id column [message #640047 is a reply to message #640044]

Tue, 21 July 2015 08:59

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You didn't answer my question:

Quote:

2) Are you sure this is not serial#?

Report message to a moderator

Re: all_scheduler_job_run_details session_id column [message #640048 is a reply to message #640047]

Tue, 21 July 2015 09:01

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

OP can be sure & WRONG at the same time.

Report message to a moderator

Re: all_scheduler_job_run_details session_id column [message #640049 is a reply to message #640044]

Tue, 21 July 2015 09:04

dag1ngapr1nce
Messages: 19
Registered: June 2012
Location: UK

Junior Member

SQL> Select session_id, job_name
  2    From all_scheduler_job_run_details j
  3   Where j.job_name In ('VT_451_1_ASGN', 'VT_451_2_ASGN');
SESSION_ID                     JOB_NAME
------------------------------ --------------------------------------------------------------------------------
203,13635                      VT_451_1_ASGN
47,9329                        VT_451_2_ASGN

SQL> Select Sid, serial# From Gv$session gv Where gv.SID In (203, 13635, 47, 9329);
       SID    SERIAL#
---------- ----------
        47       9343
       203      13645

Apologies for delay

Any help appreciated

I dont believe that the second part is the serial# however I'm now wondering whether it is but my issue is a timing one.

[Updated on: Tue, 21 July 2015 09:05]

Report message to a moderator

Re: all_scheduler_job_run_details session_id column [message #640051 is a reply to message #640049]

Tue, 21 July 2015 09:12

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>From all_scheduler_job_run_details j
above reports HISTORY; what happened in the past.

>From Gv$session
above reports the present & both are correct!

NOTICE the current serial# is only slightly higher than existed in the past.

Report message to a moderator

Re: all_scheduler_job_run_details session_id column [message #640052 is a reply to message #640051]

Tue, 21 July 2015 09:16

dag1ngapr1nce
Messages: 19
Registered: June 2012
Location: UK

Junior Member

Ok thanks for that.

When the record was written to all_scheduler_job_run_details I guess that was the Serial# at that point in time which would have tied up with Gv$session (at that point in time). As the processing has continued the Serial# has changed but the session (SID) obviously stays constant??

Report message to a moderator

Re: all_scheduler_job_run_details session_id column [message #640053 is a reply to message #640052]

Tue, 21 July 2015 09:19

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Every SQL statement executed within a session gets it own unique SERIAL#; which is nothing more than a nextval from SEQUENCE

Report message to a moderator

Re: all_scheduler_job_run_details session_id column [message #640054 is a reply to message #640053]

Tue, 21 July 2015 09:27

dag1ngapr1nce
Messages: 19
Registered: June 2012
Location: UK

Junior Member

Brilliant thanks for your help Smile

Smile

Report message to a moderator

Previous Topic:	German Character Set
Next Topic:	Oracle trigger name and after end of the trigger name if mismatch, trigger is compiled and no error.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 13:59:57 CDT 2024