Database Tuning (MOSC)

MOSC Banner

inittran and maxtran

edited Feb 3, 2010 8:40AM in Database Tuning (MOSC) 4 commentsAnswered
Hello

I have a table against which updates/inserts are done continuoulsy and there is also a need to delete data from that table on an hourly basis (delete from table where time < today -60min). In order to prevent deadlocks, I plan to set up high values for inittran (based on the expected number of simultanious transaction given by the app team) and maxtran (255). Is there anything else that I need to do to prevent deadlocks? My version is 10.2.0.3

thank you

Gene 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center