QUESTION:
Describe the basic steps involved in processing a SQL statement,and what kind the Memory and the Algorithm using by SQL statement?
If the database administrator want to change the memory size ,How to do it ?
SQL execution step including:
parse
bind
execute
fetch(not always need)
which part do you want to change? pga or sga?
You can change it by modify init parameter.