Snitz Forums 2000
Home
|
Profile
|
Register
|
Active Topics
|
Members
|
Search
|
FAQ
Username:
Password:
Save Password
Forgot your Password?
All Forums
Snitz Forums 2000 DEV-Group
DEV Discussions (Oracle)
Calculate Last Segment? Urgent!!
Forum Locked
Printer Friendly
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)](n-2)
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
Forum Locked
Printer Friendly
Jump To:
Select Forum
Announcements
Announcements: Security Related Bug Fixes
Announcements: Community
Announcements: New Releases
A Testing Area
Testing Forums
Help Groups for Snitz Forums 2000 Users
Help: General / MVC version(v1.XX)
Help: General / Classic ASP versions(v3.4.XX)
Help: General / Previous versions
Help: Database: MS Access
Help: Database: MS SQL Server
Help: Database: MySql
Help: Mail Configuration
Help: MOD Implementation
Help: Authentication: NT
Help: General / Current Version (Old)
Frequently Asked Questions
FAQ About This Site
HOW DO I FAQs
FAQs for Using Snitz with Access
FAQs for Using Snitz with mySQL
FAQs for Using Snitz with SQLServer
FAQ for Beginners to Snitz Forums
FAQ For Developers
FAQ for Webmasters
FAQ Addition Requests
Snitz Forums 2000 MOD-Group
Mod Integration Project (BUG Reports)
MOD Completed Add-Ons
MOD Add-On Forum (W/Code)
MOD Add-On Forum (W/O Code)
Community Forums
Graphics & Style in Snitz!
Suggest forum.snitz.com Content
Show-Off Your Forums
Code Support: ASP (Non-Forum Related)
Code Support: ASP.NET (Non-Forum Related)
Community Discussions (All other subjects)
Snitz Forums 2000 DOC-Group
DOC Discussion
DOC In-Box
DOC Out-Box
Snitz Forums 2000 DEV-Group
DEV Bug Reports (Open)
DEV Discussions (General)
DEV Discussions (Oracle)
DEV Discussions (VFP)
DEV Bug Reports (Closed)
DEV Internationalization (v4-archive)
DEV Internationalization (v4)
URLs and Other Resources
Snitz Forums 2000 - Classic ASP version
SnitzBitz
Snitz MVC development site
Snitz Downloads/etc...
SourceForge
--------------------
Home
Active Topics
Frequently Asked Questions
Member Information
Search Page
Snitz Forums 2000
© 2000-2021 Snitz™ Communications
This page was generated in 0.05 seconds.
Forum Locked
Posted - 06 November 2004 : 23:02:29
<
