Author 
Topic 

sonicboy
Starting Member
11 Posts 
Posted  06 November 2004 : 23:02:29

Help! Can someone please give me an example of a scenario with solution on how to go about calculating the last segment in Oracle? Thanks so much! < 

laser
Advanced Member
Australia
3859 Posts 
Posted  07 November 2004 : 02:33:10

Are you talking OLAP or normal RDBMS ?
Either way, I think you're posting in the wrong forum.< 


sonicboy
Starting Member
11 Posts 
Posted  07 November 2004 : 04:02:48

I'm not so sure about that but the question and solution for Calculation of the size of last extent is as follows:
Question: Calculate, showing your working in detail, the size of the 3rd and 5th extent where INITIAL = 100 KB, NEXT = 200 KB, PCTINCREASE = 20.
Solution: Size = NEXT * [ 1 + ( PCTINCREASE/100)](n2)
Size of 3rd extent = 200*(1+0.2) = 240 KB
Size of 5th extent = 200*(1+0.2)3 = 345.6 KB
From the above, I hope you can figure out whether my doubts is related to OLAP or normal RDBMS. Thanks.< 


laser
Advanced Member
Australia
3859 Posts 
Posted  07 November 2004 : 04:34:10

Sounds like more RDBMS like I thought, but the term "segment" also has a definition in the new OLAP 9i/10g world.
So, you're talking normal RDBMS and I can't help you at all in relation to that, but your maths seems fine ...
1.100 (initial) 2.200 (next) 3.240 (#2 + 20%) 4.288 (#3 + 20%) 5.345.6 (#4 + 20%)
This is just what I calculated based on the formula you provided. < 


sonicboy
Starting Member
11 Posts 
Posted  07 November 2004 : 05:36:04

The above formula that I have provided is for calculation of the size of the last extent. Is there actually a formula for calculating the size of the last segment?< 



Topic 
