BLOB Statistics Sample Report
Created by BLOB Statistics 1.0.Monday, October 24, 2005 02:41:19

Contents

Database Information
Report contains the basic information about Database

Data Source Namedata_db
Database Name 
Server Namedata_db
DBMS NameOracle8
DBMS Version08.01.7000
User NameKS
Top of Page



Database Summary Report
The summary report contains summary information about BLOBs for the entire database.
The report allows you to get summary information about BLOBs for the database.

Number of tables with BLOBs1
Total number of items processed67307
Total number of BLOB items67307
Total number of NULL BLOB items0
Fill factor100.00 %
Total size of all BLOBs4.20 GB
Minimum BLOB size1 Bytes
Maximum BLOB size30.58 MB
Average BLOB size65.41 KB
Total number of recognized formats18
Top of Page



Table Summary Report
The table summary report contains summary information for each table.
The report allows you to get summary information about BLOB tables in the database.

  number of blobs   size of blobs number of formats
table name total total of db total null total null of db fill factor total total of db total total of db
KS.DATAINFO 67307 100.00 % 0 0.00 % 100.00 % 4.20 GB 100.00 % 18 100.00 %
summary: 67307 100.00 % 0 - 100.00 % 4.20 GB 100.00 % 18 100.00 %
Top of Page



Format Summary Report
The summary report about all recognized formats.
The report allows you to find out what formats are used together with their properties.

  number of blobs size of blobs size
format name total total of db total of recognized total total of db total of recognized min max avg
Compressed Archive File(.ZIP) 548 0.81 % 2.87 % 265.52 MB 6.18 % 7.83 % 711 Bytes 15.09 MB 496.16 KB
WinRAR Compressed Archive (.RAR) 126 0.19 % 0.66 % 82.47 MB 1.92 % 2.43 % 4.28 KB 8.64 MB 670.27 KB
Windows Bitmap Graphics (.BMP) 138 0.21 % 0.72 % 22.02 MB 0.51 % 0.65 % 1.74 KB 1.16 MB 163.41 KB
Graphic Interchange Format (.GIF) 3183 4.73 % 16.67 % 107.97 MB 2.51 % 3.18 % 319 Bytes 1.08 MB 34.73 KB
JPEG/JIFF Image (.JPG) 8182 12.16 % 42.86 % 726.14 MB 16.89 % 21.40 % 788 Bytes 3.92 MB 90.88 KB
Kodak Photo-Enhancer/Photogen File (.KDC) 11 0.02 % 0.06 % 259.81 KB 0.01 % 0.01 % 2.88 KB 85.86 KB 23.62 KB
PC Paintbrush Bitmap Graphic (.PCX) 970 1.44 % 5.08 % 55.96 MB 1.30 % 1.65 % 655 Bytes 1.06 MB 59.07 KB
Photoshop Format (.PSD) 25 0.04 % 0.13 % 1.24 MB 0.03 % 0.04 % 7.74 KB 182.70 KB 50.63 KB
Tagged Image Format File (.TIFF) 1471 2.19 % 7.70 % 139.51 MB 3.24 % 4.11 % 1.91 KB 1.28 MB 97.12 KB
Illustrator Vector Graphic (.AI) 56 0.08 % 0.29 % 8.19 MB 0.19 % 0.24 % 4.61 KB 1.20 MB 149.73 KB
MPEG Audio Stream, Layer III (.MP3) 2 0.00 % 0.01 % 7.33 MB 0.17 % 0.22 % 3.66 MB 3.66 MB 3.66 MB
Rich Text Format File (.RTF) 3085 4.58 % 16.16 % 1.48 GB 35.17 % 44.57 % 2.23 KB 30.58 MB 501.95 KB
Acrobat Portable Document Format (.PDF) 967 1.44 % 5.06 % 440.58 MB 10.25 % 12.99 % 4.74 KB 11.65 MB 466.55 KB
PostScript (.PS) 6 0.01 % 0.03 % 238.47 KB 0.01 % 0.01 % 7.42 KB 103.51 KB 39.74 KB
TeX (.tex) 1 0.00 % 0.01 % 7.13 KB 0.00 % 0.00 % 7.13 KB 7.13 KB 7.13 KB
LaTeX Source Document (.latex) 117 0.17 % 0.61 % 1.37 MB 0.03 % 0.04 % 8 Bytes 62.10 KB 11.98 KB
HTML Document (.HTML) 134 0.20 % 0.70 % 1.51 MB 0.04 % 0.04 % 310 Bytes 168.73 KB 11.56 KB
Executable File (.EXE,.DLL) 1 0.00 % 0.01 % 672.00 KB 0.02 % 0.02 % 672.00 KB 672.00 KB 672.00 KB
Unrecognized data 48215 71.63 % - 906.46 MB 21.08 % - 1 Bytes 7.59 MB 19.25 KB
summary: 67307 100.00 % 100.00 % 4.20 GB 100.00 % 100.00 % 1 Bytes 30.58 MB 65.41 KB
Top of Page



