does anyone know why x$dual has the reduce overhead? How is Oracle managing the memory structure? Most x$tables incur serious performance problems. I would be hesitant to use it, unless I knew more about what was going on internally. -------------- Original message -------------- > > The app server would be calling this query many thousands > > of times each day. > > Scary. What I expect for you to see is much network bandwidth consumed = > by > what a performance analyst will later call "wasted workload." If you do = > the -- To unsubscribe - mailto:oracle-l-request@xxxxxxxxxxxxx&subject=unsubscribe To search the archives - //www.freelists.org/archives/oracle-l/