Home arrow Forum
psadmin.org
Welcome, Guest
Please Login or Register.    Lost Password?
psadmin.org PeopleSoft Technical Administrator
what sql are running (1 viewing) (1) Guest
Go to bottom Post Reply Favoured: 0
TOPIC: what sql are running
#122
Guest (Visitor)
Click here to see the profile of this user
Birthdate:
what sql are running 7 Months, 3 Weeks ago  
I am just wondering I have TOAD, Oracle Database 9.0, PSHRMS 8.3, PT 8.22.

I want to look in TOAD what process are running(like payroll processing, benadmin,etc) and who is ruuning in TOAD. is there any way to look into database or unix.
Enter code here   
Please note, although no boardcode and smiley buttons are shown, they are still useable
 
Logged Logged  
  Reply Quote
#124
PSADMIN (Admin)
Admin
Posts: 68
graph
User Online Now Click here to see the profile of this user
Re:what sql are running 7 Months, 3 Weeks ago  
you can query the PSPRCSRQST table for the details of processes running/ran/queued.

For example the following query should give you the result of queued processes.

select prcsinstance, prcsname, servernamerqst, rundttm, rqstdttm, lastupddttm from PSPRCSRQST where RUNSTATUS=5 order by rundttm, rqstdttm, lastupddttm, prcsname, servernamerqst;

To decode runstatus check with the PSXLATITEM table.
Enter code here   
Please note, although no boardcode and smiley buttons are shown, they are still useable
 
Logged Logged  
  Reply Quote
#142
Ajay (Visitor)
Click here to see the profile of this user
Birthdate:
Re:what sql are running 5 Months, 3 Weeks ago  
You can also query v$session to see specifically who is using TOAD
Enter code here   
Please note, although no boardcode and smiley buttons are shown, they are still useable
 
Logged Logged  
  Reply Quote
Go to top Post Reply
Powered by PsAdmin.orgget the latest posts directly to your desktop
 
© 2009 PSADMIN.org
PSAdmin.org is for & by the PeopleSoft Administrators to share their Experience.