spool space allocation

Database
Enthusiast

spool space allocation

I have some doubt on spool space allocation for a particular user on the below scenario:

Suppose user SYSDBA has 500 GB of perm space. It creates user MRKT with 300 GB of perm space and 300 GB of spool. Then user MRKT creates user ADVT with 100 GB of perm space and 100 GB of spool space. So finally user MRKT will be left with 200 GB of perm space and 300 GB of spool.

Now user MRKT creates some tables of 100 GB size in its user space.

Then how much spool space will MRKT user have after creating the tables?

Will it be 300 GB or 200 GB spool space after creating the tables?

Tags (1)
2 REPLIES
Junior Contributor

Re: spool space allocation

The spool of a user does not depend on the user's perm space (otherwise most end users would have severe problems as they got PERM = 0).

So MRKT still can utilize up to 300GB spool (unless the system runs out of space).

Enthusiast

Re: spool space allocation

thnks..for the clarification...