user quota
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: user quota

  1. #1
    Join Date
    Aug 2000
    Posts
    163

    Cool

    Please help me I am confused. I had am impression that if quota is unlimited it would show up as -1 in dba_ts_quotas. When I query dict_columns it says it would be null for both max_bytes and max_blocks.
    SELECT * FROM DICT_COLUMNS
    WHERE TABLE_NAME='DBA_TS_QUOTAS'

    TABLE_NAME COLUMN_NAME COMMENTS
    --------------- --------------- --------------------------------------------------
    DBA_TS_QUOTAS TABLESPACE_NAME Tablespace name
    DBA_TS_QUOTAS USERNAME User with resource rights on the tablespace
    DBA_TS_QUOTAS BYTES Number of bytes charged to the user
    DBA_TS_QUOTAS MAX_BYTES User's quota in bytes. NULL if no limit
    DBA_TS_QUOTAS BLOCKS Number of ORACLE blocks charged to the user
    DBA_TS_QUOTAS MAX_BLOCKS User's quota in ORACLE blocks. NULL if no limit

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Its showing up '-1'. May be descriptive purpose comments are like that . Verson is 815 .

    TABLESPACE USERNAME BYTES MAX_BYTES BLOCKS MAX_BLOCKS
    ---------- ---------- --------- --------- --------- ----------
    TOOLS SYSTEM 102522880 -1 25030 -1
    TEMP SYSTEM 0 -1 0 -1
    USERS SFAGO 0 -1 0 -1
    USERS HELER 0 -1 0 -1
    TEMP HLLER 0 -1 0 -1
    USERS PROD 0 -1 0 -1
    USERS NAV3 626688 -1 153 -1

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    hmmmm. I wonder if they are giving a distinction between UNLIMITED the value and NULL as an absence of a value?
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  4. #4
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    I think you are right! In the enterprise Manager it can be interpreted like this(infact, its showing..)

    Unlimited..........for -1
    None................for no quota

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width