Home » RDBMS Server » Server Administration » INCREMENT_BY
INCREMENT_BY [message #160092] Thu, 23 February 2006 03:28 Go to next message
gajini
Messages: 262
Registered: January 2006
Senior Member
How to know how much a datafile will increment if AUTOEXTEND ON?

Please anyone answer for this question asap.

Report message to a moderator

Re: INCREMENT_BY [message #160508 is a reply to message #160092] Mon, 27 February 2006 01:09 Go to previous message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
query dba_data_files
Check value of increment_by column. file will increment by size of value(increment_by)*block size/1024 KB.

--Girish

Report message to a moderator

Previous Topic: FORCE_LOGGING
Next Topic: Package Compilation Error
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 14:34:57 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.