Database Tuning (MOSC)

MOSC Banner

TKPROF output - do I understand it correctly?

edited Oct 4, 2012 6:24AM in Database Tuning (MOSC) 15 commentsAnswered
11.2.0.2

Using a software I run a query to search for a person using its birth date (SSSN).

SELECT   R0.sFirstName, R0.sLastName, R0.sEmail, R0.iCustomerMasterId,
  R0.iRecipientId
FROM
 NmsRecipient R0 WHERE ((R0.iFolderId = :1) AND ((Upper(R0.sSsn) LIKEC :2 ||
  Upper(:3) || :4 ESCAPE '\')))


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute      1      0.03       0.05          0          0          0           0
Fetch        1     27.49      46.12      12056      12056          0           1
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        3     27.53      46.17      12056      12056          0           1

Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: FIRST_ROWS
Parsing user id: 60
Number of plan statistics captured: 1

Rows (1st) Rows (avg) Rows (max)  Row Source Operation

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