Explore >> Select a destination
|
You are here 
|
kerryosborne.oracle-guy.com | ||
| | | | |
hourim.wordpress.com
|
|
| | | | | The last Jonathan Lewis post on RAC Planswhich finished by the following phrases: "If you're going to hard-code hints into a query then take a look at the outline it generates when it does the right thing, and that will tell you about the 15 or so hints you've missed out. (Better still, consider generating... | |
| | | | |
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... | |
| | | | |
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).... | |
| | | | |
www.ardanlabs.com
|
|
| | | Introduction I prefer to use relational (SQL) databases in general since they provide several features that are very useful when working with data. SQLite is a great choice since the database is a single file, which makes it easier to share data. Even though it's a single file, SQLite can handle up to 281 terabytes of data. SQLite also comes with a command line client called sqlite3 which is great for quick prototyping. | ||
