Hi,
Thanks, we are using JOIN condition, need to check if the target table is
locked.

Thanks,
Sarma Manchiraju


----- Original Message -----
From: "Patil Jitendra (East ADU) "
<oracledba-ezmlmshield-x3568580.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Tuesday, August 01, 2006 6:06 PM
Subject: RE: error , suggest me


> Following is what strikes my mind:
> 1) You have missed a JOIN condition. In your cursor.
> 2) Your target table is locked (Get some of the realted sessions Killed
> by the DBA)
>
> Cheers,
> jit
>
>
> -----Original Message-----
> From: Sarma Manchiraju
> [mailto:oracledba-ezmlmshield-x769333.[Email address protected]
> Sent: 01 August 2006 13:32
> To: LazyDBA Discussion
> Subject: Re: error , suggest me
>
> Hi,
>
> Running a procedure againist an oracle database, this is taking more
> than 5 hours to process the same and give the output. Any suggestions
> please..Earlier, it used to take something like 20 minutes.
>
> Thanks,
> Sarma
>
>
> ----- Original Message -----
> From: "gowtham" <oracledba-ezmlmshield-x29082410.[Email address
> protected]
> To: "LazyDBA Discussion" <[Email address protected]
> Sent: Tuesday, August 01, 2006 5:50 PM
> Subject: Re: error , suggest me
>
>
> > i think its better to use SPOOL than writing the procedure.
> > it will increase the performance speed awell compare to UTIL file.
> >
> >
> >
> >
> > "Shravan Kumar " <oracledba-ezmlmshield-x36019882.[Email address
> protected]
> >
> > 08/01/2006 10:19 AM
> >
> > To
> >
> > cc
> >
> > Subject
> > error , suggest me
> >
> >
> >
> >
> >
> >
> >
> > When executing a stored procedure, and trying to insert values into
> > table, It is showing error as :: Resources are low , Some results are
> > dropped.
> >
> > No values are being inserted into the table..
> >
> > suggest me
> >
> >
> > CONFIDENTIALITY NOTICE: This e-mail and its attachments may contain
> > PRIVILEGED and CONFIDENTIAL INFORMATION and/or PROTECTED PATIENT
> > HEALTH INFORMATION intended solely for the use of Tranquilmoney Inc.
> > it's clients and the recipient(s) named above. If you are not the
> > intended recipient, or the employee or agent responsible for
> > delivering this message to the intended recipient, you are hereby
> > notified that any review, dissemination, distribution, printing, or
> > copying of this e-mail message and/or any attachments is strictly
> > prohibited. If you have received this transmission in error, please
> > notify the sender immediately and permanently delete this e-mail
> [shred the document] and any attachments.
> >
> >
> >
> >
> >
> > --------
> > website: http://www.LazyDBA.com
> > Please don't reply to RTFM questions
> > Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
>
> > see http://www.lazydba.com/unsubscribe.html
> > To subscribe: see http://www.lazydba.com By using this list you agree
>
> > to these terms:
> > http://www.lazydba.com/legal.html
> >
> > ForwardSourceID:NT00003A2A
> > =====-----=====-----=====
> > Notice: The information contained in this e-mail message and/or
> > attachments to it may contain confidential or privileged information.
> > If you are not the intended recipient, any dissemination, use, review,
>
> > distribution, printing or copying of the information contained in this
>
> > e-mail message and/or attachments to it are strictly prohibited. If
> > you have received this communication in error, please notify us by
> > reply e-mail or telephone and immediately and permanently delete the
> > message and any attachments. Thank you
> >
> >
> >
> >
> > --------
> > website: http://www.LazyDBA.com
> > Please don't reply to RTFM questions
> > Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
>
> > see http://www.lazydba.com/unsubscribe.html
> > To subscribe: see http://www.lazydba.com By using this list you agree
>
> > to these
> terms:http://www.lazydba.com/legal.html
> >
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
> see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com By using this list you agree
> to these terms:http://www.lazydba.com/legal.html
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
terms:http://www.lazydba.com/legal.html
>


Oracle LazyDBA home page