隨筆 - 79  文章 - 11  trackbacks - 0
          <2009年4月>
          2930311234
          567891011
          12131415161718
          19202122232425
          262728293012
          3456789

          不再墮落。
          Oracle documents: 
          http://tahiti.oracle.com/

          常用鏈接

          留言簿

          隨筆分類(66)

          隨筆檔案(79)

          相冊

          收藏夾(11)

          搜索

          •  

          積分與排名

          • 積分 - 53481
          • 排名 - 949

          最新隨筆

          最新評論

          閱讀排行榜

          Calculating the average row length for rows in a table is done when you analyze the table (using dbms_stats, or automatically in Oracle 10g), but there are times when you need an ad-hoc way to calculate the average row length within an Oracle table, especially when doing capacity planning.

          using dbms_lob.getlength(BLOB_COLUMN) to get an accurate average_row_length for rows with a BLOB column..

          select
          3 + avg(nvl(dbms_lob.getlength(CASE_DATA),0)+1 +
                         nvl(vsize(CASE_NUMBER   ),
          0)+1 +
                         nvl(vsize(CASE_DATA_NAME),
          0)+1 +
                         nvl(vsize(LASTMOD_TIME_T),
          0)+1
                        ) "Total bytes per row"
          from 
             arch_case_data
          where 
             case_number 
          = 301;
          注:“3”:Row Header。 
                 ad hoc query 即席查詢、突發查詢
                 ad hoc 即興、隨時出現.

          Row header

          For non cluster tables, the row header is 3 bytes. Each stored row has one row header. One byte is used to store flags, one byte to indicate if the row is locked (for example because it's updated but not commited), and one byte for the column count.

          ref: http://www.dba-oracle.com/t_average_row_length.htm
                http://www.adp-gmbh.ch/ora/concepts/db_block.html
          posted on 2009-04-24 11:39 donnie 閱讀(293) 評論(0)  編輯  收藏 所屬分類: database
          主站蜘蛛池模板: 上栗县| 徐水县| 富顺县| 湖南省| 曲松县| 越西县| 周口市| 青田县| 顺平县| 文昌市| 社会| 金堂县| 方城县| 疏勒县| 莱芜市| 云林县| 宝清县| 保靖县| 贡山| 潞城市| 南昌县| 宜昌市| 民丰县| 延边| 稷山县| 平陆县| 永清县| 绍兴县| 静安区| 金门县| 盐山县| 洛南县| 德庆县| 无为县| 友谊县| 平利县| 绥宁县| 新巴尔虎右旗| 遂宁市| 当涂县| 墨江|