Are you logged on as SYS ?
Pretty much select from as
SYS will return '0' for the relevant stats - which is
course is not reflective on what's really happening
hth
connor
--- david hill <[EMAIL PROTECTED]> wrote: >
Just wondering here but has anyone tried doing that
> select from something
>
Sorry brain dead. Been working day and night for 5 days. Not much sleep. Makes
perfect sense now.
Kathy
-Original Message-
Sent: Friday, August 02, 2002 4:38 PM
To: Multiple recipients of list ORACLE-L
Correct. DUAL is a table owned by SYS for which SELECT permissions have
been gr
Correct. DUAL is a table owned by SYS for which SELECT permissions have
been granted to PUBLIC. V$DUAL is a view on a special "fixed" table named
X$DUAL. The SELECT permissions here are granted on the *view*; they cannot
be granted on a fixed table (i.e. X$ table). So, you're queries succeed
b
Title: RE: DUAL revisited
> -Original Message-
> From: Kathy Duret [mailto:[EMAIL PROTECTED]]
>
> But I don't get this error when I query from dual just from
> the new v$dual.
That's because your v$dual view is assessing a SYS.X$ "table". To do
But I don't get this error when I query from dual just from the new v$dual.
Kathy
-Original Message-
Sent: Friday, August 02, 2002 12:54 PM
To: Multiple recipients of list ORACLE-L
...if you're going to query from an account other than SYS, then please SET
AUTOTRACE TRACEONLY STATISTIC
...if you're going to query from an account other than SYS, then please SET
AUTOTRACE TRACEONLY STATISTICS (instead of SET AUTOTRACE ON) so it doesn't
try to do an EXPLAIN PLAN. You cannot grant SELECT on X$ tables to anyone
other than SYS, which affects EXPLAIN PLAN also...
- Original Messa
Just wondering here but has anyone tried doing that select from something
like v$database;
Statistics
--
0 recursive calls
0 db block gets
0 consistent gets
0 physical reads
0 redo size
I followed the instructions but I get the error below. I do not get the same error
when I select from dual. And yes I did to the public grant. And other clues? DB
8.1.7.3
Thanks Kathy
Execution Plan
-