如何在Oracle中获取查询的执行时间

本文介绍了如何在Oracle中获取查询的执行时间的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

您好我是Oracle新手。所以我有两个问题： 1）我们可以像在SQL中一样从select查询中获取所有记录。现在我正在以50为一组获得记录。在ORACLE中是否有任何需要立即获取所有记录的事件。 2）如何获取查询省略时间是指通过编写SET STATISTICS IO ON，查询在Sql中执行任务所花费的总时间。 提前谢谢！

Hi I am very new to Oracle. So I have two questions: 1) Can we get all records from select query as in SQL. As right now I am getting record in group of 50. Is there any seeting need to do in ORACLE to get all records at once. 2) How To get Query excetion time means total time taken by Query to do task as in Sql by writing SET STATISTICS IO ON. Thanks in advance!

推荐答案

For 1： 这是您正在使用的查询执行工具中的设置。比如Toad或SQL Developer。 在SQL Developer上 - 转到工具 - >偏好 - >数据库 - >高级参数并将此设置从50更改为您喜欢的任何内容。 如果在您的工具版本上，F9键一次返回50条记录，您可以使用F5键返回所有记录。 /> 2： 这 [ ^ ]应该有所帮助。 For 1: This is a setting in the query execution tool that you are using. Such as Toad or SQL Developer. On SQL Developer - Go to Tools -> Preferences -> Database -> Advanced parameters and change this setting from 50 to whatever you like. If on your version of the tool the F9 key returns the set of 50 records at a time, you can use the F5 key to return all your records. For 2: This[^] should help.