Archives of the TeradataForum

Message Posted: Wed, 10 Sep 2003 @ 12:56:47 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Spool is more of a limit , the extent to which space could be used up by a transaction. So if you were to have 20 users under SYSDBA than all of them could in fact stretch to the same limit as that set for SYSDBA, or you could limit on the spool usage by each user under SYSDBA. Specifying say 'x' spool space from 'X' spool space of the SYSDBA for one user doesnot mean that the remaining user would have to content with 'X-x' spool space. In fact the remaining users could stretch upto 'X' that is defined on SYSDBA, if nothing explicit is mentioned on the individual users(remaining) under SYSDBA.

But if you need to ensure that all users under SYSDBA, get an equal share of the pie, without having to contend for what is left{if the usage is simultaneous }, then you could restrict on how much each would use from what is available from SYSDBA - by allocating accordingly{AGAIN it is just a limit}

Narayan.

	<Prev	Next>		<<First	<Prev	Next>	Last>>