OraFAQ Forum: Server Administration » RE:Increment

Home » RDBMS Server » Server Administration » RE:Increment_by

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

RE:Increment_by [message #62859]

Thu, 19 August 2004 23:25

dhnish
Messages: 26
Registered: March 2002

Junior Member

Hi

Pls advice.. what does the field 'increment_by' in dba_data_files refer to?

Thank you and have a nice day

Yours in service

dhnish

Report message to a moderator

Re: RE:Increment_by [message #62888 is a reply to message #62859]

Sun, 22 August 2004 12:28

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

Hi,

INCREMENT_BY is the next increment value for datafile autoextension. Multiply this value with you block size to get a byte value.

SQL> ALTER DATABASE
  2      DATAFILE '/app/oracle/product/10.1.0/db_1/oradata/orcl/example01.dbf'
  3      AUTOEXTEND ON NEXT 8M
  4  /

Database altered.

SQL>
SQL> SELECT increment_by "Blocks", increment_by * (bytes/blocks) /1024/1024 "Meg"
  2    FROM DBA_DATA_FILES
  3   WHERE file_name = '/app/oracle/product/10.1.0/db_1/oradata/orcl/example01.dbf'
  4  /

    Blocks        Meg
---------- ----------
      1024          8

Best regards.

Frank

Report message to a moderator

Previous Topic:	Data File Size ?
Next Topic:	Export Zip and Split

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 08:29:09 CDT 2024