There was sql hint in one of the script as
/*+ append parallel(TAB_NAME 8) */
since dba's are recommending not to use append parallel hint in 11g r2 since its has issue in oracle..i did the following modification in the script:
/*+ *****append parallel(TAB_NAME 8) */
now I have two questions:
1. Dba is saying oracle has some bad effects with modification like above.. Is it true?
With the changes as i did above, will not negate the use of hint?
2. My 2nd question is, it it true that append parallel hints have negative impact on the performance of data base in 11g. We were asked to remove these hints in all the scripts.
Has oracle said this any where?