Skip to Main Content

Enterprise Manager

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!

SQL tuning advisor Query

ka CemSep 18 2018 — edited Sep 18 2018

Hello;

   Could some body help me understanding the following statments from SQL tuning advisor?

1- BEGIN TEST.CLS_NAMES.NEW_NAME( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13 ); END;

2-   SELECT NUM FROM COUNTERS WHERE SEQUENCE = :B1 FOR UPDATE

What does means ( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13 ) and :B1

Thanks.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 16 2018
Added on Sep 18 2018
1 comment
73 views