Home » RDBMS Server » Server Administration » How to Calculate Extent Size
How to Calculate Extent Size [message #57514] Fri, 20 June 2003 00:54 Go to next message
Velu Natarajan
Messages: 16
Registered: July 2002
Junior Member
Dear ALL,
I created a table in Oracle tablespace managed locally.

CREATE TABLE TESTER
(COL1 VARCHAR2 PRIMARY KEY)
TABLESPACE TESTDATA
STORAGE (INITIAL 50M NEXT 100M PCTINCREASE 20
MINEXTENTS 1 MAXEXTENTS 200);

Here, my question is how large the fifth extent Oracle allocates will be?

How to calculate on this... What's role of PCTINCREASE.

Thanks!
Velu N

Report message to a moderator

Re: How to Calculate Extent Size [message #57522 is a reply to message #57514] Fri, 20 June 2003 05:37 Go to previous message
Deepa
Messages: 269
Registered: November 2000
Senior Member
hi this is how it allocates extents

first extent=50M
second extent(next)=100M
third extent= next+(1+pctincrease/100)

Report message to a moderator

Previous Topic: '0000/06/19' is correct?
Next Topic: Corrupt Database
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Feb 14 21:32:48 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.