International Informix Users Group

	Informix News

18 Nov 13 - ZDNet - Top 20 mobile skills in demand... Read 09 Sep 13 - telecompaper - Shaspa and Tatung have shown a new smart home platform at Ifa in Berlin. Powered by the IBM Informix software... Read 06 Sep 13 - IBM data magazine - Mission Accomplished - Miami, Florida will be the backdrop for the 2014 IIUG Informix Conference... Read 01 Feb 13 - IBM Data Magazine - Are your database backups safe? Lester Knutsen (IBM Champion) writes about database back up safety using "archecker"... Read 14 Nov 12 - IBM - IBM's Big Data For Smart Grid Goes Live In Texas... Read 3 Oct 12 - The Financial - IBM and TransWorks Collaborate to Help Louisiana-Pacific Corporation Achieve Supply Chain Efficiency... Read 28 Aug 12 - techCLOUD9 - Splunk kicks up a SaaS Storm... Read 10 Aug 12 - businessCLOUD9 - Is this the other half of Cloud monitoring?... Read 3 Aug 12 - IBM data management - Supercharging the data warehouse while keeping costs down IBM Informix Warehouse Accelerator (IWA) delivers superior performance for in-memory analytics processing... Read 2 Aug 12 - channelbiz - Oninit Group launches Pay Per Pulse cloud-based service... Read 28 May 12 - Bloor - David Norfolk on the recent Informix benchmark "pretty impressive results"... Read 23 May 12 - DBTA - Informix Genero: A Way to Modernize Informix 4GL Applications... Read 9 Apr 12 - Mastering Data Management - Upping the Informix Ante: Advanced Data Tools... Read 22 Mar 12 - developerWorks - Optimizing Informix database access... Read 14 Mar 12 - BernieSpang.com - International Informix User Group set to meet in San Diego... Read 1 Mar 12 - IBM Data Management - IIUG Heads West for 2012 - Get ready for sun and sand in San Diego... Read 1 Mar 12 - IBM Data Management - Running Informix on Solid-State Drives.Speed Up Database Access... Read 26 Feb 12 - BernieSpan.com - Better results, lower cost for a broad set of new IBM clients and partners... Read 24 Feb 12 - developerWorks - Informix Warehouse Accelerator: Continuous Acceleration during Data Refresh... Read 6 Feb 12 - PRLOG - Informix port delivers unlimited database scalability for popular SaaS application ... Read 2 Feb 12 - developerWorks - Loading data with the IBM Informix TimeSeries Plug-in for Data Studio... Read 1 Feb 12 - developerWorks - 100 Tech Tips, #47: Log-in to Fix Central... Read 13 Jan 12 - MC Press online - Informix Dynamic Server Entices New Users with Free Production Edition ... Read 11 Jan 12 - Computerworld - Ecologic Analytics and Landis+Gyr -- Suitors Decide to Tie the Knot... Read 9 Jan 12 - planetIDS.com - DNS impact on Informix / Impacto do DNS no Informix... Read 8 Sep 11 - TMCnet.com - IBM Offers Database Solution to Enable Smart Meter Data Capture... Read 1 Aug 11 - IBM Data Management Magazine - IIUG user view: Happy 10th anniversary to IBM and Informix... Read 8 Jul 11 - Database Trends and Applications - Managing Time Series Data with Informix... Read 31 May 11 - Smart Grid - The meter data management pitfall utilities are overlooking... Read 27 May 11 - IBM Data Management Magazine - IIUG user view: Big data, big time ( Series data, warehouse acceleration, and 4GLs )... Read 16 May 11 - Business Wire - HiT Software Announces DBMoto for Enterprise Integration, Adds Informix. Log-based Change Data Capture... Read 21 Mar 11 - Yahoo! Finance - IBM and Cable&Wireless Worldwide Announce UK Smart Energy Cloud... Read 14 Mar 11 - MarketWatch - Fuzzy Logix and IBM Unveil In-Database Analytics for IBM Informix... Read 11 Mar 11 - InvestorPlace - It's Time to Give IBM Props: How many tech stocks are up 53% since the dot-com boom?... Read 9 Mar 11 - DBTA - Database Administration and the Goal of Diminishing Downtime... Read 2 Feb 11 - DBTAs - Informix 11.7 Flexible Grid Provides a Different Way of Looking at Database Servers... Read 27 Jan 11 - exactsolutions - Exact to Add Informix Support to Database Replay, SQL Monitoring Solutions... Read 25 Jan 11 - PR Newswire - Bank of China in the UK Works With IBM to Become a Smarter, Greener Bank... Read 12 Oct 10 - Database Trends and Applications - Informix 11.7: The Beginning of the Next Decade of IBM Informix... Read 20 Sep 10 - planetIDS.com - ITG analyst paper: Cost/Benefit case for IBM Informix as compared to Microsoft SQL Server... Read 20 Jul 10 - IBM Announcements - IBM Informix Choice Edition V11.50 helps deploy low-cost scalable and reliable solutions for Apple Macintosh and Microsoft Windows... Read 20 Jul 10 - IBM Announcements - Software withdrawal: Elite Support for Informix Ultimate-C Edition... Read 24 May 10 - eWeek Europe - IBM Supplies Database Tech For EU Smart Grid... Read 23 May 10 - SiliconIndia - IBM's smart metering system allows wise use of energy... Read 21 May 10 - CNET - IBM to help people monitor energy use... Read 20 May 10 - ebiz - IBM Teams With Hildebrand To Bring Smart Metering To Homes Across Britain... Read 19 May 10 - The New Blog Times - Misurare il consumo energetico: DEHEMS è pronto... Read 19 May 10 - ZDNet - IBM software in your home? Pact enables five-city smart meter pilot in Europe... Read 17 March 10 - ZDNet (blog) David Morgenstern - TCO: New research finds Macs in the enterprise easier, cheaper to manage than... Read 17 March 2010 - Virtualization Review - ...key components of Big Blue's platform to the commercial cloud such as its WebSphere suite of application ser vers and its DB2 and Informix databases... Read 10 February 2010 - The Wall Street Journal - International Business Machines is expanding an initiative to win over students and professors on its products. How do they lure the college crowd?... Read Previous news items

End of Support Dates

IDS 11.10 - 30 Sep 2012 Subscribe to notifications

Home Member Area Forums About IIUG Help

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

IDS Forum

usage space question 2

Posted By: CHUAN LU
Date: Wednesday, 22 February 2017, at 4:42 a.m.

