RE: c_USER#

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Tue, 13 Aug 2002 17:13:22 -0800
Message-ID: <F001.004B3CF9.20020813171322@fatcity.com>

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-----  

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-----

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). ...

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Jacques Kilchoer
  INET: Jacques.Kilchoer_at_quest.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Aug 13 2002 - 20:13:22 CDT