We have the same issue over a VPN to one of our remote sites. The connection
appears to time out because of inactivity.
Wrap the code in a shell (batch) script and kick it off from the server
itself running in the background (nohup or at now on UNIX)
However, this may not be your issue at all :-)
M.
-----Original Message-----
From: FahmeedaD
[mailto:oracledba-ezmlmshield-x73075278.[Email address protected]
Sent: 26 September 2007 11:41
To: LazyDBA Discussion
Subject: Help please
Hi
I run the following script,it works fine but halfway through the job it
looses connection to the database.
Does anyone know how this can be avoided?Many thanx
exec dbms_stats.gather_schema_stats(ownname=> '"SIEBEL"' ,cascade=>
TRUE) /
___________________________________________________________
Important Notice:
Authorised Financial Services Provider
Important restrictions, qualifications and disclaimers
("the Disclaimer") apply to this email. To read this click on the
following address or copy into your Internet browser:
http://www.absa.co.za/disclaimer
The Disclaimer forms part of the content of this email in terms of
section 11 of the Electronic Communications and Transactions
Act, 25 of 2002.
If you are unable to access the Disclaimer, send a blank e-mail
to [Email address protected] and we will send you a copy of the
Disclaimer.
---------------------------------------------------------------------
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 is confidential and may be privileged.
It may only be read, copied and used by the intended recipient.
If you have received it in error please contact the sender immediately
by return e-mail. Please then delete the e-mail and any copies of it
and do not use or disclose its contents to any person.
**********************************************************************
Registered Office: Farncombe House, Broadway, Worcestershire, WR12 7LJ
AccuRead Limited Registered Number: 3076187 England
GSL UK Limited Registered Number: 3333860 England
Global Solutions Limited Registered Number: 3189802 England
**********************************************************************
Oracle LazyDBA home page