Print Thread
statistics of a query
#48879 04/08/14 05:09 PM
Joined: Sep 2013
Posts: 11
R
Roger25 Offline OP
Member
OP Offline
Member
R
Joined: Sep 2013
Posts: 11
Hi,

Which command can we use (if it exists, of course), to display a query's statistics like:
Code
 Statistics
---------------------------------------------------
          0  recursive calls
          0  db block gets

        421  consistent gets

          0  physical reads
          0  redo size
        371  bytes sent via SQL*Net to client
        430  bytes received via SQL*Net from client
          2  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
          1  rows processed

This is shown in SQL Plus with "set autotrace traceonly" before executing a query, but in PL/SQL Developer we cannot set autotrace.

Thank you.

Last edited by Roger25; 04/08/14 05:09 PM.
Re: statistics of a query
Roger25 #48884 04/09/14 08:47 AM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
You can enable "Automatic Statistics" (Tools > Preferences > Oracle / Options). When enabled you can execute a statement in the SQL Window or Test Window and go to the "Statistics" tab page to view the information.

See chapter 6.2 in the User's Guide for more information.


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.057s Queries: 14 (0.009s) Memory: 2.5002 MB (Peak: 3.0423 MB) Data Comp: Off Server Time: 2024-05-17 00:56:37 UTC
Valid HTML 5 and Valid CSS