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..
RAID 1+0 is a good choice for a large volume of data.
Distribute the data on many disks. Partition may help.
Use B-Tree in OLTP environment.
Cache the Ref.Tables data in Buffer Pool Keep.
Configure good amount of SORT AREA SIZE.
Configure a large amount for DB_BLOCK_BUFFER.
Check the application Logic.
Avoid Group by, and SORT in SQL statement.
Verify the EXECUTION PLAN for Nested Loops.