Some access plan are slower than expected? Some unexpected table scans performed even if the indexes are well defined?
General suggestion:
Refresh db statistics (go to -> database configuration -> refresh statistics)
Refresh indexes tables (go to -> database configuration -> refresh index tables)
This blog covers different aspects around software development and test. There are also general information useful for who needs to test performances and needs to analyze bottlenecks on application servers and databases. Disclaimer: test before you implement any advice, no warranty is provided. Before use the software mentioned in this blog read and understand all licenses agreements. Use of the information contained in this blog is under your own responsibility.
giovedì 31 dicembre 2015
Oracle refresh statistics and indexes
Etichette:
indexes,
oracle,
performance,
slow query,
statistics
Iscriviti a:
Commenti sul post (Atom)
Nessun commento:
Posta un commento