/explore
|
You are here 
|
www.bobbydurrettdba.com | ||
| | | | |
jonathanlewis.wordpress.com
|
|
| | | | | I've discussed the capabilities of the dbms_xplan package in a couple of posts already; and shown how useful it can be in two examples: understanding a problem with filter subquery selectivity and understanding why some Cartesian merge joins were appearing unexpectedly. Let me make a crucial point about execution plans (again): if you have a... | |
| | | | |
connor-mcdonald.com
|
|
| | | | | One of the cool features in Oracle AI Database 26ai is the ability for sessions to have different levels of priority for their transaction locks. I've covered how the feature works in the video below In a nutshell, a session can nominate whether their locking priority is LOW, MEDIUM or HIGH. When a session tries... | |
| | | | |
carlos-sierra.net
|
|
| | | | | SQLTXPLAIN, also know as SQLT, is a tool that helps to diagnose SQL statements performing poorly in an Oracle database. This tool is free to download and use. You only need to have access to My Oracle Support (MOS) and search for Document Id: 215187.1. Q: What do you get from this tool? A: In... | |
| | | | |
kerryosborne.oracle-guy.com
|
|
| | | [AI summary] A technical investigation into whether Oracle SQL Plan Baselines store actual execution plans or rely on hidden hints, analyzing database trace files and data dictionary views. | ||
