Add area parameters to dbanalys output

  • Thread starter Thread starter Rob Fitzpatrick
  • Start date Start date
Status
Not open for further replies.
R

Rob Fitzpatrick

Guest
It would be helpful to have the values for area records per block and blocks per cluster added to the output of dbanalys/tabanalys (e.g. in the area summaries prior to RECORD BLOCK SUMMARY). This would aid programmatic assessment of database structure. For example, one could write code to determine: whether an area consumes too much space on disk because its RPB is set too low given the mean record size of the table(s) it contains; whether the area BPC is set appropriately given the size of the tables it contains.

Continue reading...
 
Status
Not open for further replies.
Back
Top