Home » RDBMS Server » Performance Tuning » SQl ID from peoplesoft process (Oracle 10g Hp-UX)
SQl ID from peoplesoft process [message #539695] Wed, 18 January 2012 02:31 Go to next message
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
Re: SQl ID from peoplesoft process [message #539697 is a reply to message #539695] Wed, 18 January 2012 02:34 Go to previous messageGo to next message
Michel Cadot
Messages: 67948
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is the "process instance"?

Regards
Michel
Re: SQl ID from peoplesoft process [message #539698 is a reply to message #539697] Wed, 18 January 2012 02:36 Go to previous messageGo to next message
pokhraj_d
Messages: 117
Registered: December 2007
Senior Member
The process Number is 6866645
Re: SQl ID from peoplesoft process [message #539709 is a reply to message #539698] Wed, 18 January 2012 03:33 Go to previous messageGo to next message
Michel Cadot
Messages: 67948
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
Re: SQl ID from peoplesoft process [message #539710 is a reply to message #539709] Wed, 18 January 2012 03:36 Go to previous messageGo to next message
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
Re: SQl ID from peoplesoft process [message #539712 is a reply to message #539710] Wed, 18 January 2012 03:51 Go to previous message
Michel Cadot
Messages: 67948
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
Previous Topic: finding changed sql plans
Next Topic: Join with 30 tables
Goto Forum:
  


Current Time: Wed Sep 22 07:30:04 CDT 2021