Sequence Question

[Queyon]

Why does it spend so much time on sequence selecting?

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

select sequence_name.NEXTVAL
from
dual


call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 78531 12.71 12.72 0 0 0 0
Execute 78531 3.75 3.45 0 0 0 0
Fetch 78531 8.34 7.35 2 78531 314127 78531
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 235593 24.80 23.52 2 78531 314127 78531

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

Rows Execution Plan
------- ---------------------------------------------------
0 SELECT STATEMENT GOAL: RULE
0 SEQUENCE OF 'SEQUENCE_NAME'
0 TABLE ACCESS GOAL: ANALYZED (FULL) OF 'DUAL'

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

[pando]

is that the whole tkprof'ed file?

[marist89]

You hard-parsed the statement 78531 times. I'm guessing you're not using bind variables...

[Queyon]

I'm selecting the next value of sequence from DUAL.
I'm wondering whey it parses the statement everytime it runs.

Queyon

[marist89]

Originally posted by marist89
I'm guessing you're not using bind variables...

[jmodic]

Originally posted by marist89

Originally posted by marist89
I'm guessing you're not using bind variables...

I'm just wondering how to use bind variables with the statement like this:

Originally posted by Queyon
select sequence_name.NEXTVAL
from
dual

???

[Shestakov]

Small question to Queyon:

Did u analyze SYS schema or not:
if yes u turn on CBO (not RULE) on SYS objects.
because: ANALYZED (FULL) OF 'DUAL'

0 TABLE ACCESS GOAL: ANALYZED (FULL) OF 'DUAL'