Oracle Database Discussions

Hi all Experts,

i m very sory to take your time for a very basic level question. actually in my mind i have a confusion about the DB Buffer cache and Log Buffer cache
my question is in DB Buffer cache the are three types of data i-e dirty, pinned and free. and in dirty they are all changed data data and are ready to flush by DBRW. and then write it datafiles.

but on the other hand redo bufers also working for changed data and all changed data is temporaryliy chacheed to redo bufers and the LGWR writes them into log files. and this data may be commited data or not . and when log switch is take place then it writes commited data to datafiles

my question is if a log file can have both type of data comited and uncommited and when a log switch occures then only commited data is transfered to datafiles then where is uncommited data goes ???


if dirty buffers also contain changed data so wath is the diffrence between log bufers data and dirty data.

i know this may be funny. but i m may be misguided abot the concept. please correct my concept regarding this

thanx alot

regards,