| Re: Background Process in SGA [message #69393] |
Sat, 22 December 2001 05:41 |
Girdhari Ram Choudhary
Messages: 8
Registered: December 2001
|
Junior Member |
|
|
In oracle every query has three state.
1.Parse
2.Execute
3.Fetch
In parse phase checks for statement syntax and validate the table and column name.then checks the user has previlage to execute the statement
then determine optimal execution plan.
oracle execte the parsed statement in execute phase
DBWR is not at all related to DDL.DBWR writes all the dirty buffer to disk whenver checkpoints occure.
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
