High Performance PHP |
|
2024-11-24 |
|
|
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.