Have you tried explaining the procedure, as in do you know what path
this is going down on?? Have a look at your indexes, especially if you
are using Bitmap indexes.
-----Original Message-----
From: Patil Jitendra (East ADU)
[mailto:oracledba-ezmlmshield-x96161316.[Email address protected]
Sent: 30 August 2006 14:28
To: LazyDBA Discussion
Subject: RE: Check execution of process
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
---------------------------------------------------------------------
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
This e-mail (and any attachments) contains information, which is confidential and intended solely for the attention and use of the named addressee(s). If you are not the intended recipient you must not copy, distribute or use it for any purpose or disclose the contents to any person. If you have received this e-mail in error, please notify us immediately at [Email address protected] The information contained in this e-mail (and any attachments) is supplied in good faith, but the sender shall not be under any liability in damages or otherwise for any reliance that may be placed upon it by the recipient. Any comments or opinions expressed are those of the originator not of NTT Europe Ltd unless otherwise expressly stated.
Oracle LazyDBA home page