I need a direction from you guys..
My company has some data intensive tables (30-50 million records) to start with. OLTP database. Data insertion through Java application.. (No sql loader)..
Writes, I am not bothered now.. Aswell, no DB level tuning now.. But later..
But Performance is a problem from Programmer's level..
What should I do first?? I need some steps..
Any good docs or any scripts available..
Thx..