SELECT ACTIVITY_NAME
FROM
D_ACTIVITIES WHERE LOWER(ACTIVITY_CODE) = :1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1394 0.00 0.00 0 0 0 0
Execute 1394 0.00 0.00 0 0 0 0
Fetch 1394 0.00 0.00 0 1394 5576 1394
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 4182 0.00 0.00 0 1394 5576 1394
Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 38 (U_TS)
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS FULL D_ACTIVITIES
Rows Execution Plan
------- ---------------------------------------------------
0 SELECT STATEMENT GOAL: CHOOSE
1 TABLE ACCESS GOAL: ANALYZED (FULL) OF 'D_ACTIVITIES'
********************************************************************************