how the sql query will process via sga what is the execution path of simple select * from table_name?
how the sql query will process via sga what is the execution path of simple select * from table_name?
SQL > set autotrace on
SQL > SELECT * FROM EMP;
u can find execution plan
How database is organised in oracle?