Re: Query timeout

"ReplyToGroups" <sorry_at_NoAddress.com> wrote in message news:<bpl25e$4jj2_at_eccws12.dearborn.ford.com>...
> Hi
>
> Is there anyway I can break the long running query after 'x' minutes. I
> wanted to do this in procedure.
> Let's say if the query runs more than 2 minutes then I wanted to Exit the
> procedure and send the message to the user.
>
> Thanks
> Sync

1. profiles
2. resource manager.

the functionality and implementation can vary by oracle release. please provide one.

Pd Received on Fri Nov 21 2003 - 15:42:15 CST