Good catch! I guess that might be another reason for heavy use of c_user#. If user X has a quota on tablespace Y, then anytime user X allocates/deallocates extents in tablespace Y, sys.tsq$ will be updated to reflect user X's usage in tablespace Y.
-----Original Message-----
From: Khedr, Waleed [mailto:[EMAIL PROTECTED]]
If the cluster contains also the current disk usage as part of table TSQ$ then this means that Oracle has to keep updating the cluster everytime a user adds or releases disk space, right?
-----Original Message-----
From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]]
SYS.C_USER# is the name of the cluster that contains the USER$ table (list of usernames in the database) and the TSQ$ table (list of tablespace quotas for each user). ...
