Oracle DBMS Execution Plan

************** EXECUTION PLAN ************

desc plan_table;

EXEC dbms_stats.gather_table_stats('user8','ex_emp');

Explain Plan for select * from ex_emp;

select * from table(dbms_xplan.display);

Some useful Info about Oracle:
-----------------------------
1. All the DML Operations takes place in Memory
2. Data Buffer (Memory), Redo Log Buffer, Ctrl file, Data file , log file.
everytime u perform dml operation, will not write directly in data file. once the entire buffer gets full then only it will write in Data file.
one the Check point happen.
3.Data file connot contain uncommited transactions.
4.Uncommited transactions are roll back.
5. All transactiosn happening in Data Buffer only.