Home » RDBMS Server » Performance Tuning » Process Threads (Oracl 9.2x, Unix)
Process Threads [message #279427] Thu, 08 November 2007 05:39 Go to next message
balajisundar
Messages: 29
Registered: October 2007
Junior Member
Hi,

Can any body let me know the command to find the number of process threads that is running on a procedure at particular instant of time.

The scenario which I'm looking at is i have executed a procedure from different consoles using a single user id. The procedure consume huge amount of time so better i wanted to find the number of threads that are currently running on my procedure.

Thanks,
Balaji

[Updated on: Thu, 08 November 2007 05:43]

Report message to a moderator

Re: Process Threads [message #279428 is a reply to message #279427] Thu, 08 November 2007 05:48 Go to previous messageGo to next message
Michel Cadot
Messages: 68658
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is no command and, afaik, no way to get this information.
You have to make your procedure "register" it is in this procedure using dbms_application_info package.

Regards
Michel

Report message to a moderator

Re: Process Threads [message #279629 is a reply to message #279428] Fri, 09 November 2007 07:45 Go to previous message
balajisundar
Messages: 29
Registered: October 2007
Junior Member
Hi,

Thank You..


Regards,
Balaji

Report message to a moderator

Previous Topic: Index overhead
Next Topic: Perfomance in Delete and Insert
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jun 12 19:13:14 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.