| sql tunning & undo managment [message #59278] |
Sat, 08 November 2003 01:32  |
Jasmine
Messages: 23
Registered: December 2000
|
Junior Member |
|
|
What r the things we do to improve the performance of sql statments and applications in a OLTP environment.
one more thing what r things we have to take care to tune undo segments or while creating undo segments thnaks in advance
jasmine
|
|
|
|
| Re: sql tunning & undo managment [message #59279 is a reply to message #59278] |
Sat, 08 November 2003 05:09  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
a number of things such as
table design,
updating schema statistics periodically allowing CBO to do its job,
the right join order,
using bind variables to reduce parsing/latch contention,
creating the right indexes(includes removing unwanted indexes),
sufficient(ie dont overallocate) sort/hash area sizes,
sufficient shared memory areas
sufficient freelists,Initrans ( try Automatic segment space management feature) etc...
Use Automatic_Undo_management feature reduce rollback segments administration/tuning issues. In OLTP,you are prone to undo header contention if the number of concurrent transactions are high..so allocate sufficient number of undo segments.
-Thiru
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
