Calculating Average Row Length in Oracle 10g
From: Nag <naga.challa_at_gmail.com>
Date: Tue, 9 Jun 2009 11:38:47 -0700 (PDT)
Message-ID: <36c2aca6-179f-4068-adfe-fc6c18ac7baf_at_r3g2000vbp.googlegroups.com>
All,
We can get this by analyzing the tables in a schema and looking at the column avg_row_len.
But, is there a sql so that I can calculate manually. In out environment, we gather statistics once and use them all the time.
Date: Tue, 9 Jun 2009 11:38:47 -0700 (PDT)
Message-ID: <36c2aca6-179f-4068-adfe-fc6c18ac7baf_at_r3g2000vbp.googlegroups.com>
All,
We can get this by analyzing the tables in a schema and looking at the column avg_row_len.
But, is there a sql so that I can calculate manually. In out environment, we gather statistics once and use them all the time.
Thanks,
Naga
Received on Tue Jun 09 2009 - 13:38:47 CDT