/explore
|
You are here 
|
www.bobbydurrettdba.com | ||
| | | | |
www.dbaglobe.com
A blog about on new technologie. Hands-on note about Hadoop, Cloudera, Hortonworks, NoSQL, Cassandra, Neo4j, MongoDB, Oracle, SQL Server, Linux, etc. |
|
| | | | | ||
| | | | |
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... |
|
| | | | | ||
| | | | |
jonathanlewis.wordpress.com
Jump to summary. A new optimizer feature that appears in 23c (probably not 21c) was the ability to push group by clauses into union all set operations. This will happen unhinted, but can be hinted with the highly memorable [no_]push_gby_into_union_all() hint that appeared in 23.1.0.0 according to v$sql_hint. and the feature can be disabled by... |
|
| | | |||
