Performance tuning principals in 8i, 9i and 10g |
 |
EXPERT RESPONSE FROM: Paul Baumgartel
|
|
|
| > |
QUESTION POSED ON: 18 May 2004
Can you also describe the difference in performance tuning between 8i,
9i and 10g?
|
|
| > |
EXPERT RESPONSE
Each release of Oracle has introduced features and behaviors that are
intended to process SQL more efficiently and to allow better control over
performance. The basic principles, however, remain the same: design to
maximize scalability by reducing latching and locking to a minimum; consider
all options for object implementation; and compare test results for
different approaches before making a decision on production implementation.
|
|
|
|
|
|
|
|
Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and
answer pairs from more than 250 TechTarget industry experts.
|
|
|
|
|
|
|
|
|
|
|
|