Formats by Tables Report
This report allows you to find out which formats are used in each particular table.

  number of blobs size of blobs size
format name total total of table total total of table min max avg
KS.DATAINFO
Compressed Archive File(.ZIP) 548 0.81 % 265.52 MB 6.18 % 711 Bytes 15.09 MB 496.16 KB
WinRAR Compressed Archive (.RAR) 126 0.19 % 82.47 MB 1.92 % 4.28 KB 8.64 MB 670.27 KB
Windows Bitmap Graphics (.BMP) 138 0.21 % 22.02 MB 0.51 % 1.74 KB 1.16 MB 163.41 KB
Graphic Interchange Format (.GIF) 3183 4.73 % 107.97 MB 2.51 % 319 Bytes 1.08 MB 34.73 KB
JPEG/JIFF Image (.JPG) 8182 12.16 % 726.14 MB 16.89 % 788 Bytes 3.92 MB 90.88 KB
Kodak Photo-Enhancer/Photogen File (.KDC) 11 0.02 % 259.81 KB 0.01 % 2.88 KB 85.86 KB 23.62 KB
PC Paintbrush Bitmap Graphic (.PCX) 970 1.44 % 55.96 MB 1.30 % 655 Bytes 1.06 MB 59.07 KB
Photoshop Format (.PSD) 25 0.04 % 1.24 MB 0.03 % 7.74 KB 182.70 KB 50.63 KB
Tagged Image Format File (.TIFF) 1471 2.19 % 139.51 MB 3.24 % 1.91 KB 1.28 MB 97.12 KB
Illustrator Vector Graphic (.AI) 56 0.08 % 8.19 MB 0.19 % 4.61 KB 1.20 MB 149.73 KB
MPEG Audio Stream, Layer III (.MP3) 2 0.00 % 7.33 MB 0.17 % 3.66 MB 3.66 MB 3.66 MB
Rich Text Format File (.RTF) 3085 4.58 % 1.48 GB 35.17 % 2.23 KB 30.58 MB 501.95 KB
Acrobat Portable Document Format (.PDF) 967 1.44 % 440.58 MB 10.25 % 4.74 KB 11.65 MB 466.55 KB
PostScript (.PS) 6 0.01 % 238.47 KB 0.01 % 7.42 KB 103.51 KB 39.74 KB
TeX (.tex) 1 0.00 % 7.13 KB 0.00 % 7.13 KB 7.13 KB 7.13 KB
LaTeX Source Document (.latex) 117 0.17 % 1.37 MB 0.03 % 8 Bytes 62.10 KB 11.98 KB
HTML Document (.HTML) 134 0.20 % 1.51 MB 0.04 % 310 Bytes 168.73 KB 11.56 KB
Executable File (.EXE,.DLL) 1 0.00 % 672.00 KB 0.02 % 672.00 KB 672.00 KB 672.00 KB
summary: 19092 28.37 % 3.31 GB 78.92 % 8 Bytes 30.58 MB 181.97 KB
Top of Page



