Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Question about Dual

RE: Question about Dual

From: <ryan_gaffuri_at_comcast.net>
Date: Fri, 10 Sep 2004 20:44:43 +0000
Message-Id: <091020042044.10113.4142123A000A45B6000027812200734830079D9A00000E09A1020E979D@comcast.net>


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_at_freelists.org&subject=unsubscribe 
To search the archives - http://www.freelists.org/archives/oracle-l/
Received on Fri Sep 10 2004 - 15:40:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US