How long does Oracle keep history of blocking sessions?
Is historical info available via dynamic or DBA views regarding blocking sessions and if so how far into the past do they extend? I know performance packs are needed to access historical views and we're licensed to use them.
Your responses are appreciated,
Thanks,
0