Guidelines on Tables with high number of inserts/updates
** Oracle is investigating this issue, but in parallel is opening the topic to the Community so that Community members can add their perspective, experience or knowledge. This will further enhance all knowledge bases including My Oracle Support and My Oracle Support Communities; assisting all Community members and enabling richer solution searches.**
Hi all,
Are there any guidelines available on the Table organization (either at CREATE TABLE level OR CREATE INDEX level OR alter table):
+ High transactional Table where IO is very high (~1500 rows get inserted every 2 minutes)
+ Master (~10000 rows) is updated very frequently; say 78% of data updated every 2 minutes
+ Master (~600 rows) is accessed very frequently; say 60% of data accessed every 2 minutes
Hi all,
Are there any guidelines available on the Table organization (either at CREATE TABLE level OR CREATE INDEX level OR alter table):
+ High transactional Table where IO is very high (~1500 rows get inserted every 2 minutes)
+ Master (~10000 rows) is updated very frequently; say 78% of data updated every 2 minutes
+ Master (~600 rows) is accessed very frequently; say 60% of data accessed every 2 minutes
0