Tables by Formats Report
The report allows you to find out in which tables each particular format is used.

table name number of blobs size of blobs min size max size avg size
Compressed Archive File(.ZIP)
KS.DATAINFO 548 265.52 MB 711 Bytes 15.09 MB 496.16 KB
WinRAR Compressed Archive (.RAR)
KS.DATAINFO 126 82.47 MB 4.28 KB 8.64 MB 670.27 KB
Windows Bitmap Graphics (.BMP)
KS.DATAINFO 138 22.02 MB 1.74 KB 1.16 MB 163.41 KB
Graphic Interchange Format (.GIF)
KS.DATAINFO 3183 107.97 MB 319 Bytes 1.08 MB 34.73 KB
JPEG/JIFF Image (.JPG)
KS.DATAINFO 8182 726.14 MB 788 Bytes 3.92 MB 90.88 KB
Kodak Photo-Enhancer/Photogen File (.KDC)
KS.DATAINFO 11 259.81 KB 2.88 KB 85.86 KB 23.62 KB
PC Paintbrush Bitmap Graphic (.PCX)
KS.DATAINFO 970 55.96 MB 655 Bytes 1.06 MB 59.07 KB
Photoshop Format (.PSD)
KS.DATAINFO 25 1.24 MB 7.74 KB 182.70 KB 50.63 KB
Tagged Image Format File (.TIFF)
KS.DATAINFO 1471 139.51 MB 1.91 KB 1.28 MB 97.12 KB
Illustrator Vector Graphic (.AI)
KS.DATAINFO 56 8.19 MB 4.61 KB 1.20 MB 149.73 KB
MPEG Audio Stream, Layer III (.MP3)
KS.DATAINFO 2 7.33 MB 3.66 MB 3.66 MB 3.66 MB
Rich Text Format File (.RTF)
KS.DATAINFO 3085 1.48 GB 2.23 KB 30.58 MB 501.95 KB
Acrobat Portable Document Format (.PDF)
KS.DATAINFO 967 440.58 MB 4.74 KB 11.65 MB 466.55 KB
PostScript (.PS)
KS.DATAINFO 6 238.47 KB 7.42 KB 103.51 KB 39.74 KB
TeX (.tex)
KS.DATAINFO 1 7.13 KB 7.13 KB 7.13 KB 7.13 KB
LaTeX Source Document (.latex)
KS.DATAINFO 117 1.37 MB 8 Bytes 62.10 KB 11.98 KB
HTML Document (.HTML)
KS.DATAINFO 134 1.51 MB 310 Bytes 168.73 KB 11.56 KB
Executable File (.EXE,.DLL)
KS.DATAINFO 1 672.00 KB 672.00 KB 672.00 KB 672.00 KB
Top of Page



Database: Recognized/Unrecognized Data
The report allows you to compare the properties of recognized and unrecognized data for the entire database.

  number of items size of items size
  total total of db total total of db min max avg
Recognized data 19092 28.37 % 3.31 GB 78.92 % 8 Bytes 30.58 MB 181.97 KB
Unrecognized data 48215 71.63 % 906.46 MB 21.08 % 1 Bytes 7.59 MB 19.25 KB
summary: 67307 100.00 % 4.20 GB 100.00 % 1 Bytes 30.58 MB 65.41 KB
Top of Page



Tables: Recognized/Unrecognized Data
The report allows you to compare the properties of recognized and unrecognized data for each table.

  number of items size of items size
table name total total of table total of db total total of table total of db min max avg
KS.DATAINFO
Recognized data 19092 28.37 % 28.37 % 3.31 GB 78.92 % 78.92 % 8 Bytes 30.58 MB 181.97 KB
Unrecognized data 48215 71.63 % 71.63 % 906.46 MB 21.08 % 21.08 % 1 Bytes 7.59 MB 19.25 KB
summary: 67307 100.00 % 100.00 % 4.20 GB 100.00 % 100.00 % 1 Bytes 30.58 MB 65.41 KB
Top of Page