This was taken from this web site questions posted by James Koppermann ,
anyone who knows the answers request u to reply,
1 give the two types of tables involved in producing a star schema and the type of data they hold.
2 what column differentiates the V$ views to the GV$ views and how?
3 what background processes refreshes materialized views.
Pravin