1, I defined below table .
{ TABLE "cbs".aghmx row size = 1129 number of columns = 45 index size = 140 }
create table "cbs".aghmx
(
zhangh char(20) not null ,
jioyrq char(8) not null ,
zhujrq char(8),
jioysj integer
default 0,
jiaoym char(4) not null ,
pngzhh char(13),
jiedbz char(1) not null ,
jio1je decimal(13,2)
default 0,
zhhuye decimal(15,2)
default 0,
yueexz char(1) not null ,
yueefx char(1) not null ,
yngyjg char(4) not null ,
zhngjg char(4) not null ,
zhyyjg char(4) not null ,
zhkjjg char(4) not null ,
jio1gy char(8) not null ,
shoqgy char(8),
guiyls char(12) not null ,
yngyls char(12),
xnzhbz char(1) not null ,
zhyodm char(22),
cpznxh integer
default 0,
kehuzh char(20),
khzhlx char(1),
shunxh char(4),
chbubz char(1) not null ,
czzpbz char(1),
daynbz char(1),
xuhao1 integer
default 0,
shjnch integer
default 0,
jiluzt char(1)
default '0',
rzzhbz char(1),
dfhmnv char(200),
dfzhhv char(40),
dfgbdv char(3),
guifhv char(12),
dfhumv char(200),
dfzjhv char(40),
dfzzlv char(4),
dfbzxv char(128),
byxx01 char(60),
byxx02 char(60),
byxx03 char(60),
byxx04 char(60),
byxx05 char(60)
) with rowids
fragment by expression
(zhyyjg < '3109' ) in datacbs02,
((zhyyjg >= '3109' ) AND (zhyyjg < '7109' ) ) in datacbs03,
((zhyyjg >= '7109' ) AND (zhyyjg < '7702' ) ) in datacbs04,
((zhyyjg >= '7702' ) AND (zhyyjg < '8206' ) ) in datacbs05,
((zhyyjg >= '8206' ) AND (zhyyjg < '8908' ) ) in datacbs06,
((zhyyjg >= '8908' ) AND (zhyyjg < '9301' ) ) in datacbs07,
((zhyyjg >= '9301' ) AND (zhyyjg < '9413' ) ) in datacbs08,
((zhyyjg >= '9413' ) AND (zhyyjg < '9709' ) ) in datacbs09,
((zhyyjg >= '9709' ) AND (zhyyjg < '9821' ) ) in datacbs10,
((zhyyjg >= '9821' ) AND (zhyyjg < '9855' ) ) in datacbs11,
(zhyyjg >= '9855' ) in datacbs12
extent size 500000 next size 200000 lock mode row;
revoke all on "cbs".aghmx from "public" as "cbs";
create unique index "cbs".aghmx_idx1 on "cbs".aghmx (jioyrq,guiyls,
cpznxh) using btree in idxdbs05;
create index "cbs".aghmx_idx2 on "cbs".aghmx (khzhlx,kehuzh,shunxh,
jioyrq,jioysj) using btree in idxdbs07;
create index "cbs".aghmx_idx3 on "cbs".aghmx (zhangh,jioyrq,jiluzt)
using btree in idxdbs09;
create index "cbs".aghmx_idx4 on "cbs".aghmx (zhyyjg,jioyrq,daynbz,
jiluzt) using btree in idxdbs10;
2. row count information
> select count(*) from aghmx
> ;
(count(*))
917336051
3. the output of oncheck -pt :
$ oncheck -pt cbs:cbs.aghmx
TBLspace Report for cbs:cbs.aghmx
Table fragment partition datacbs02 in DBspace datacbs02
Physical Address 49:752688
Creation date 05/26/2011 13:20:37
TBLspace Flags 800802 Row Locking
TBLspace use 4 bit bit-maps
Maximum row size 1129
Number of special columns 0
Number of keys 0
Number of extents 17
Current serial value 942370755
Current SERIAL8 value 1
Current BIGSERIAL value 1
Current REFID value 1
Pagesize (k) 8
First extent size 62500
Next extent size 100000
Number of pages allocated 687500
Number of pages used 668151
Number of data pages 668068
Number of rows 25411154
Partition partnum 18874438
Partition lockid 18874438
Extents
Logical Page Physical Page Size Physical Pages
0 49:158458 62500 125000
62500 81:987002 25000 50000
87500 81:1443000 25000 50000
112500 49:2503260 25000 50000
137500 49:1989032 25000 50000
162500 81:362774 25000 50000
187500 49:6905256 25000 50000
212500 49:8144278 25000 50000
237500 83:362688 25000 50000
262500 81:7471728 25000 50000
287500 81:3692552 50000 100000
337500 82:6964146 50000 100000
387500 193:912002 50000 100000
437500 194:5023998 50000 100000
487500 193:7833660 50000 100000
537500 81:6565730 50000 100000
587500 194:5623998 100000 200000
Table fragment partition datacbs03 in DBspace datacbs03
Physical Address 50:685740
Creation date 05/26/2011 13:20:37
TBLspace Flags 800802 Row Locking
TBLspace use 4 bit bit-maps
Maximum row size 1129
Number of special columns 0
Number of keys 0
Number of extents 31
Current serial value 1
Current SERIAL8 value 1
Current BIGSERIAL value 1
Current REFID value 1
Pagesize (k) 8
First extent size 62500
Next extent size 400000
Number of pages allocated 3587500
Number of pages used 3403091
Number of data pages 3402672
Number of rows 128321583
Partition partnum 19923110
Partition lockid 18874438
Extents
Logical Page Physical Page Size Physical Pages
0 50:158458 62500 125000
62500 50:5914878 25000 50000
87500 50:6653310 25000 50000
112500 50:7138542 25000 50000
137500 50:7717374 25000 50000
162500 50:7880206 25000 50000
187500 50:8039838 25000 50000
212500 50:8226070 25000 50000
237500 84:250006 25000 50000
262500 84:579806 25000 50000
287500 84:822438 50000 100000
337500 84:1407702 50000 100000
387500 84:1876966 50000 100000
437500 84:2405830 50000 100000
487500 84:2837894 50000 100000
537500 84:3263558 50000 100000
587500 84:3686022 100000 200000
687500 84:4221350 100000 200000
787500 86:1276186 100000 200000
887500 86:2493362 100000 200000
987500 86:3333362 100000 200000
1087500 86:4040522 100000 200000
1187500 86:6486790 200000 400000
1387500 196:6 200000 400000
1587500 196:2969246 200000 400000
1787500 197:1024006 200000 400000
1987500 197:3708006 200000 400000
2187500 198:1736006 200000 400000
2387500 198:7108934 400000 800000
2787500 336:2048006 400000 800000
3187500 336:6931078 400000 800000
Table fragment partition datacbs04 in DBspace datacbs04
Physical Address 51:611988
Creation date 05/26/2011 13:20:37
TBLspace Flags 800802 Row Locking
TBLspace use 4 bit bit-maps
Maximum row size 1129
Number of special columns 0
Number of keys 0
Number of extents 29
Current serial value 1
Current SERIAL8 value 1
Current BIGSERIAL value 1
Current REFID value 1
Pagesize (k) 8
First extent size 62500
Next extent size 400000
Number of pages allocated 2787500
Number of pages used 2434915
Number of data pages 2434615
Number of rows 88179959
Partition partnum 20971590
Partition lockid 18874438
Extents
Logical Page Physical Page Size Physical Pages
0 51:158458 62500 125000
62500 51:4415636 25000 50000
87500 51:4741598 25000 50000
112500 51:5217626 25000 50000
137500 51:5593522 25000 50000
162500 51:5913018 25000 50000
187500 51:6285714 25000 50000
212500 51:6711610 25000 50000
237500 51:7084306 25000 50000
262500 51:7670066 25000 50000
287500 51:7829698 50000 100000
337500 87:200006 50000 100000
387500 87:600006 50000 100000
437500 87:812870 50000 100000
487500 87:1291998 50000 100000
537500 87:1558062 50000 100000
587500 87:1874126 100000 200000
687500 87:2249854 100000 200000
787500 88:3735016 100000 200000
887500 88:1852388 100000 200000
987500 89:1550006 100000 200000
1087500 88:2421952 100000 200000
1187500 89:1100006 200000 400000
1387500 200:3000006 200000 400000
1587500 89:5587506 200000 400000
1787500 200:250006 200000 400000
1987500 200:7000006 200000 400000
2187500 200:1950006 200000 400000
2387500 203:2000006 400000 800000
Table fragment partition datacbs05 in DBspace datacbs05
Physical Address 52:855574
Creation date 05/26/2011 13:20:37
TBLspace Flags 800802 Row Locking
TBLspace use 4 bit bit-maps
Maximum row size 1129
Number of special columns 0
Number of keys 0
Number of extents 30
Current serial value 1
Current SERIAL8 value 1
Current BIGSERIAL value 1
Current REFID value 1
Pagesize (k) 8
First extent size 62500
Next extent size 400000
Number of pages allocated 3187500
Number of pages used 2799605
Number of data pages 2799260
Number of rows 105440361
Partition partnum 22020166
Partition lockid 18874438
Extents
Logical Page Physical Page Size Physical Pages
0 52:158458 62500 125000
62500 52:5486914 25000 50000
87500 52:5811030 25000 50000
112500 52:6103662 25000 50000
137500 52:6848494 25000 50000
162500 52:6954926 25000 50000
187500 52:7380558 25000 50000
212500 52:7724790 25000 50000
237500 52:7965822 25000 50000
262500 52:8072254 25000 50000
287500 90:125006 50000 100000
337500 90:561206 50000 100000
387500 90:1113470 50000 100000
437500 90:1542334 50000 100000
487500 90:1914798 50000 100000
537500 90:2287262 50000 100000
587500 90:2656526 100000 200000
687500 90:3185454 100000 200000
787500 92:1813752 100000 200000
887500 204:1146006 100000 200000
987500 204:3446006 100000 200000
1087500 205:1950006 100000 200000
1187500 205:6342006 200000 400000
1387500 206:2000006 200000 400000
1587500 204:6377078 200000 400000
1787500 205:4742006 200000 400000
1987500 206:800006 200000 400000
2187500 206:7668006 200000 400000
2387500 205:250006 400000 800000
2787500 207:5600006 400000 800000
Table fragment partition datacbs06 in DBspace datacbs06
Physical Address 53:1129598
Creation date 05/26/2011 13:20:37
TBLspace Flags 800802 Row Locking
TBLspace use 4 bit bit-maps
Maximum row size 1129
Number of special columns 0
Number of keys 0
Number of extents 26
Current serial value 1
Current SERIAL8 value 1
Current BIGSERIAL value 1
Current REFID value 1
Pagesize (k) 8
First extent size 62500
Next extent size 200000
Number of pages allocated 1987500
Number of pages used 1896666
Number of data pages 1896432
Number of rows 69294601
Partition partnum 23068774
Partition lockid 18874438
Extents
Logical Page Physical Page Size Physical Pages
0 53:158458 62500 125000
62500 53:3407956 25000 50000
87500 53:3622388 25000 50000
112500 53:4101388 25000 50000
137500 53:4234420 25000 50000
162500 53:4340852 25000 50000
187500 53:4738284 25000 50000
212500 53:5162284 25000 50000
237500 53:5312284 25000 50000
262500 53:5537284 25000 50000
287500 53:5590516 50000 100000
337500 53:6120980 50000 100000
387500 53:6493444 50000 100000
437500 53:6865908 50000 100000
487500 53:7235172 50000 100000
537500 53:7451236 50000 100000
587500 53:7717300 100000 200000
687500 53:7983428 100000 200000
787500 93:6191238 100000 200000
887500 95:600006 100000 200000
987500 95:4146306 100000 200000
1087500 95:6761306 100000 200000
1187500 208:1776006 200000 400000
1387500 209:6528006 200000 400000
1587500 210:1400006 200000 400000
1787500 342:2709062 200000 400000
Table fragment partition datacbs07 in DBspace datacbs07
Physical Address 54:792018
Creation date 05/26/2011 13:20:37
TBLspace Flags 800802 Row Locking
TBLspace use 4 bit bit-maps
Maximum row size 1129
Number of special columns 0
Number of keys 0
Number of extents 27
Current serial value 1
Current SERIAL8 value 1
Current BIGSERIAL value 1
Current REFID value 1
Pagesize (k) 8
First extent size 62500
Next extent size 400000
Number of pages allocated 2787500
Number of pages used 2574304
Number of data pages 2573987
Number of rows 87570123
Partition partnum 24117382
Partition lockid 18874438
Extents
Logical Page Physical Page Size Physical Pages
0 54:158458 62500 125000
62500 54:3335452 25000 50000
87500 54:3574884 25000 50000
112500 54:4053884 25000 50000
137500 54:4213516 25000 50000
162500 54:4479548 25000 50000
187500 54:4930180 25000 50000
212500 54:4983412 25000 50000
237500 54:5036644 25000 50000
262500 54:5435676 25000 50000
287500 54:5542108 50000 100000
337500 54:5781572 50000 100000
387500 54:6175836 50000 100000
437500 54:6337100 50000 100000
487500 54:6549964 50000 100000
537500 54:6759628 50000 100000
587500 54:6919292 100000 200000
687500 54:7241820 100000 200000
787500 97:5705642 100000 200000
887500 98:164006 100000 200000
987500 97:4035850 100000 200000
1087500 98:6305946 100000 200000
1187500 212:4542006 200000 400000
1387500 212:250006 200000 400000
1587500 213:6524006 200000 400000
1787500 214:4970006 200000 400000
1987500 215:4166006 800000 1600000
Table fragment partition datacbs08 in DBspace datacbs08
Physical Address 55:559886
Creation date 05/26/2011 13:20:37
TBLspace Flags 800802 Row Locking
TBLspace use 4 bit bit-maps
Maximum row size 1129
Number of special columns 0
Number of keys 0
Number of extents 25
Current serial value 1
Current SERIAL8 value 1
Current BIGSERIAL value 1
Current REFID value 1
Pagesize (k) 8
First extent size 62500
Next extent size 200000
Number of pages allocated 1787500
Number of pages used 1611425
Number of data pages 1611226
Number of rows 58858157
Partition partnum 25165894
Partition lockid 18874438
Extents
Logical Page Physical Page Size Physical Pages
0 55:158458 62500 125000
62500 55:2301684 25000 50000
87500 55:2354916 25000 50000
112500 55:2993348 25000 50000
137500 55:3525548 25000 50000
162500 55:3578780 25000 50000
187500 55:3632012 25000 50000
212500 55:3921444 25000 50000
237500 55:4616276 25000 50000
262500 55:5307908 25000 50000
287500 55:5467540 50000 100000
337500 55:6947604 50000 100000
387500 55:7486068 50000 100000
437500 55:8018132 50000 100000
487500 99:162806 50000 100000
537500 99:641670 50000 100000
587500 99:854534 100000 200000
687500 99:1067462 100000 200000
787500 100:2163806 100000 200000
887500 100:3277006 100000 200000
987500 100:5201006 100000 200000
1087500 216:6817606 100000 200000
1187500 216:6367606 200000 400000
1387500 218:7424006 200000 400000
1587500 441:3200006 200000 400000
Table fragment partition datacbs09 in DBspace datacbs09
Physical Address 56:600930
Creation date 05/26/2011 13:20:37
TBLspace Flags 800802 Row Locking
TBLspace use 4 bit bit-maps
Maximum row size 1129
Number of special columns 0
Number of keys 0
Number of extents 31
Current serial value 1
Current SERIAL8 value 1
Current BIGSERIAL value 1
Current REFID value 1
Pagesize (k) 8
First extent size 62500
Next extent size 400000
Number of pages allocated 3987500
Number of pages used 3786625
Number of data pages 3786159
Number of rows 138459289
Partition partnum 26214470
Partition lockid 18874438
Extents
Logical Page Physical Page Size Physical Pages
0 56:158458 62500 125000
62500 56:3110646 25000 50000
87500 56:3693074 25000 50000
112500 56:4598202 25000 50000
137500 56:5271918 25000 50000
162500 56:5717322 25000 50000
187500 56:6783586 25000 50000
212500 56:7375746 25000 50000
237500 56:8014706 25000 50000
262500 56:8174338 25000 50000
287500 102:500006 50000 100000
337500 102:1795598 50000 100000
387500 102:2770054 50000 100000
437500 102:4207574 50000 100000
487500 102:5212566 50000 100000
537500 102:6091430 50000 100000
587500 102:6517094 100000 200000
687500 102:7315222 100000 200000
787500 104:6376812 100000 200000
887500 104:6175890 100000 200000
987500 220:3650006 100000 200000
1087500 220:7513510 100000 200000
1187500 220:7063510 200000 400000
1387500 220:4450006 200000 400000
1587500 221:1800006 200000 400000
1787500 104:7113812 200000 400000
1987500 220:5887382 200000 400000
2187500 221:4100006 200000 400000
2387500 221:6060006 800000 1600000
3187500 222:4788422 400000 800000
3587500 348:3400006 400000 800000
Table fragment partition datacbs10 in DBspace datacbs10
Physical Address 57:975066
Creation date 05/26/2011 13:20:37
TBLspace Flags 800802 Row Locking
TBLspace use 4 bit bit-maps
Maximum row size 1129
Number of special columns 0
Number of keys 0
Number of extents 28
Current serial value 1
Current SERIAL8 value 1
Current BIGSERIAL value 1
Current REFID value 1
Pagesize (k) 8
First extent size 62500
Next extent size 400000
Number of pages allocated 3187500
Number of pages used 2889476
Number of data pages 2889119
Number of rows 107948110
Partition partnum 27263238
Partition lockid 18874438
Extents
Logical Page Physical Page Size Physical Pages
0 57:158458 62500 125000
62500 57:1710532 25000 50000
87500 57:1870296 25000 50000
112500 57:2030060 25000 50000
137500 57:2455992 25000 50000
162500 57:2612490 25000 50000
187500 57:2772254 25000 50000
212500 57:2932018 25000 50000
237500 57:3095048 25000 50000
262500 57:3254812 25000 50000
287500 57:3514576 50000 100000
337500 57:3940636 50000 100000
387500 57:4266696 50000 100000
437500 57:4586224 50000 100000
487500 57:4899220 50000 100000
537500 57:5225280 50000 100000
587500 57:5331744 100000 200000
687500 57:5544672 100000 200000
787500 57:4053632 100000 200000
887500 106:3890814 100000 200000
987500 106:3690814 100000 200000
1087500 226:2560006 100000 200000
1187500 224:2428814 200000 400000
1387500 225:819206 200000 400000
1587500 225:2265606 200000 400000
1787500 226:1640006 200000 400000
1987500 226:4867206 200000 400000
2187500 350:640006 1000000 2000000
Table fragment partition datacbs11 in DBspace datacbs11
Physical Address 58:636672
Creation date 05/26/2011 13:20:37
TBLspace Flags 800802 Row Locking
TBLspace use 4 bit bit-maps
Maximum row size 1129
Number of special columns 0
Number of keys 0
Number of extents 25
Current serial value 1
Current SERIAL8 value 1
Current BIGSERIAL value 1
Current REFID value 1
Pagesize (k) 8
First extent size 62500
Next extent size 200000
Number of pages allocated 1787500
Number of pages used 1698308
Number of data pages 1698099
Number of rows 58338419
Partition partnum 28311620
Partition lockid 18874438
Extents
Logical Page Physical Page Size Physical Pages
0 58:106878 62500 125000
62500 58:2733444 25000 50000
87500 58:2839876 25000 50000
112500 58:2999508 25000 50000
137500 58:3688108 25000 50000
162500 58:4426540 25000 50000
187500 58:4702172 25000 50000
212500 58:4861804 25000 50000
237500 58:5015036 25000 50000
262500 58:5068268 25000 50000
287500 58:5121500 50000 100000
337500 58:6079164 50000 100000
387500 58:6318628 50000 100000
437500 58:7409292 50000 100000
487500 58:8100956 50000 100000
537500 108:662806 50000 100000
587500 108:1354470 100000 200000
687500 108:2102598 100000 200000
787500 109:5703598 100000 200000
887500 110:1598254 100000 200000
987500 110:5843446 100000 200000
1087500 229:2639278 100000 200000
1187500 228:3788254 200000 400000
1387500 229:686262 200000 400000
1587500 230:4242246 200000 400000
Table fragment partition datacbs12 in DBspace datacbs12
Physical Address 59:775934
Creation date 05/26/2011 13:20:37
TBLspace Flags 800802 Row Locking
TBLspace use 4 bit bit-maps
Maximum row size 1129
Number of special columns 0
Number of keys 0
Number of extents 23
Current serial value 1
Current SERIAL8 value 1
Current BIGSERIAL value 1
Current REFID value 1
Pagesize (k) 8
First extent size 62500
Next extent size 200000
Number of pages allocated 1587500
Number of pages used 1394682
Number of data pages 1394510
Number of rows 49514295
Partition partnum 29360196
Partition lockid 18874438
Extents
Logical Page Physical Page Size Physical Pages
0 59:106878 62500 125000
62500 59:3342538 25000 50000
87500 59:3528770 25000 50000
112500 59:4007770 25000 50000
137500 59:4220602 25000 50000
162500 59:4433434 25000 50000
187500 59:4593066 25000 50000
212500 59:4752698 25000 50000
237500 59:4912330 25000 50000
262500 59:4965562 25000 50000
287500 59:5231594 50000 100000
337500 59:5657258 50000 100000
387500 59:6220596 50000 100000
437500 59:6420596 50000 100000
487500 59:6936596 50000 100000
537500 59:7804794 50000 100000
587500 111:6 100000 200000
687500 112:6347120 100000 200000
787500 113:7915268 100000 200000
887500 233:6949944 100000 200000
987500 112:7027120 100000 200000
1087500 112:4500370 100000 200000
1187500 234:1840006 400000 800000
Index aghmx_idx1 fragment partition idxdbs05 in DBspace idxdbs05
Physical Address 172:10
Creation date 05/26/2011 16:58:07
TBLspace Flags 802 Row Locking
TBLspace use 4 bit bit-maps
Maximum row size 201
Number of special columns 0
Number of keys 1
Number of extents 11
Current serial value 1
Current SERIAL8 value 1
Current BIGSERIAL value 1
Current REFID value 1
Pagesize (k) 8
First extent size 10261
Next extent size 1050624
Number of pages allocated 7352317
Number of pages used 6506157
Number of data pages 0
Number of rows 0
Partition partnum 53477378
Partition lockid 18874438
Extents
Logical Page Physical Page Size Physical Pages
0 172:106 1573885 3147770
1573885 182:1061126 262656 525312
1836541 172:7581542 262656 525312
2099197 182:6 262656 525312
2361853 182:7253006 525312 1050624
2887165 304:6 787968 1575936
3675133 182:3732964 525312 1050624
4200445 304:1575942 1050624 2101248
5251069 304:6693494 525312 1050624
5776381 310:2534366 525312 1050624
6301693 310:4505190 1050624 2101248
Index aghmx_idx2 fragment partition idxdbs07 in DBspace idxdbs07
Physical Address 174:10
Creation date 09/25/2016 03:12:57
TBLspace Flags 802 Row Locking
TBLspace use 4 bit bit-maps
Maximum row size 201
Number of special columns 0
Number of keys 1
Number of extents 11
Current serial value 1
Current SERIAL8 value 1
Current BIGSERIAL value 1
Current REFID value 1
Pagesize (k) 8
First extent size 11442
Next extent size 585856
Number of pages allocated 4395263
Number of pages used 3957675
Number of data pages 0
Number of rows 0
Partition partnum 55574530
Partition lockid 18874438
Extents
Logical Page Physical Page Size Physical Pages
0 174:106 1315887 2631774
1315887 174:3047582 146464 292928
1462351 174:7725128 146464 292928
1608815 184:1468966 146632 293264
1755447 184:1802546 293020 586040
2048467 184:4194896 292928 585856
2341395 312:116646 292928 585856
2634323 312:4602078 292928 585856
2927251 312:9473518 296300 592600
3223551 312:13218054 585856 1171712
3809407 313:233286 585856 1171712
Index aghmx_idx3 fragment partition idxdbs09 in DBspace idxdbs09
Physical Address 176:10
Creation date 05/26/2011 17:18:41
TBLspace Flags 802 Row Locking
TBLspace use 4 bit bit-maps
Maximum row size 201
Number of special columns 0
Number of keys 1
Number of extents 10
Current serial value 1
Current SERIAL8 value 1
Current BIGSERIAL value 1
Current REFID value 1
Pagesize (k) 8
First extent size 9452
Next extent size 483968
Number of pages allocated 3385885
Number of pages used 2902572
Number of data pages 0
Number of rows 0
Partition partnum 57671682
Partition lockid 18874438
Extents
Logical Page Physical Page Size Physical Pages
0 176:106 1087037 2174074
1087037 176:5758036 120992 241984
1208029 176:6679820 120992 241984
1329021 176:7397396 120992 241984
1450013 186:2037030 241984 483968
1691997 316:1680966 241984 483968
1933981 316:8186830 241984 483968
2175965 316:11378718 241984 483968
2417949 317:22070 241984 483968
2659933 317:1347318 725952 1451904
Index aghmx_idx4 fragment partition idxdbs10 in DBspace idxdbs10
Physical Address 177:10
Creation date 05/26/2011 17:24:16
TBLspace Flags 802 Row Locking
TBLspace use 4 bit bit-maps
Maximum row size 201
Number of special columns 0
Number of keys 1
Number of extents 10
Current serial value 1
Current SERIAL8 value 1
Current BIGSERIAL value 1
Current REFID value 1
Pagesize (k) 8
First extent size 5721
Next extent size 292864
Number of pages allocated 1620341
Number of pages used 1528310
Number of data pages 0
Number of rows 0
Partition partnum 58720258
Partition lockid 18874438
Extents
Logical Page Physical Page Size Physical Pages
0 177:106 584585 1169170
584585 177:7795296 73216 146432
657801 187:681670 73216 146432
731017 187:2699192 73216 146432
804233 187:6357754 73216 146432
877449 187:7099134 146432 292864
1023881 318:779526 146432 292864
1170313 318:14867136 146432 292864
1316745 319:4094310 157164 314328
1473909 319:5864406 146432 292864
Index system-rowid fragment partition datacbs02 in DBspace datacbs02
Physical Address 49:752690
Creation date 05/26/2011 13:20:37
TBLspace Flags 802 Row Locking
TBLspace use 4 bit bit-maps
Maximum row size 201
Number of special columns 0
Number of keys 1
Number of extents 17
Current serial value 1
Current SERIAL8 value 1
Current BIGSERIAL value 1
Current REFID value 1
Pagesize (k) 8
First extent size 4042
Next extent size 6464
Number of pages allocated 44552
Number of pages used 40739
Number of data pages 0
Number of rows 0
Partition partnum 18874439
Partition lockid 18874438
Extents
Logical Page Physical Page Size Physical Pages
0 49:283458 4042 8084
4042 49:1849524 1616 3232
5658 49:2143408 1616 3232
7274 49:1786266 1616 3232
8890 49:1707110 1616 3232
10506 49:1806080 1616 3232
12122 49:2081908 1616 3232
13738 49:2388576 1616 3232
15354 49:2814050 1616 3232
16970 49:2734482 1616 3232
18586 49:7055256 3232 6464
21818 49:7511674 3232 6464
25050 49:2721488 3232 6464
28282 49:6892224 3232 6464
31514 49:8319278 3232 6464
34746 81:512176 3342 6684
38088 81:1643000 6464 12928
Index system-rowid fragment partition datacbs03 in DBspace datacbs03
Physical Address 50:685742
Creation date 05/26/2011 13:20:37
TBLspace Flags 802 Row Locking
TBLspace use 4 bit bit-maps
Maximum row size 201
Number of special columns 0
Number of keys 1
Number of extents 29
Current serial value 1
Current SERIAL8 value 1
Current BIGSERIAL value 1
Current REFID value 1
Pagesize (k) 8
First extent size 4042
Next extent size 25856
Number of pages allocated 206042
Number of pages used 205533
Number of data pages 0
Number of rows 0
Partition partnum 19923111
Partition lockid 18874438
Extents
Logical Page Physical Page Size Physical Pages
0 50:283458 4042 8084
4042 50:5964878 1616 3232
5658 50:6916110 1616 3232
7274 50:7238542 1616 3232
8890 50:7770574 1616 3232
10506 50:7980206 1616 3232
12122 50:8189838 1616 3232
13738 50:8355870 1616 3232
15354 50:8376702 1616 3232
16970 84:659606 1616 3232
18586 84:1082038 3232 6464
21818 84:1660902 3232 6464
25050 84:2086566 3232 6464
28282 84:2565430 3232 6464
31514 84:2991094 3232 6464
34746 84:3469958 3232 6464
37978 84:3942422 6464 12928
44442 85:32006 6464 12928
50906 86:1687874 6464 12928
57370 85:2460282 6464 12928
63834 86:865328 6464 12928
70298 86:2973362 6464 12928
76762 86:882756 12928 25856
89690 196:751006 12928 25856
102618 196:4889838 25856 51712
128474 197:1777542 12928 25856
141402 198:3903078 12928 25856
154330 198:1099006 25856 51712
180186 198:7908934 25856 51712
Index system-rowid fragment partition datacbs04 in DBspace datacbs04
Physical Address 51:611990
Creation date 05/26/2011 13:20:37
TBLspace Flags 802 Row Locking
TBLspace use 4 bit bit-maps
Maximum row size 201
Number of special columns 0
Number of keys 1
Number of extents 27
Current serial value 1
Current SERIAL8 value 1
Current BIGSERIAL value 1
Current REFID value 1
Pagesize (k) 8
First extent size 4042
Next extent size 12928
Number of pages allocated 141402
Number of pages used 141148
Number of data pages 0
Number of rows 0
Partition partnum 20971591
Partition lockid 18874438
Extents
Logical Page Physical Page Size Physical Pages
0 51:283458 4042 8084
4042 51:4472102 1616 3232
5658 51:4891598 1616 3232
7274 51:5270826 1616 3232
8890 51:5743522 1616 3232
10506 51:6163018 1616 3232
12122 51:6588914 1616 3232
13738 51:6961610 1616 3232
15354 51:7334306 1616 3232
16970 51:7770066 1616 3232
18586 51:7929698 3232 6464
21818 51:8308826 3232 6464
25050 87:700006 3232 6464
28282 87:1179134 3232 6464
31514 87:1445198 3232 6464
34746 87:1761262 3232 6464
37978 87:2077326 6464 12928
44442 87:2503054 6464 12928
50906 88:6979516 6464 12928
57370 51:3236990 6464 12928
63834 51:5781048 6464 12928
70298 88:50006 6464 12928
76762 88:6813252 12928 25856
89690 88:4401280 12928 25856
102618 89:6487506 12928 25856
115546 200:6600006 12928 25856
128474 88:7042444 12928 25856
Index system-rowid fragment partition datacbs05 in DBspace datacbs05
Physical Address 52:855576
Creation date 05/26/2011 13:20:37
TBLspace Flags 802 Row Locking
TBLspace use 4 bit bit-maps
Maximum row size 201
Number of special columns 0
Number of keys 1
Number of extents 29
Current serial value 1
Current SERIAL8 value 1
Current BIGSERIAL value 1
Current REFID value 1
Pagesize (k) 8
First extent size 4042
Next extent size 25856
Number of pages allocated 180186
Number of pages used 168738
Number of data pages 0
Number of rows 0
Partition partnum 22020167
Partition lockid 18874438
Extents
Logical Page Physical Page Size Physical Pages
0 52:283458 4042 8084
4042 52:5544998 1616 3232
5658 52:5864230 1616 3232
7274 52:6313262 1616 3232
8890 52:6898494 1616 3232
10506 52:7004926 1616 3232
12122 52:7430558 1616 3232
13738 52:7856190 1616 3232
15354 52:8015822 1616 3232
16970 52:8175454 1616 3232
18586 52:8374486 3232 6464
21818 90:764406 3232 6464
25050 90:1269870 3232 6464
28282 90:1695534 3232 6464
31514 90:2067998 3232 6464
34746 90:2387262 3232 6464
37978 90:2962926 6464 12928
44442 90:6216890 6464 12928
50906 92:565542 6464 12928
57370 90:5578736 6464 12928
63834 52:3551688 6464 12928
70298 91:2846888 6464 12928
76762 91:2870056 12928 25856
89690 91:2150006 12928 25856
102618 91:2196910 12928 25856
115546 92:2663576 12928 25856
128474 92:6528398 12928 25856
141402 91:4834334 12928 25856
154330 91:6249492 25856 51712
Index system-rowid fragment partition datacbs06 in DBspace datacbs06
Physical Address 53:1129600
Creation date 05/26/2011 13:20:37
TBLspace Flags 802 Row Locking
TBLspace use 4 bit bit-maps
Maximum row size 201
Number of special columns 0
Number of keys 1
Number of extents 24
Current serial value 1
Current SERIAL8 value 1
Current BIGSERIAL value 1
Current REFID value 1
Pagesize (k) 8
First extent size 4042
Next extent size 12928
Number of pages allocated 115546
Number of pages used 110918
Number of data pages 0
Number of rows 0
Partition partnum 23068775
Partition lockid 18874438
Extents
Logical Page Physical Page Size Physical Pages
0 53:283458 4042 8084
4042 53:3565956 1616 3232
5658 53:3748988 1616 3232
7274 53:4151388 1616 3232
8890 53:4284420 1616 3232
10506 53:4497252 1616 3232
12122 53:4866484 1616 3232
13738 53:5142116 3232 6464
16970 53:5587284 1616 3232
18586 53:5875116 3232 6464
21818 53:6300780 3232 6464
25050 53:6620044 3232 6464
28282 53:7072308 3232 6464
31514 53:7338372 3232 6464
34746 53:7604436 3232 6464
37978 53:7970500 6464 12928
44442 93:5783646 6464 12928
50906 93:5983278 6464 12928
57370 94:7923588 6464 12928
63834 93:7904456 6464 12928
70298 95:5626210 6464 12928
76762 95:6726786 12928 25856
89690 208:4066256 12928 25856
102618 208:5820254 12928 25856
Index system-rowid fragment partition datacbs07 in DBspace datacbs07
Physical Address 54:792020
Creation date 05/26/2011 13:20:37
TBLspace Flags 802 Row Locking
TBLspace use 4 bit bit-maps
Maximum row size 201
Number of special columns 0
Number of keys 1
Number of extents 27
Current serial value 1
Current SERIAL8 value 1
Current BIGSERIAL value 1
Current REFID value 1
Pagesize (k) 8
First extent size 4042
Next extent size 25856
Number of pages allocated 148775
Number of pages used 140174
Number of data pages 0
Number of rows 0
Partition partnum 24117383
Partition lockid 18874438
Extents
Logical Page Physical Page Size Physical Pages
0 54:283458 4042 8084
4042 54:3465252 1616 3232
5658 54:3624884 1616 3232
7274 54:4103884 1616 3232
8890 54:4263516 1616 3232
10506 54:4609348 1616 3232
12122 54:4980180 1616 3232
13738 54:5033412 1616 3232
15354 54:5086644 1616 3232
16970 54:5538876 1616 3232
18586 54:5642108 3232 6464
21818 54:6041172 3232 6464
25050 54:6330636 3232 6464
28282 54:6437100 3232 6464
31514 54:6649964 3232 6464
34746 54:6862828 3232 6464
37978 54:7122492 6464 12928
44442 96:793890 6464 12928
50906 54:135890 6464 12928
57370 96:2526068 6464 12928
63834 97:2986038 6464 12928
70298 97:6142642 6464 12928
76762 54:3062952 12928 25856
89690 98:5899946 12928 25856
102618 212:2970006 12928 25856
115546 212:8348006 20301 40602
135847 98:5731946 12928 25856
Index system-rowid fragment partition datacbs08 in DBspace datacbs08
Physical Address 55:559888
Creation date 05/26/2011 13:20:37
TBLspace Flags 802 Row Locking
TBLspace use 4 bit bit-maps
Maximum row size 201
Number of special columns 0
Number of keys 1
Number of extents 24
Current serial value 1
Current SERIAL8 value 1
Current BIGSERIAL value 1
Current REFID value 1
Pagesize (k) 8
First extent size 4042
Next extent size 12928
Number of pages allocated 102618
Number of pages used 94210
Number of data pages 0
Number of rows 0
Partition partnum 25165895
Partition lockid 18874438
Extents
Logical Page Physical Page Size Physical Pages
0 55:283458 4042 8084
4042 55:2351684 1616 3232
5658 55:2458116 1616 3232
7274 55:3415916 1616 3232
8890 55:3575548 1616 3232
10506 55:3628780 1616 3232
12122 55:3682012 1616 3232
13738 55:4184244 1616 3232
15354 55:4985476 1616 3232
16970 55:5411108 1616 3232
18586 55:5805340 3232 6464
21818 55:7054004 3232 6464
25050 55:7692468 3232 6464
28282 55:8277732 3232 6464
31514 99:422406 3232 6464
34746 99:848070 3232 6464
37978 99:1054534 6464 12928
44442 99:3931450 6464 12928
50906 99:4069378 6464 12928
57370 99:3997674 6464 12928
63834 100:3642206 6464 12928
70298 101:4069206 6464 12928
76762 216:1450006 12928 25856
89690 101:6991606 12928 25856
Index system-rowid fragment partition datacbs09 in DBspace datacbs09
Physical Address 56:600932
Creation date 05/26/2011 13:20:37
TBLspace Flags 802 Row Locking
TBLspace use 4 bit bit-maps
Maximum row size 201
Number of special columns 0
Number of keys 1
Number of extents 31
Current serial value 1
Current SERIAL8 value 1
Current BIGSERIAL value 1
Current REFID value 1
Pagesize (k) 8
First extent size 4042
Next extent size 25856
Number of pages allocated 231898
Number of pages used 221543
Number of data pages 0
Number of rows 0
Partition partnum 26214471
Partition lockid 18874438
Extents
Logical Page Physical Page Size Physical Pages
0 56:283458 4042 8084
4042 56:3160646 1616 3232
5658 56:3746274 1616 3232
7274 56:4651402 1616 3232
8890 56:5140362 1616 3232
10506 56:5166258 1616 3232
12122 56:6893186 1616 3232
13738 56:7578946 1616 3232
15354 56:8117906 1616 3232
16970 56:8347002 1616 3232
18586 56:8369698 3232 6464
21818 102:1911862 3232 6464
25050 102:3402582 3232 6464
28282 102:4520374 3232 6464
31514 102:5468966 3232 6464
34746 102:6297830 3232 6464
37978 102:6876694 6464 12928
44442 102:7674822 6464 12928
50906 102:1729334 6464 12928
57370 102:350006 6464 12928
63834 103:2191338 6464 12928
70298 102:5961158 6464 12928
76762 220:6539638 12928 25856
89690 104:5624396 12928 25856
102618 104:4940578 12928 25856
115546 104:2244542 12928 25856
128474 220:50006 12928 25856
141402 102:299804 12928 25856
154330 220:8113510 25856 51712
180186 104:2054004 25856 51712
206042 220:551206 25856 51712
Index system-rowid fragment partition datacbs10 in DBspace datacbs10
Physical Address 57:975068
Creation date 05/26/2011 13:20:37
TBLspace Flags 802 Row Locking
TBLspace use 4 bit bit-maps
Maximum row size 201
Number of special columns 0
Number of keys 1
Number of extents 29
Current serial value 1
Current SERIAL8 value 1
Current BIGSERIAL value 1
Current REFID value 1
Pagesize (k) 8
First extent size 4042
Next extent size 25856
Number of pages allocated 196186
Number of pages used 172715
Number of data pages 0
Number of rows 0
Partition partnum 27263239
Partition lockid 18874438
Extents
Logical Page Physical Page Size Physical Pages
0 57:283458 4042 8084
4042 57:1760532 1616 3232
5658 57:1920296 1616 3232
7274 57:2080060 1616 3232
8890 57:2505992 1616 3232
10506 57:2665756 1616 3232
12122 57:2825520 1616 3232
13738 57:2985284 1616 3232
15354 57:3145048 1616 3232
16970 57:3358078 1616 3232
18586 57:3721108 3232 6464
21818 57:4047168 3232 6464
25050 57:4473228 3232 6464
28282 57:4786224 3232 6464
31514 57:5005752 3232 6464
34746 57:5325280 3232 6464
37978 57:5531744 6464 12928
44442 57:5744672 6464 12928
50906 57:5907600 6464 12928
57370 106:2110814 6464 12928
63834 57:987890 6464 12928
70298 106:1127074 6464 12928
76762 107:3433462 12928 25856
89690 106:5787982 12928 25856
102618 107:5196532 12928 25856
115546 107:6973138 12928 25856
128474 107:7479938 16000 32000
144474 226:1440006 25856 51712
170330 224:7459408 25856 51712
Index system-rowid fragment partition datacbs11 in DBspace datacbs11
Physical Address 58:636674
Creation date 05/26/2011 13:20:37
TBLspace Flags 802 Row Locking
TBLspace use 4 bit bit-maps
Maximum row size 201
Number of special columns 0
Number of keys 1
Number of extents 24
Current serial value 1
Current SERIAL8 value 1
Current BIGSERIAL value 1
Current REFID value 1
Pagesize (k) 8
First extent size 4042
Next extent size 12928
Number of pages allocated 105118
Number of pages used 93336
Number of data pages 0
Number of rows 0
Partition partnum 28311621
Partition lockid 18874438
Extents
Logical Page Physical Page Size Physical Pages
0 58:231878 4042 8084
4042 58:2783444 1616 3232
5658 58:2889876 1616 3232
7274 58:3049508 1616 3232
8890 58:3847708 1616 3232
10506 58:4586140 1616 3232
12122 58:4752172 1616 3232
13738 58:4911804 1616 3232
15354 58:5065036 1616 3232
16970 58:5118268 1616 3232
18586 58:5221500 3232 6464
21818 58:6179164 3232 6464
25050 58:6870828 3232 6464
28282 58:7668892 3232 6464
31514 58:8363756 3232 6464
34746 108:978806 3232 6464
37978 108:1876870 6464 12928
44442 108:5250740 6464 12928
50906 109:4177522 6464 12928
57370 109:2969488 6464 12928
63834 110:889634 6464 12928
70298 110:3971306 6464 12928
76762 228:8075910 15428 30856
92190 110:923822 12928 25856
Index system-rowid fragment partition datacbs12 in DBspace datacbs12
Physical Address 59:775936
Creation date 05/26/2011 13:20:37
TBLspace Flags 802 Row Locking
TBLspace use 4 bit bit-maps
Maximum row size 201
Number of special columns 0
Number of keys 1
Number of extents 23
Current serial value 1
Current SERIAL8 value 1
Current BIGSERIAL value 1
Current REFID value 1
Pagesize (k) 8
First extent size 4042
Next extent size 12928
Number of pages allocated 89690
Number of pages used 79221
Number of data pages 0
Number of rows 0
Partition partnum 29360197
Partition lockid 18874438
Extents
Logical Page Physical Page Size Physical Pages
0 59:231878 4042 8084
4042 59:3392538 1616 3232
5658 59:3605370 1616 3232
7274 59:4132770 1616 3232
8890 59:4320602 1616 3232
10506 59:4483434 1616 3232
12122 59:4743066 1616 3232
13738 59:4909098 1616 3232
15354 59:4962330 1616 3232
16970 59:5171962 1616 3232
18586 59:5437994 3232 6464
21818 59:5763658 3232 6464
25050 59:5789322 3232 6464
28282 59:5811786 3232 6464
31514 59:7155796 3232 6464
34746 59:8054794 3232 6464
37978 111:2718828 6464 12928
44442 112:8207120 6464 12928
50906 113:7060892 6464 12928
57370 232:690814 6464 12928
63834 111:1306502 6464 12928
70298 112:1753990 6464 12928
76762 113:4206198 12928 25856
$
4.oncheck -pt show the number of page used
Number of pages used 668151
Number of pages used 3403091
Number of pages used 2434915
Number of pages used 2799605
Number of pages used 1896666
Number of pages used 2574304
Number of pages used 1611425
Number of pages used 3786625
Number of pages used 2889476
Number of pages used 1698308
Number of pages used 1394682
totally 25157248 pages.
the page size is 8192, so it use 25157248*8192/1024/1024/1024=192GB ;
the rowsize is 1129 , row count is 917336051, and most column is char data type, the space is 917336051*1129/1024/1024/1024=964GB;
the char data type will pre allocate the space, why the real space is only 192GB
thanks for your time

Messages In This Thread

usage space question 2
CHUAN LU -- Wednesday, 22 February 2017, at 4:42 a.m.
- Re: usage space question 2
  WOLFGANG EPPLER -- Friday, 10 March 2017, at 12:03 p.m.

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

IDS Forum is maintained by Administrator with WebBBS 5.12.