Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Hard Parsing of sql statement to get nextval from sequence

779419Jun 15 2010 — edited Jun 16 2010
Hello,

We found that a sql statement to get the next value from sequence was being parsed too many times (%Total Parses was around 41%)

select SEQ_NAME.nextval from dual

This statement does not have any literals, so I am not very clear why this should be hard parsed. The following are the properties of the sequence

MIN_VAL=1
MAX_VAL=999999999999999999999999999
INCREMENT_BY=1
CACHE=20
NO CYCLE

I would really appreciate any help in clarifying this.

Thanks
Karthik
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 14 2010
Added on Jun 15 2010
6 comments
1,303 views