Check your joins in the procedure body....


-----Original Message-----
From: Mahesh Sawant
[mailto:oracledba-ezmlmshield-x31327943.[Email address protected]
Sent: 30 August 2006 12:03
To: LazyDBA Discussion
Subject: Check execution of process


Hi All,

I have a package body for which execution time is 2 hrs. Some time the
process got hang while executing the same.

Can any one please let me know how to check the package is executing or
not?


Thanks & Regards

Mahesh Sawant


________________________________

Tech Mahindra Limited, Pune
* +0091 20 56018100, Extn: 3845

* (Mob) 9869263680






========================================================================
====================================================

Tech Mahindra, formerly Mahindra-British Telecom.

Disclaimer:

This message and the information contained herein is proprietary and
confidential and subject to the Tech Mahindra policy statement, you may
review at <a
href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahind
ra.com/Disclaimer.html</a> externally and <a
href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahind
ra.com/Disclaimer.html</a> internally within Tech Mahindra.

========================================================================
====================================================


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page