Home » Developer & Programmer » Forms » Oracle - Table Indexes - Storage Clause
Oracle - Table Indexes - Storage Clause [message #375335] Wed, 09 August 2000 03:33 Go to next message
Thomas Guiot
Messages: 1
Registered: August 2000
Junior Member
Dear all,

Does anybody know a reliable way to calculate the storage clause when you create new tables and indexes.

Thanks in advance.

Thomas

Report message to a moderator

Re: Oracle - Table Indexes - Storage Clause [message #375337 is a reply to message #375335] Thu, 17 August 2000 09:33 Go to previous messageGo to next message
JOHN
Messages: 182
Registered: April 1998
Senior Member
You might try total number of characters for a fully populated row * the estimated number of rows. This will give you an estimate of the space required for the table.

As for indexes you might try max(length(index key)) * number of estimated rows.

Get with your DBA for any intial extents and next extent sizing and pctincrease requirements at your site.

Hope this helps.

Report message to a moderator

Re: Oracle - Table Indexes - Storage Clause [message #375338 is a reply to message #375335] Thu, 17 August 2000 09:33 Go to previous messageGo to next message
JOHN
Messages: 182
Registered: April 1998
Senior Member
You might try total number of characters for a fully populated row * the estimated number of rows. This will give you an estimate of the space required for the table.

As for indexes you might try max(length(index key)) * number of estimated rows.

Get with your DBA for any intial extents and next extent sizing and pctincrease requirements at your site.

Hope this helps.

Report message to a moderator

Re: Oracle - Table Indexes - Storage Clause [message #375339 is a reply to message #375335] Thu, 17 August 2000 09:33 Go to previous message
JOHN
Messages: 182
Registered: April 1998
Senior Member
You might try total number of characters for a fully populated row * the estimated number of rows. This will give you an estimate of the space required for the table.

As for indexes you might try max(length(index key)) * number of estimated rows.

Get with your DBA for any intial extents and next extent sizing and pctincrease requirements at your site.

Hope this helps.

Report message to a moderator

Previous Topic: Forms 4.5(32 bit) and Forms 5.0
Next Topic: MyOwnMenu&Smartbar
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 31 16:39:40 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.