OraFAQ Forum: Server Administration » How can I find session which had started(submited) job ?

Home » RDBMS Server » Server Administration » How can I find session which had started(submited) job ?

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

How can I find session which had started(submited) job ? [message #182925]

Tue, 18 July 2006 13:52

aimak
Messages: 3
Registered: June 2006
Location: Russia

Junior Member

I have this problem: - All users connect to database as user OD. And when one session has submited JOB, his Oracleuser=OD. But all sessions which have connected to database have ORacleUser=OD and I can not find - Who generated(submited) this JOB ??????

P.S. Sorry my bad English ! Smile

Report message to a moderator

Re: How can I find session which had started(submited) job ? [message #182933 is a reply to message #182925]

Tue, 18 July 2006 14:34

aciolac
Messages: 242
Registered: February 2006

Senior Member

Slushai, obiasni poprosce cto ty hoceshi. Iz tvoego posta nicego ne poneatno. Cto znacit JOB? Eto task, kotoryi zapuskaet v dannyi miment polzovateli, ili eto fishka Oracle, kotoraia pozvoleaet zapuskati scripty v oprezelennoe vremea?

Report message to a moderator

Re: How can I find session which had started(submited) job ? [message #182977 is a reply to message #182933]

Wed, 19 July 2006 01:16

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Ruski nije moj materinji jezik, ali ga mogu razumjeti u dovoljnoj mjeri da znam o cemu pises.

Now, I wonder how many ORAFAQ Forum members understood what you and me have said (furthermore, you could have written it in Cyrilic. What then?!?).

I guess it would be a better idea to keep discussion in English, no matter how good (or bad) it is.

Report message to a moderator

Re: How can I find session which had started(submited) job ? [message #182979 is a reply to message #182977]

Wed, 19 July 2006 01:21

aciolac
Messages: 242
Registered: February 2006

Senior Member

No one problem from my part. So, explain, please more concret your question. As I understand, you want to see sessions, which are opened by Oracle Server(not users personally) during the executing JOB's. Not so?

Report message to a moderator

Re: How can I find session which had started(submited) job ? [message #182981 is a reply to message #182977]

Wed, 19 July 2006 01:32

aciolac
Messages: 242
Registered: February 2006

Senior Member

If so, then views DBA_JOBS and DBA_JOBS_RUNNING can help you.

Report message to a moderator

Previous Topic:	can segment extend if file is autoextend off
Next Topic:	Regarding Extent Allocation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 10:30:15 CDT 2024