oracle如何设置查询超时时间

smartdonkey 2002-01-09 02:37:56
加精
...全文
648 2 打赏 收藏 转发到动态 举报
写回复
用AI写文章
2 条回复
切换为时间正序
请发表友善的回复…
发表回复
smartdonkey 2002-01-10
  • 打赏
  • 举报
回复
XIE
superrg 2002-01-09
  • 打赏
  • 举报
回复
Is it possible in SQL to specify a timeout which the query must return by with any data retrieved so far?
Basically, some command that could be used along the lines of:

select /*+ timeout 30*/ * from veryLargeTable

So that after 30 seconds the query would return with all the data retrieved so far. I am aware of the where statement "rownum<10000" that can be used to limit the number of rows in the reply, but wish to use the timeout in addition.


You can specify a limit on the session, but not an individual statement from what I know. In Visual Basic 6 I know that this can be done. I believe it is implemented by the client sending some kill signal to Oracle (equivalent of a cancel or Ctrl-C).

2,596

社区成员

发帖
与我相关
我的任务
社区描述
Sybase相关技术讨论区
社区管理员
  • Sybase社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