By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,779 Members | 1,111 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,779 IT Pros & Developers. It's quick & easy.

Confused over data page utilization

P: n/a
I've tried this post on the listserv with little or no results.
Hopefully someone can clear this confusion up for me.

I've got a situation that has me somewhat befuddled. I have three
tables all with approximately 600,000 records. Here are some
statistics
concerning the three tables:
tblname rows pages avg. rows/pg rowsz in bytes

tab1 599928 18772 31.95866 1000
tab2 601006 100265 5.994175 630
tab3 601007 2377 252.8427 37

All tables are in a single 32k DMS tablespace(please don't go there,
that's a
topic for another discussion). There are hundreds of additional tables
in the same tablespace. I'm only using these three tables as an
example. Obviously I've done my own math to get the average rows/pg.
What I don't understand is tab2 taking 100,000+ pages at approximately
6 rows/pg. Indexes are in there own tablespaces. Pctfree is not set.
I've done a reorg check on all of the above tables. No reorgs
recommended. I did reorgs anyway and no significant change.

Someone please tell me the important point that am I missing? It
just doesn't make sense to me.

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a

<fr*****@gmail.com> wrote in message
news:11**********************@g44g2000cwa.googlegr oups.com...
I've tried this post on the listserv with little or no results.
Hopefully someone can clear this confusion up for me.

I've got a situation that has me somewhat befuddled. I have three
tables all with approximately 600,000 records. Here are some
statistics
concerning the three tables:

tblname rows pages avg. rows/pg rowsz in bytes

tab1 599928 18772 31.95866 1000
tab2 601006 100265 5.994175 630
tab3 601007 2377 252.8427 37

All tables are in a single 32k DMS tablespace(please don't go there,
that's a
topic for another discussion). There are hundreds of additional tables
in the same tablespace. I'm only using these three tables as an
example. Obviously I've done my own math to get the average rows/pg.
What I don't understand is tab2 taking 100,000+ pages at approximately
6 rows/pg. Indexes are in there own tablespaces. Pctfree is not set.
I've done a reorg check on all of the above tables. No reorgs
recommended. I did reorgs anyway and no significant change.

Someone please tell me the important point that am I missing? It
just doesn't make sense to me.


How are you computing the "rowsz in bytes"? Depending on what types you're
using (CHAR vs VARCHAR, for example), there may be more bytes allocated on
disk than you think.

--
Matt Emmerton
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.