All Forums Database
barani_sachin 141 posts Joined 01/12
14 Mar 2013
Usage of Spool?

Hi All,
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??

Tags:
dnoeth 4628 posts Joined 11/04
15 Mar 2013

Spool usage for any query will always be based on the submitting user.
Dieter

Dieter

barani_sachin 141 posts Joined 01/12
15 Mar 2013

Thanks Dieter :)

You must sign in to leave a comment.