Re: Flashback Queries

Mark Brady wrote:
>
> ALL and TIA,
>
> Has anyone had any experience with Large undo tablespaces and the use
> of flashback queries? Are there any 'best practices' yet? Is anyone
> pushing the envelope with these? Any performance data?
>
> Any insight would be appreciated.
>
> Mark

Haven't tried a lot it yet but one thing to consider is that generally larger rollback segments make a system more IO bound (since a smaller % of rollback fits in the buffer cache).

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."