Home » RDBMS Server » Server Utilities » table sizes and indexes
table sizes and indexes [message #71619] Wed, 04 December 2002 15:21 Go to next message
Lena
Messages: 17
Registered: August 2002
Junior Member
Can someone please tell how much space is table currently using?
Is it = INITIAL_EXTENT + BLOCKS * NEXT_EXTENT

Can this = INITIAL_EXTENT + LEAF_BLOCKS * NEXT_EXTENT
be used to calculate space index is using?

Any help would be great
Thanks
Lena

Report message to a moderator

Re: table sizes and indexes [message #71623 is a reply to message #71619] Thu, 05 December 2002 03:34 Go to previous message
B
Messages: 327
Registered: August 1999
Senior Member
No Ur wrong ...
same eq for TABLES and INDEXES

size = INITAL + SUM ( 0 , NB_EXTENTS , ( 1+PCT_INCREASE)^N * NEXT )

Report message to a moderator

Previous Topic: SQLLDR: Strange problem
Next Topic: Error occur when using Terminal Service to run "svrmgrl"
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed May 15 02:35:58 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.