Re: Oracle Dirty Read Question

Vish magapu (magapuv_at_ix.netcom.com) wrote:
: According to Oracle manuals (for Ver 7.1) Oracle Never does a "dirty
: read". That means (as I understand) if somebody wites the data but has
: not committed, others users will not be able to see it. But suppose I
: executed the following sequence of statements:
: login as scott/tiger
: create table test (col1 varchar2(1));
: -- Grant select to someuser on test
: insert into test vlaues('X');
: -- But I do not commit;
: login as someuser;
: select * from test;
: -- I get one row which is 'X'
: If Oracle does not do dirty reads how this is possible. Am I
: mis-understanding the concept.
: Please help.
 

: Thanks,
: Vish
 

: --------------------------------------------------------------
: Name: Vish Magapu
: E-mail: Vish Magapu <magapu_at_monet.fujitsu.com>
: Date: 04/07/97
: Time: 15:44:24
: --------------------------------------------------------------

--
Hi

if your 'login as someuser' is connect username/password in SQL*Plus
it will commit;  A connect to another user implies an exit from the 
session where tha data was inserted, and exit does, as the manual says, commit;

So this is not a 'dirty read' but a read of commited data.

Rgds
Steinar Heggelund

----------------------------------------------------------------------------
I'm employed in the Norwegian consulting company Opus One AS. 
I have 7 years experience with Oracle products, mainly the database. 
We are a small company which offers consulting services in design,
implementation and tuning of databases and applications based on Oracle.

My postings represent my opinions and they may be wrong.