ents of list ORACLE-L
> Subject: RE: Checking that the instance is up
>
>
> Hi Peter,
>
> I remember the thread, but couldn't remember the subject line at all..
>
> Having had this discussion countless times in the past,
> here's what I would
> opt for:
>
We do a heartbeat at fixed intervals ... a heartbeat consists of
1. logging in
2. inserting sysdate into a table.
3. sleeping for 3 seconds.
4. performing current_sysdate-sysdate_from_table
5. rollback
6. exit with output from step 4.
If the output from step 4 is excessive (> 5 or 6 seconds), D
Hi Peter,
I remember the thread, but couldn't remember the subject line at all..
Having had this discussion countless times in the past, here's what I would
opt for:
The best way to make sure that an instance is alive and running would be to
do a full connection to that instance, and run a simpl
Folks -
Some months ago there were exchanges on the optimum way to check that an
instance was alive.
I have searched, hunted and generally scavenged for these exchanges, but
without luck.
Can anyone give me the subject line, and I can turn again to the archive?
thanks,
peter
edinburgh
**