Re: Online Table Extents 2

ogradypa@vianet.on.ca (pat ogrady) wrote: >This is a follow up to my earlier post regarding online table extents. > > On doing some more searching in the manuals, I found the oncheck command. > Running oncheck -pt for the tables mentioned in earlier post shows > that the first extent is 30 pages, next extent 15 pages. This is half of what > I specified in create database statement ( create table extent size 60 next size 30). > > Any enlightment would be appreciated. The difference is IMHO that the EXTENT/NEXT SIZE-clause in the CREATE TABLE-statement is not in pages (as noted in the manuals) but in kB, while oncheck reports the size in pages. That means, your table is as big as 60kB, which is 30 pages, assuming that your server's page-size is 2k. Peter