how the sql query will process via sga what is the execution path of simple select * from table_name?
Printable View
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?
[QUOTE=susturge;22050]How database is organised in oracle?[/QUOTE]
You need to go through some good books for the same ,can also find out all those by investing some time in web searching.