Oracle Caching
Whenever a user accesses a data table, an Oracle server process created on his behalf reads the data from the data file into the SGA.
When another user attempts to access that same data, his server process will read from the copy in memory.
If another user attempts to modify it, his server process will make changes to the copy in memory. DBWR will write these changes to disk in its due time.