REPOST: Autortace

From: Brian Tkatch <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK>
Date: Fri, 28 Dec 2001 18:19:57 GMT
Message-ID: <9$--$$_--%$-__-$%$@news.noc.cabal.int>

Oracle8i Designing and Tuning for Performance Release 2 (8.1.6)
Part Number A76992-01
Chapter 9, "Optimizing SQL Statements"

<<<

Disk Reads and Buffer Gets
Monitor disk reads and buffer gets by executing the following statement:

SQL> set autotrace on [explain] [stat]

Typical results returned are shown as follows:

Statistics

         70  recursive calls
          0  db block gets
       591  consistent gets
      404  physical reads
          0  redo size
        315  bytes sent via SQL*Net to client
        850  bytes received via SQL*Net from client
          3  SQL*Net roundtrips to/from client
          3  sorts (memory)
          0  sorts (disk)
          0  rows processed

<<<

When I set autotrace on, in statistics, all I got was "recursive calls" and "rows processed". How could I get the others to list as well?

Brian

WAS CANCELLED BY =======: Message-ID: <cancel.3c2cb720.3383465171_at_news.alt.net> Control: cancel <3c2cb720.3383465171_at_news.alt.net> Subject: cmsg cancel <3c2cb720.3383465171_at_news.alt.net> From: SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK (Brian Tkatch) Newsgroups: comp.databases.oracle.misc X-No-Archive: yes Lines: 2 NNTP-Posting-Host: wonenara.ozemail.com.au X-Trace: ozemail.com.au 1009694873 203.108.164.177 (Sun, 30 Dec 2001 17:47:53 EST) NNTP-Posting-Date: Sun, 30 Dec 2001 17:47:53 EST Organization: OzEmail Ltd, Australia Distribution: world Date: Sun, 30 Dec 2001 05:07:10 GMT Path: news.sol.net!spool0-nwblwi.newsops.execpc.com!newsfeeds.sol.net!newspump.sol.net!news.maxwell.syr.edu!news1.optus.net.au!optus!yorrell.saard.net!duster.adelaide.on.net!newsfeed.ozemail.com.au!ozemail.com.au!not-for-mail

This message was cancelled from within Mozilla. Received on Fri Dec 28 2001 - 12:19:57 CST