Jump to content

Esu X

  • Content count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Esu X

  • Rank
  1. How we could tuning top sql queries from AWR without using sql advisor? How to check for better execution plan? How to check if better sql profile/baseline should be used?I would like to see an examples how to do it... thank you in advance.
  2. Sorry, but I didn't quite get that... I thought that having statistics the newest and latest is the best option. Re-analyzing them is not a good idea ? We have large fast changing tables, we export and import statistics when a new table is created every month and it's improve performance a little and we have statistics up to date which we are using, but recently there was problem with optimizer which couldn't take new imported statistics, so we had problems and we needed to reload old ones before importing. Now, we want to improve this, so it won't happen and maybe test new things which could improve something... Could you please advise. Thank you.
  3. Hello... I want to change "stale_percent" to 3 and "concurrent" to true, but I need to test it first. I need to improve statistics gathering on very large fast changing tables.What is the best way to check before and after it will be set to check if this make any difference?I read that I need to check parameter JOB_QUEUE_PROCESSES and parallel_adaptive_multi_user before I will set "concurrent".Could you advise what values are save when setting it?Thank you in advance.