Hi all,

I need some clarification about hot backups. My doubt is

When issue the statement tablespace begin backup,DBWR write dirty blocks to datafile which contains the data files in that TS. After that sequence number frozen right, My data file size is very big. If concurrent users applying DMLs which related to that data file Where it writes new value and old value ? Where it store the data ? is it in Buffer Cache, Log Buffer and Redo log files ?

I am little bit confusion regarding. Please any one clarify.

and where we can find running sql statements ?