Thanks to all (especially Rachel) for the suggestions. I did a little
testing and found:
# of IOs in 9i is 3
Creation of index (with analyze on table and index) made no change to IOs in
9i
Creating a view & synonym on sys.x$dual reduced the IOs to 0...
However, there is an inst_id column in sys.
ember any more . . .
>
> Barb
>
>
> > --
> > From: Fink, Dan[SMTP:[EMAIL PROTECTED]]
> > Reply To: [EMAIL PROTECTED]
> > Sent: Thursday, May 30, 2002 10:23 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Using DUAL
> >
> > The developers he
Thursday, May 30, 2002 10:23 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Using DUAL
>
> The developers here have a fondness for using DUAL for simple
operations
> (select count(*) from dual is executed 1+ times per day). I
recall a
> passing comment
th creating an x$dual table as a workround to hammering dual.
Sorry I can't remember any more . . .
Barb
> --
> From: Fink, Dan[SMTP:[EMAIL PROTECTED]]
> Reply To: [EMAIL PROTECTED]
> Sent: Thursday, May 30, 2002 10:23 AM
> To: Multiple reci
Fink, Dan[SMTP:[EMAIL PROTECTED]]
> Reply To: [EMAIL PROTECTED]
> Sent: Thursday, May 30, 2002 10:23 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Using DUAL
>
> The developers here have a fondness for using DUAL for simple operations
> (select coun
System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Original Message-
Sent: Thursday, May 30, 2002 11:23 AM
To: Multiple recipients of list ORACLE-L
The developers here have a fondness for using DUAL for simple operations
(select count(*) f
-Original Message-From: Fink, Dan
[mailto:[EMAIL PROTECTED]]Sent: Thursday, May 30, 2002 11:23
AMTo: Multiple recipients of list ORACLE-LSubject: Using
DUAL
The developers
here have a fondness for using DUAL for simple operations (select
count(*) from dual is executed 1+ times
The developers here
have a fondness for using DUAL for simple operations (select count(*)
from dual is executed 1+ times per day). I recall a passing comment
somewhere/sometime that there are performance issues with accessing DUAL.
Of course, now that I need to provide some information