snapshot and cursor
- From: seinbert@xxxxxxxxx
- Date: 31 Mar 2006 11:28:07 -0800
Hi,
What I am wondering is if Oracle needs to retain fetched rows of a
snapshot
for read consistency.
Seems to me, the fetched rows cannot be reused, and therefore can be
realeased
from undo space if they've modified and commited.
But I think Oracle still wants to keep these in undo space, and give
snapshot too old
error when they are pushed out.
Thank you for your help.
seinbert
.
- Prev by Date: Re: empty block vs no. freelist blocks
- Next by Date: Re: Statspack analysis
- Previous by thread: DCD and JDBC_THIN
- Next by thread: Need query for which session is on which RAC instance
- Index(es):