| Optimize performance for Update Opertaion [message #65088] |
Mon, 26 April 2004 23:20  |
Ali Ansari
Messages: 3
Registered: April 2004
|
Junior Member |
|
|
|
HI .. i am facing a problem when updating my ORAcle 8i database. I am saving live/Real time stocks rate into my table. TAble is updated 20-30 times per second. is there any other way to store data which is coming at such a high speed. any comment is appericiated. thanx .. regards Ali Ansari
|
|
|
|
| Re: Optimize performance for Update Opertaion [message #65107 is a reply to message #65088] |
Fri, 30 April 2004 06:08  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
Here are a couple of things you can consider:
1) Put the table in it's own tablespace (or at least on its own disk) for high I/O throughput.
2) Ensure the table is as small as possible. Redesign to move redundant columns to other tables.
3) Re-create the table with a bigger PCTFREE, bigger INITRANS and sufficient FREELISTS and FREELIST GROUPS.
4) Drop redundant indexes, but ensure the update statements will find the target rows via a unique index.
5) Consider recreating the table as an IOT.
6) Create indexes as REVERSE indexes to spread I/O accross leave blocks (remove hot spots from indexes)
Best regards.
Frank
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
