Lets say i have a view like
create view view1 as
sel * from tab1 inner join tab2 loj tab3;
When user A hits this view, the spool required for the operation "sel * from tab1 inner join tab2 loj tab3" is taken from user A or by some other means??