Explore >> Select a destination
|
You are here 
|
oralytics.com | ||
| | | | |
troubleshootingsql.com
|
|
| | | | | 1 post published by Amit Banerjee on December 12, 2012 | |
| | | | |
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... | |
| | | | |
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... | |
| | | | |
dioncho.wordpress.com
|
|
| | | One of my colleagues sent following test case, of which he couldn't control the join order with hints. 1. Create objects - table t1, t2 and t3 2. Now Let's set the join order as T1->T2->T3, using global hints convention. But it seems that Oracle does not work as expected. It really seems that the... | ||
