Thanksmy Q about DML ...
Mohanad Awad wrote:not me.
The DOC include every process , buffer alone ... but it dose not discus that with DML ..
Can any one answer above Q without links please ?
Mohanad Awad wrote:you will get the new record for SELECT that starts after the COMMIT is issued.
it seem this link what i need .. thanks ,
Just one Q please : if i execute below insert :
insert into scott.dept values (99,'Database',null);
- before write dirty buffer and before checkpoint : i execute below query :
select * from scott.dept where deptno=99;
dose the data exist on data file on physical hard disk or just exist on database cache buffer ? i know sure oracle does the right thing; even when you do not understand what actually occurs. i ask just to understand !
Mohanad Awad wrote:what difference does it make?
I know that but on above case (After commit) And (Before write dirty data and before checkpoint) ,
the select statement will be from database buffer or database file ? because it DBWR dose not run until now ????
Mohanad Awad wrote:COMMIT GUARANTEES data is recoverable!
So no different ? i told you before to know what the step just ! for me as user dose not different ...
But as you DBA i want to answer that ? this mean if dose not different if shutdown happen on that time we will lose the data .. coz it's still in buffer ... and if logfile corrupted ...