Home » RDBMS Server » Performance Tuning » sqlplus: query takes too much time (sqlplus:oracle database)
sqlplus: query takes too much time [message #306525] Fri, 14 March 2008 10:05 Go to next message
viko
Messages: 9
Registered: March 2008
Junior Member
Hi there

I've a query inside a shell script. Sometimes it takes much time to retrieve the results from one of the tables, and i think because of that much time, script just continues without that fields.
first of all, i wonder if that's possible, then I wonder if it has a solution.

i'm really stuck with this.


thanks

regards

VIKKKKO
Re: sqlplus: query takes too much time [message #306527 is a reply to message #306525] Fri, 14 March 2008 10:07 Go to previous messageGo to next message
BlackSwan
Messages: 25040
Registered: January 2009
Location: SoCal
Senior Member
>i wonder if that's possible, then I wonder if it has a solution
no
yes
Re: sqlplus: query takes too much time [message #306550 is a reply to message #306525] Fri, 14 March 2008 11:45 Go to previous messageGo to next message
viko
Messages: 9
Registered: March 2008
Junior Member
so...
that's not possible, but has a solution? :S


what's the solution for?
Re: sqlplus: query takes too much time [message #306603 is a reply to message #306550] Fri, 14 March 2008 23:11 Go to previous messageGo to next message
trantuananh24hg
Messages: 668
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Said Anna that you can not have any solution unless your TKProf's brief result or any explain information at here.
Re: sqlplus: query takes too much time [message #306790 is a reply to message #306525] Sun, 16 March 2008 20:20 Go to previous message
gamyers
Messages: 3
Registered: October 2007
Location: Sydney, Aus
Junior Member
"i think because of that much time, script just continues without that fields."

It is possible that a very long-running query errors (eg can't find undo or insufficient temp space). If the script uses SQL*Plus then the response to an error is, by default, to continue. WHENEVER SQLERROR EXIT 1 can be used to abort instead.
Then it is up to your script to check whether the SQL*Plus called returned successfully or not. if you don't check for it, then you'll probably continue.

The solution for those issues is proper exception handling throughout the code.
Previous Topic: Doubt regarding ORA-30036: unable to extend segment by 8 in undo tablespace
Next Topic: Why did I not use the index?
Goto Forum:
  


Current Time: Tue Dec 06 00:28:03 CST 2016

Total time taken to generate the page: 0.48930 seconds