|
You are here |
www.dbaglobe.com | ||
| | | | |
sqlmaria.com
|
|
| | | | | Although there have been a number of significant changes to the Oracle Database in 12c, some of my favorite new features are actually the small enhancements, designed to make your life a little eas... | |
| | | | |
orastory.wordpress.com
|
|
| | | | | There have been some interesting posts from Marcin Przepiorowski and Kerry Osborne about mapping sql plan management (spm) baselines to a corresponding sql id. The key to sql plan baselines (DBA_SQL_PLAN_BASELINES) is SIGNATURE. And why signature? It's not just another change to the key to identifying sql statements (HASH_VALUE -> (NEW_)HASH_VALUE / OLD_HASH_VALUE -> SQL_ID).... | |
| | | | |
blog.sqlora.com
|
|
| | | | | Here is an overview of some improvements to Online Statistics Gathering in Oracle Releases 19c-23ai | |
| | | | |
chandlerdba.com
|
|
| | | Photo by Brian Patrick Tagalog on Unsplash July 2024. Oracle 19c, 23ai There are 3 main types of SQL Plan Management: SQL Profile SQL Plan Baseline SQL Patch So first some quick background info about the 3 options and then I'll tell you about my mistake. SQL Profile A SQL Profile is a collections of... | ||