create role plustrace;
grant select on v_$sesstat to plustrace;
grant select on v_$statname to plustrace;
grant select on v_$mystat to plustrace;
grant plustrace to dba with admin option;
August 14, 2007
Script to create plustrace role
Gather fast statistics
One alternative almost immediate is create anytime statistics over TEST enviroment, and then transfer it to production enviroment, i did it last week and help me a lot
How to find value of bind variables used by SQLs (10g)
http://coskan.wordpress.com/2007/03/02/how-to-find-value-of-bind-variables-used-by-sqls/
Good material from mr. Coskan Gundogar
Join over histograms
www.adellera.it/investigations/join_over_histograms/JoinOverHistograms.pdf
Amazing Paper from mr. Alberto Dell’Era
