RE: Question about Dual

  • From: ryan_gaffuri@xxxxxxxxxxx
  • To: cary.millsap@xxxxxxxxxx, <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 10 Sep 2004 20:44:43 +0000

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 - http://www.freelists.org/archives/oracle-l/

Other related posts: