Here is an Interesting topic about FAST DUAL and Full Table Scan on Dual table with some example about how not to play with Oracle Data Dictionary Objects. http://www.orafaq.com/forum/mv/msg/173068/515910/136607/#msg_515910 Happy reading…. Sriram 🙂