Help: my tkprof does not give rows info

From: Joe Bayer <u705413818_at_spawnkill.ip-mobilphone.net>
Date: Thu, 02 May 2002 20:39:41 GMT
Message-ID: <l.1020371981.1579071044@[64.94.198.252]>

I am using ora8173 on solaris

First I analyze the targeted tables and then alter session set sql_trace=true;

then I run the query on sqlplus.

Then I run

tkprof archtest_ora_8597.trc output2.txt explain=perfstat/perfstat

Everything seems working fine except the output2.txt, all the rows are 0, what I did was wrong?

select /*+ rule */
to_char(snap_time,'yyyy-mm-dd HH24:mi'), newmem.value-oldmem.value sorts_memory,
newdsk.value-olddsk.value sorts_disk,
round(((newdsk.value-olddsk.value)/(newmem.value-oldmem.value)) *100)/100 ratio
From perfstat.stats$snapshot sn ,

perfstat.stats$sysstat oldmem,
perfstat.stats$sysstat newmem,
perfstat.stats$sysstat newdsk,
perfstat.stats$sysstat olddsk

Where snap_time > sysdate - 1
and newdsk.snap_id = sn.snap_id
and olddsk.snap_id = (select max(snap_id) from stats$snapshot where snap_id < s
n.snap_id)
and oldmem.snap_id = (select max(snap_id) from stats$snapshot where snap_id <
sn.snap_id)

and newmem.snap_id = sn.snap_id
and oldmem.name = 'sorts (memory)'
and newmem.name = 'sorts (memory)'
and olddsk.name = 'sorts (disk)'
and newdsk.name = 'sorts (disk)'
and newmem.Value -oldmem.Value > 0

order by to_char(snap_time,'yyyy-mm-dd HH24:mi')

call     count       cpu    elapsed       disk      query    
current        rows

------- ------ -------- ---------- ---------- ---------- ----------

---

Parse        1      0.00       0.00          0          0          0           0
Execute      1      0.00       0.00          0          0          0           0
Fetch       20      1.79       1.85         51       6970          4         275

------- ------ -------- ---------- ---------- ---------- ----------

---

total 22 1.79 1.85 51 6970 4 275

Misses in library cache during parse: 0
Optimizer goal: RULE
Parsing user id: 42 ()

Rows Execution Plan

-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: HINT: RULE
      0   SORT (ORDER BY)
      0    NESTED LOOPS
      0     NESTED LOOPS
      0      NESTED LOOPS
      0       NESTED LOOPS
      0        TABLE ACCESS   GOAL: ANALYZED (FULL) OF
              'STATS$SYSSTAT'
      0        TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF


                   'STATS$SNAPSHOT'

      0         INDEX   GOAL: ANALYZED (RANGE SCAN) OF
                    'STATS$SNAPSHOT_PK' (UNIQUE)
      0       TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF
                  'STATS$SYSSTAT'
      0        INDEX   GOAL: ANALYZED (RANGE SCAN) OF


                   'STATS$SYSSTAT_PK' (UNIQUE)

      0         SORT (AGGREGATE)
      0          INDEX   GOAL: ANALYZED (RANGE SCAN) OF
                     'STATS$SNAPSHOT_PK' (UNIQUE)
      0      TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF
                 'STATS$SYSSTAT'
      0       INDEX   GOAL: ANALYZED (RANGE SCAN) OF
                  'STATS$SYSSTAT_PK' (UNIQUE)
      0     TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF
                'STATS$SYSSTAT'
      0      INDEX   GOAL: ANALYZED (RANGE SCAN) OF 'STATS$SYSSTAT_PK'
                 (UNIQUE)
      0       SORT (AGGREGATE)
      0        INDEX   GOAL: ANALYZED (RANGE SCAN) OF


                   'STATS$SNAPSHOT_PK' (UNIQUE)


*********************************************************************

---

I tried first_rows,all_rows, the result is the same, no rows info.

Could somebody help me out?

thanks  

-- 
Sent by joebayerii  from  hotmail part from  com
This is a spam protected message. Please answer with reference header.
Posted via http://www.usenet-replayer.com/cgi/content/new

Received on Thu May 02 2002 - 15:39:41 CDT