Slide
‹#› of 37
Solution
uCreate a separate database instance
ØNew instance runs in NOARCHIVELOG mode
ØNew instance has only one schema.
ØThat schema contains only one table: SUPPORT INFO
ØSUPPORT INFO table is hash-partitioned by session ID
(1024 partitions)
ØAll indexes are local.
uMain schema has a database link and synonym
ØEverything appears as though nothing has changed.
ØAll requests to the support table must include session
ID (to use local indexes).
ØSome rewrite was required to enforce this rule.