Home » RDBMS Server » Performance Tuning » package not completing
package not completing [message #306051] Wed, 12 March 2008 12:20 Go to next message
chriswitt
Messages: 7
Registered: August 2006
Location: jam
Junior Member

i hope some one out there can help, i have a oracle package that has executed sucessfully for the last five years but since lately when i run the package it dosnt complete, it do what it is suppose to do(input data in tables mainly) but it dosnt say "process complete sucessfully" dose every one how i can fix this.
Re: package not completing [message #306061 is a reply to message #306051] Wed, 12 March 2008 13:01 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do you really expect we can know what happens with the information you gave? ./fa/1659/0/

Regards
Michel

Re: package not completing [message #306093 is a reply to message #306051] Wed, 12 March 2008 15:21 Go to previous messageGo to next message
chriswitt
Messages: 7
Registered: August 2006
Location: jam
Junior Member

DATABASE IS 9I, THE PACKAGE HAS SIX FUNCATION , AND SIX PROCEDURE, WHAT OTHER INFORMATION WOULD YOU LIKE

OH ALSO I SEE "NO EXPLAIN PLAN" MESSAGE
AND THE TABLE SPACE USE UP A LOT OF SPACE UP TO 90%
Re: package not completing [message #306096 is a reply to message #306093] Wed, 12 March 2008 15:28 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Read OraFAQ Forum Guide and don't write in UPPER CASE.
It is a sure way to get no answer.

Regards
Michel
Previous Topic: need help! how to intercept sql command of update
Next Topic: AWR report
Goto Forum:
  


Current Time: Wed Dec 07 22:12:39 CST 2016

Total time taken to generate the page: 0.09273 seconds