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
>


Oracle LazyDBA home page