In case you have an oracle exadata database machine, always use 100% percent for collecting optimizer statistics on your tables/schemas , in order to benefit from the smart scans .
http://uhesse.com/2012/07/04/no-smart-scan-with-auto_sample_size/
Savepoint Funny
-
Here’s an example that makes perfect sense if you know how Oracle handles
data locking. It’s one that I thought I’d published years ago, but it’s not
on th...
Acum 3 săptămâni
Niciun comentariu:
Trimiteți un comentariu