Explore >> Select a destination

You are here

 mwidlake.wordpress.com
03 | July | 2009 | Martin Widlake's Yet Another Oracle Blog
| | kerryosborne.oracle-guy.com
Kerry Osborne's Oracle Blog » Blog Archive » Flush a Single SQL Statement - Take 2
10.4 parsecs away

Travel
| |
| | chandlerdba.com
ORA-04021 timeout occurred while waiting to lock object during stats gather - Neil Chandler's DB Blog
11.4 parsecs away

Travel
| | I recently came across an interesting change in behaviour when gathering stats. Patch 32781163 (Deadlock on library cache lock on MV refresh and dbms_stats gathering the same object) was applied to an Oracle 19C system, and as well as curing the deadlock problem the client was experiencing it also changed one of the Global Stats...
| | mahmoudhatem.wordpress.com
Adaptive Dynamic Sampling : DYNAMIC_SAMPLING_RESULT & STALE_PERCENT | Hatem Mahmoud's blog
10.9 parsecs away

Travel
| | Since oracle 12.2.0.1 Adaptive Dynamic Sampling result are stored inside SPD as a special directive type "DYNAMIC_SAMPLING_RESULT". This will allow the result of ADS to be persisted on disk,thus it will survive memory flush and database restart.For more detailed info please check Mauro Pagano blog Post Something new about SQL Plan Directives and 12.2 We...
| | littlekendra.com
Register for Upcoming Free Webcasts on Indexes, Stats Maintenance, Query Tuning, and More
70.0 parsecs away

Travel
| Kendra Little writes and draws comics about SQL Server, Data Platforms, and Database DevOps.