Jared,
I think he is talking about direct grants. Not granting through a view.
SQL> grant select on X$BH to system;
grant select on X$BH to system
*
ERROR at line 1:
ORA-02030: can only select from fixed tables/views
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-----Original Message-----
[EMAIL PROTECTED]
Sent: Tuesday, March 05, 2002 10:13 AM
To: Multiple recipients of list ORACLE-L
I'll take the easy question.
There's nothing preventing you from granting privs on the x$ tables.
See:
http://www.ixora.com.au/scripts/sql/create_xviews.sql
Jared
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
03/04/02 04:53 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: Read Consistency & ITL's
Hello Gurus,
As I understand it. In order to provide a read consistent view of the data
while reading a data block, Oracle looks at the SCN in the block header,
and compares it to the snapshot of the SCN taken when the read commenced.
If the Snapshot SCN is less than the SCN in the block header, the query is
directed to read from the rollback segments.
For any transaction that modifies a block, the ITL among other things,
also
stores the commit SCN and the address to the transaction table in the
rollback segment. Assume that the block has just one ITL. This ITL can be
reused once the transaction is completed. Assume it is. That is, two
transactions have performed updates on the block since our read commenced.
If so is the case, how does Oracle know which rollback segment to look at?
I am assuming it still looks at the ITL, rolls it back, sees that it needs
to rollback further, looks at the ITL in the rolled back block, and
rollsback further, and so on, until it can reconstruct the data block at
an
SCN lower than the snapshot SCN. Is that right?
My second question is, what happens if the data block has two ITL's, both
marked with SCN's greater than when the read commenced. Which ITL does
Oracle look at to get the address of the rollback segment? Is it the one
with the least SCN??
And also, my previous question, remains unanswered so far? Why does Oracle
not allow one to grant select privileges on the fixed tables to any other
user?
Thanks
Raj
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: K Gopalakrishnan
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
