hint for db_file_multiblock_read_count
Hello all,
I was wondering if there is any hint for db_file_multiblock_read_count ?? i know you can alter the session or alter the system, but aer there any hints that i can use to do this ??
or is there anyway i can implement it with a view...so lets say i have a view called testveiw. now user A qurey that view...select * from testview. Can i create a trigger or anything that will do alter session to db_file_multiblock_read_count of 64 ??? As we do not want to alter the system...just want it to user for this view ??is this do able ??
i am on 10.2.0.3 on AIX ....