/explore
|
You are here 
|
oracle-base.com | ||
| | | | |
oracleprof.blogspot.com
SQL_ID and/or PLAN_HASH_VALUE are used almost globally across Oracle database to identify query. This is not a case for SPM mechanism using... |
|
| | | | | ||
| | | | |
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... |
|
| | | | | ||
| | | | |
leonotes.wordpress.com
transitive closure?Wiki?Oracle?... |
|
| | | | | ||
| | | | |
savvinov.com
In this post, I continue on the topic of examining SQL plans. I will talk about one DBMS_XPLAN function, DISPLAY_CURSOR (because it's probably the most useful one when troubleshooting ongoing performance issues, and also because other functions have a lot of similiarity to it). I will discuss frequently used options and some common problems. Preparation... |
|
| | | |||
