Explore >> Select a destination
|
You are here 
|
oralytics.com | ||
| | | | |
dbamarco.wordpress.com
|
|
| | | | | I just had some fun with Oracle 12c PDBs and snapshot clones. In the alert.log I found some unexpected errors "ORA-01157: cannot identify/lock data file XX". The file was part of a PDB which I used for testing. So I investigated that and found the file which was pretty small. So my assumption was that... | |
| | | | |
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... | |
| | | | |
hourim.wordpress.com
|
|
| | | | | I like very much Tanel Poder snapper and Carlos Sierra SQLTXPLAIN. They represent valuable performance diagnostic tools. Unfortunately I am still waiting to find a customer site where I will be allowed or granted necessary privileges to install and to use them. There are client sites where I have been asked to tune queries without... | |
| | | | |
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... | ||
