DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: extent?

  1. #1
    Join Date
    Jun 2001
    Posts
    193
    create tablespace tb1 datafile '/u02/oradata/test/test1.dbf' size 100m extent management local uniform size 128k;

    alter tablespace tb1 add datafile '/u03/oradata/test/test2.dbf' size 200m autoextend on;

    question:
    i create a tablespace named tb1 which include two datafiles.
    one is not extentable, another is extentable.
    when this datafile need to extend, how much will it extent?
    which table should i look to find this information.
    guru is on the way!!!!

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Code:
    set linesize 222
    set pages 100
    col file_name for a55
    col tablespace_name for a20
    select df.file_name, df.tablespace_name, df.bytes/1024/1024 mb, 
       df.AUTOEXTENSIBLE, df.maxbytes/1024/1024 max_mb, 
       (df.increment_by*p.blksize)/1024/1024 Increment_mb,
       t.extent_management, t.allocation_type, df.status
    from dba_data_files df, 
         dba_tablespaces t,
       (select to_number(value) blksize from v$parameter where name = 'db_block_size') p
    where t.tablespace_name = df.tablespace_name
    union all
    select tf.file_name, tf.tablespace_name, tf.bytes/1024/1024 mb, 
       tf.AUTOEXTENSIBLE, tf.maxbytes/1024/1024 max_mb, 
       (tf.increment_by*p.blksize)/1024/1024 Increment_mb,
       t.extent_management, t.allocation_type, tf.status
    from dba_temp_files tf, 
         dba_tablespaces t,
       (select to_number(value) blksize from v$parameter where name = 'db_block_size') p
    where t.tablespace_name = tf.tablespace_name
    order by tablespace_name
    /
    Jeff Hunter

  3. #3
    Join Date
    Mar 2001
    Posts
    314
    If you don't specify the MAXSIZE parameter or specify MAXSIZE as UNLIMITED, the maximum the datafile will grow is 32G (atleast that's what I have observed is set by Oracle).

    Has anybody seen anything else ?

    -amar

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