Dynamic cursors use more resources than any other type, but they also give the most flexibility . Dynamic cursors receive updates to the data from the server whenever another application causes an insert, update, or delete. You can imagine that the overhead needed to maintain this link could be considerable. You might choose a dynamic cursor in cases where not having live data can result in conflicts.