SELECT STATIC_TERMINAL_PROFILE
FROM
 NTMS40_PHONETYPES WHERE PHONETYPE IN (SELECT /*+ FIRST_ROWS(1) INDEX
  (NTMS40_PHONE_IMEI_RANGES NTMS40_IND_PHO_IM_RANG_COMB) */PHONETYPE FROM
  NTMS40_PHONE_IMEI_RANGES WHERE start_imei < :x AND END_IMEI > :y and
  rownum<2)


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse   200009     10.51      10.29          0          0          0           0
Execute 200009     21.56      21.24          0          0          0           0
Fetch   200009    421.72     412.07          0    7892942          0      200008
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total   600027    453.79     443.60          0    7892942          0      200008

Misses in library cache during parse: 0
Optimizer goal: FIRST_ROWS
Parsing user id: 30     (recursive depth: 1)

Rows     Row Source Operation
-------  ---------------------------------------------------
      1  NESTED LOOPS
      1   VIEW
      1    SORT UNIQUE
      1     COUNT STOPKEY
      1      TABLE ACCESS BY INDEX ROWID NTMS40_PHONE_IMEI_RANGES
      1       INDEX RANGE SCAN NTMS40_IND_PHO_IM_RANG_COMB (object id 26905)
      1   TABLE ACCESS BY INDEX ROWID NTMS40_PHONETYPES
      1    INDEX UNIQUE SCAN NTMS40_PRIMARY_PHONETYPE (object id 26898)

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

SELECT *
FROM
 TABLE (CAST (:B1 AS PROFILEARRAY))


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse       21      0.00       0.00          0          0          0           0
Execute     21      0.72       0.67          0         60          0           0
Fetch    20021      1.15       0.97          0          0          0      200009
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total    20063      1.87       1.64          0         60          0      200009

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 30     (recursive depth: 1)

Rows     Row Source Operation
-------  ---------------------------------------------------
  10000  COLLECTION ITERATOR PICKLER FETCH




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

OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse       25      0.01       0.00          0          0          0           0
Execute     25    120.01     120.32          0          6          0          22
Fetch        1      0.00       0.00          0          0          0           1
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total       51    120.02     120.33          0          6          0          23

Misses in library cache during parse: 0


OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse   200034     10.52      10.29          0          0          0           0
Execute 200034     22.28      21.92          0         61          2           1
Fetch   220054    422.87     413.04          0    7892953          0      400040
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total   620122    455.67     445.25          0    7893014          2      400041

Misses in library cache during parse: 0

200055  user  SQL statements in session.
    4  internal SQL statements in session.
200059  SQL statements in session.
********************************************************************************
Trace file: mtms_ora_13961.trc
Trace file compatibility: 9.02.00
Sort options: default

       1  session in tracefile.
  200055  user  SQL statements in trace file.
       4  internal SQL statements in trace file.
  200059  SQL statements in trace file.
      11  unique SQL statements in trace file.
 3020542  lines in trace file.