High Performance PHP |
 |
2025-07-05 |
 |
 |

38 |
 |
 |
Avoiding Latch and Lock Contention
- • Correctly Size your SGA
- • Leave autocommit on unless you explicitly need it
- • Avoid excessive use of triggers
- • Use bind SQL
Oracle has extremely powerful introspection capabilities to help determine bottlenecks and diagnose performance issues.