从 QTP 执行 Oracle 存储过程时出现会话超时问题
作为 Oracle 调优项目的一部分，我们已经自动化了捕获各种查询的基线指标的过程。自动化由执行该过程的 QTP 脚本执行，该脚本又使用不同的输入参数运行查询指定的次数。存储过程执行完成后，它会打开 OEM 并通过搜索特定 SQL ID 来保存报告。
我们在运行存储过程时遇到一个问题，这反过来又需要花费大量时间来执行查询。在这种情况下，QTP 会执行存储过程一段时间，之后它似乎已停止。当我检查OEM时，经过一定时间后，QTP终止存储过程的执行，并且会话似乎已超时。
由于QTP使用ADO，我是否需要将连接的“CommandTimeout”属性设置为某个大值，以防止执行需要大量时间的存储过程？如果出现任何此类超时问题，QTP 不会抛出任何错误吗？在我们的例子中，即使后端没有发生任何事情，QTP 状态仍然显示为“正在运行”。
We have automated the process of capturing baseline metrics of various queries as part of Oracle tuning project. The automation is carried out by a QTP script which executes the procedure, which in turn runs the query for specified number of times with different input parameters. Once the execution of stored procedure is complete, it opens OEM and saves the reports by searching the particular SQL ID.
We are facing an issue while running stored procedures which in turn has queries taking lot of time to execute. In such cases, the QTP executes the stored procedure for some duration of time and after that it appears to have been stopped. When I check OEM, after a certain amount of time, QTP terminates the execution of stored procedures and the session seems to have been timed out.
Since QTP uses ADO, do I need to set “CommandTimeout” property of the connection to some large value in case of executing stored procedures which take lot of time? Doesn’t the QTP throw any error in case of any such time out issue? In our case the QTP status was still being displayed as “Running”, even when nothing was happening in the backend.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论