Explore >> Select a destination
|
You are here 
|
connor-mcdonald.com | ||
| | | | |
oracle-randolf.blogspot.com
|
|
| | | | | When attempting to display only the first n rows of a result set that is ordered the Oracle optimizer offers special optimizations for these... | |
| | | | |
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... | |
| | | | |
www.bobbydurrettdba.com
|
|
| | | | | Sunday night we worked with Oracle Support on a performance issue with a query that had been running for over 14 hours even though it ran the previous weekend in five minutes. Oracle Support showe... | |
| | | | |
mauro-pagano.com
|
|
| | | When upgrading a database sometime you find that one or more SQLs run slower because ofa new and suboptimal execution plan. Usually the number of those SQLs is pretty small compared to the overall workload but it's not straightforward to understand what caused the plan change so even a small number can become tricky to... | ||
