Database Tuning (MOSC)

MOSC Banner

tkprof and cardinality

edited Dec 21, 2011 7:12AM in Database Tuning (MOSC) 3 comments
Hi,

i have the following output in tkprof :


SELECT RARTIT_RARCAULOC,RARTIT_BURSACCI_,RARTIT_FECHRARO_
FROM   RARTIT
WHERE  RARTIT_ESCENA_CODIGO___ = :B4
AND    RARTIT_PORTAF_CODIGO___ = :B3
AND    RARTIT_TITULO_NUMERO___ = :B2
AND    RARTIT_FECHRARO_       <= :B1
ORDER  BY RARTIT_FECHRARO_ DESC


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse       18      0.00       0.00          0          0          0           0
Execute     18      0.00       0.01          0          0          0           0
Fetch    12134      6.92      98.16      11952      24294          0       12124
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total    12170      6.92      98.18      11952      24294          0       12124

Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: 34     (recursive depth: 1)

Rows     Row Source Operation
-------  ---------------------------------------------------
    380  TABLE ACCESS BY INDEX ROWID RARTIT (cr=763 pr=382 pw=0 time=1946733 us cost=82 size=2430 card=81)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center