Explore >> Select a destination
|
You are here 
|
www.dbaglobe.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... | |
| | | | |
savvinov.com
|
|
| | | | | SQL tuning is the key to database performance tuning, and yet this seems to be a "blind spot" for many database specialists. I think it's probably because it falls right on the boundary between DBA's and developer's responsibilities: so while a DBA expects database developers take care of performance while developing code, developers often neglect... | |
| | | | |
kerryosborne.oracle-guy.com
|
|
| | | | | ||
| | | | |
dincosman.com
|
|
| | | The performance issue with an SQL query was resolved by using the /*+ PARALLEL(2) */ hint, reducing execution time from 180-200 seconds to milliseconds. The decision to perform a direct read from disk to memory instead of reading blocks from disk was made by the database engine and is controlled by the hidden "_serial_direct_read" parameter.... | ||
