Skip to Main Content

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!

Parallel Hint !!

645300May 26 2010 — edited May 26 2010
Hello Gurus

I m using prallel hint ...i belive the syntax of parallel hint is something like this
/*+ Parallel(tablename, degree) */
But when i try with just degree without tablename, it works absolutely fine .... So my question is can i use parallel hint without tablename jus by mentioning degree

..like this
/*+    parallel(32) */
My concern is, the query is has been deployed to production without the tablename being mentioned in parallel hint....so how serious is this ?? BUt when i run the query in dev without table name mentioning in parallel hint in Development area its running fine ...


So do u guys hav any suggestions!!

Thanks !!

Edited by: user642297 on May 26, 2010 11:13 AM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 23 2010
Added on May 26 2010
4 comments
1,813 views