Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Performance - Usage of Dual Table - Is a resource contention issue?

415841Feb 28 2004 — edited Feb 28 2004
Hi All,

I have a conceptual question regarding the use of dual table. In a discussion at the office, some people argument that in a large transactional system there could be a resource contention accessing dual table.

Therefore it was suggested as a good programming practices to avoid the use of dual.

I do not think that it is an issue to use dual; dual probably is a table always in memory and catch by the user process....

Opinions? Some body knows any article that has explored this point?

Thank you,

- Juan
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 27 2004
Added on Feb 28 2004
1 comment
351 views