Subject | Difference between Oldest Active and Next Transaction |
---|---|
Author | Chooi-Ting |
Post date | 2003-06-12T09:36:23Z |
If the difference between oldest active and next transaction is
increasing, will it effect the performance of the database (for sql
query)?
eg.
Oldest Transaction 2248862
Oldest Active 2248868
Oldest snapshot 2248868
Next transaction 2255385
diff = 6517
rgds, chooi-ting
increasing, will it effect the performance of the database (for sql
query)?
eg.
Oldest Transaction 2248862
Oldest Active 2248868
Oldest snapshot 2248868
Next transaction 2255385
diff = 6517
rgds, chooi-ting