What is the temp space in a database? How do I determine the size of a table?
When a database or user is created, the allocated disk space is split evenly.If the SUM aggregate is used, the DiskSpace view returns one row of usage information for each AMP.
When a database is created, a space row is added on each AMP, with the processor field in each row set to 0.When a table is created in the database or the system is restarted, the processor field in each row is updated to reflect the actual processor number.
You can use the DiskSpaceV[X] view to build and maintain a table of disk space usage statistics.
The history table has statistics from the DiskSpaceV[X] view.
The next collection period has 2 Reset DiskSpace counters.
The ClearPeakDisk macro is provided on the release tape and can be used to reset the maximum and peakSpace Disk counters to zero.
The default account name is the AccountName column.There is only one account for a database.A user may have more than one account.If there is a profile for the user that specifies a default account, that account supersedes the account name.
If the SUM aggregate is specified, this column returns the persistent spool space that is currently used by the database.