OraFAQ Forum: Performance Tuning » SQl ID from peoplesoft process

Home » RDBMS Server » Performance Tuning » SQl ID from peoplesoft process (Oracle 10g Hp-UX)

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

SQl ID from peoplesoft process [message #539695]

Wed, 18 January 2012 02:31

pokhraj_d
Messages: 117
Registered: December 2007

Senior Member

Hi Team,

Our developer team has given two process instance number[the process is running from Peoplesoft] that are running beyond the time limit.
I need to know the SQL ID from the process instance number.
Is there is any way to know the SQL ID?

Thanks-
P

Report message to a moderator

Re: SQl ID from peoplesoft process [message #539697 is a reply to message #539695]

Wed, 18 January 2012 02:34

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

Senior Member
Account Moderator

What is the "process instance"?

Regards
Michel

Report message to a moderator

Re: SQl ID from peoplesoft process [message #539698 is a reply to message #539697]

Wed, 18 January 2012 02:36

pokhraj_d
Messages: 117
Registered: December 2007

Senior Member

The process Number is 6866645

Report message to a moderator

Re: SQl ID from peoplesoft process [message #539709 is a reply to message #539698]

Wed, 18 January 2012 03:33

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

Senior Member
Account Moderator

I wanted to ask what does mean the term "process instance"? Which process is this?

Regards
Michel

Report message to a moderator

Re: SQl ID from peoplesoft process [message #539710 is a reply to message #539709]

Wed, 18 January 2012 03:36

pokhraj_d
Messages: 117
Registered: December 2007

Senior Member

This is a peoplesoft process.
The process instance is a process number when any sql is fired from sysadm schema.

Thanks-
P

Report message to a moderator

Re: SQl ID from peoplesoft process [message #539712 is a reply to message #539710]

Wed, 18 January 2012 03:51

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

Senior Member
Account Moderator

So this is the one you have in v$session.
Verify it is really this one.

Regards
Michel

Report message to a moderator

Previous Topic:	finding changed sql plans
Next Topic:	Join with 30 tables

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 04:54:12 CDT 2024