> SPACEMON Utility - ORCL, 12/07/2000 21:00 > > Space Storage Report, Version 1.8, February 1, 2000 > > Tablespace Space Map > Tablespace Max Contig Total Free Extends Pct Free Name Status Alloc(MB) Alloc Free(MB) Alloc(MB) To(MB) Spc Avail ---------------------------- ------- ---------- -------------- ---------- -------- --------- AREXTAB ONLINE 100 94 94 0 93.70 GLEXIDX ONLINE 1,000 879 897 0 89.73 RBA ONLINE 2,000 1,279 1,787 0 89.34 RBB ONLINE 2,000 987 1,787 0 89.34 APEXIDX ONLINE 1,100 960 966 0 87.82 GLDIDX ONLINE 2,000 1,550 1,604 0 80.19 APEXTAB ONLINE 800 338 577 0 72.06 GLIDX ONLINE 1,600 509 1,125 0 70.32 SHRTAB ONLINE 600 396 396 0 66.00 AREXATAB ONLINE 500 151 329 0 65.87 ARIDX ONLINE 600 374 388 0 64.69 AREXAIDX ONLINE 100 60 60 0 59.75 PAEXIDX ONLINE 50 29 29 0 57.31 TMPTAB ONLINE 200 100 114 0 56.99 TOOLS ONLINE 100 53 57 0 56.52 GLDTAB ONLINE 2,000 1,046 1,046 0 52.31 PATAB ONLINE 900 434 466 0 51.76 POIDX ONLINE 1,200 595 603 0 50.25 ARTAB ONLINE 400 199 199 0 49.86 SYSTEM ONLINE 1,000 299 471 0 47.12 SHRIDX ONLINE 500 232 232 0 46.41 POAIDX ONLINE 700 170 321 0 45.86 PAEXTAB ONLINE 150 56 56 0 37.33 GLEXTAB ONLINE 600 208 215 0 35.89 POATAB ONLINE 1,200 218 417 0 34.75 POTAB ONLINE 1,900 558 646 0 34.02 PAIDX ONLINE 600 100 181 0 30.10 GLEXATAB ONLINE 1,000 239 300 0 29.98 GLTAB ONLINE 1,100 13 321 0 29.17 HRTAB ONLINE 450 100 129 0 28.71 GLCIDX ONLINE 4,000 1,050 1,072 0 26.79 APEXATAB ONLINE 2,000 410 520 0 26.01 USERS ONLINE 200 45 47 0 23.39 APEXAIDX ONLINE 1,300 288 289 0 22.20 APTAB ONLINE 1,500 284 284 0 18.94 FNDIDX ONLINE 420 4 71 420 16.99 GLCTAB ONLINE 4,000 400 500 0 12.50 FNDTAB ONLINE 600 57 57 600 9.58 APIDX ONLINE 1,150 41 53 0 4.64 TEMP ONLINE 3,000 1 2 0 .06 >List Segments with FEW ( < 20% ) extents left Owner Segment Type Max Ext Ext Used ---------- ------------------------------ --------- ---------- ---------- AP AP_INVOICES_U2 INDEX 50 42 >List Tables With CHAINED Rows > 10% > (Assumes statistics exist) >List Partitioned Tables With CHAINED Rows > 10% > (Assumes statistics exist) >List objects that cannot extend - Increase tablespace or reduce next > extent. Does not account for > auto-extending tablespaces Tablespace Cur Max Next Max Owner Segment Type Name Ext Ext Ext(KB) Free(KB) ---------- ------------------------------ --------- --------------- ------- -------------- -------- -------- APPLSYS WF_ITEM_ACTIVITY_STATUSES_H_N1 INDEX FNDIDX 1 50 8,192 4,320 GL GL_ARCHIVE_DAILY_BALANCES TABLE GLTAB 1 50 34,816 12,848 GL GL_DAILY_BALANCES TABLE GLTAB 1 50 34,816 12,848 GL GL_DATE_PERIOD_MAP TABLE GLTAB 2 50 34,816 12,848 GL GL_TRANSACTION_DATES TABLE GLTAB 1 50 34,816 12,848 >List objects that have extended within the last reporting period Previous Previous Current Current Current Owner Name Type Date KBytes Date KBytes Extents ---------- ------------------------------ --------- --------- ---------- --------- ---------- ----------- AP AP_INVOICE_DISTRIBUTIONS_U1 INDEX 14-SEP-00 45,200 07-DEC-00 46,240 9 AP_INVOICE_DISTRIBUTIONS_N2 INDEX 07-SEP-00 33,760 07-DEC-00 34,800 8 AR RA_CUSTOMER_TRX_ALL TABLE 01-JUN-00 20,880 07-DEC-00 21,920 11 GL GL_IMPORT_REFERENCES_N3 INDEX 07-SEP-00 222,016 07-DEC-00 226,176 106 GL_BALANCES TABLE 09-NOV-00 3,379,200 07-DEC-00 3,584,000 31 GL_BALANCES_N3 INDEX 09-NOV-00 783,984 07-DEC-00 809,584 30 >List history of objects that have extended within the last reporting period Initial Next PCT Owner Name Type Ext(KB) Ext(KB) Incr Tablespace Date KBytes Extents ---------- ------------------------------ ---------- ---------- ---------- ---- --------------- --------- ---------- ----------- AP AP_INVOICE_DISTRIBUTIONS_N2 INDEX 29,440 1,024 0 APIDX 07-DEC-00 34,800 8 29,440 1,024 0 APIDX 07-SEP-00 33,760 7 29,440 1,024 0 APIDX 25-MAY-00 32,720 6 29,440 512 0 APIDX 30-MAR-00 31,680 5 29,440 512 0 APIDX 20-JAN-00 31,120 4 29,440 512 0 APIDX 11-NOV-99 30,560 3 29,440 512 0 APIDX 30-SEP-99 30,000 2 29,440 512 0 APIDX 12-JUL-99 29,440 1 AP_INVOICE_DISTRIBUTIONS_U1 INDEX 39,808 1,024 0 APIDX 07-DEC-00 46,240 9 39,808 1,024 0 APIDX 14-SEP-00 45,200 8 39,808 1,024 0 APIDX 29-JUN-00 44,160 7 39,808 1,024 0 APIDX 13-APR-00 43,120 6 39,808 512 0 APIDX 24-FEB-00 42,080 5 39,808 512 0 APIDX 13-JAN-00 41,520 4 39,808 512 0 APIDX 25-NOV-99 40,960 3 39,808 512 0 APIDX 14-OCT-99 40,400 2 39,808 512 0 APIDX 12-JUL-99 39,840 1 AR RA_CUSTOMER_TRX_ALL TABLE 11,472 1,024 0 ARTAB 07-DEC-00 21,920 11 11,472 1,024 0 ARTAB 01-JUN-00 20,880 10 11,472 1,024 0 ARTAB 02-DEC-99 19,840 9 11,472 1,024 0 ARTAB 12-JUL-99 18,800 8 GL GL_BALANCES TABLE 512,000 102,400 0 GLCTAB 07-DEC-00 3,584,000 31 512,000 102,400 0 GLCTAB 09-NOV-00 3,379,200 29 512,000 102,400 0 GLCTAB 26-OCT-00 3,276,800 28 512,000 102,400 0 GLCTAB 19-OCT-00 3,072,000 26 512,000 102,400 0 GLCTAB 07-SEP-00 2,969,600 25 512,000 102,400 0 GLCTAB 10-AUG-00 2,764,800 23 512,000 102,400 0 GLCTAB 06-JUL-00 2,662,400 22 512,000 102,400 0 GLCTAB 08-JUN-00 2,560,000 21 512,000 102,400 0 GLCTAB 11-MAY-00 2,457,600 20 512,000 102,400 0 GLCTAB 06-APR-00 2,252,800 18 512,000 102,400 0 GLCTAB 09-MAR-00 2,150,400 17 512,000 102,400 0 GLCTAB 24-FEB-00 2,048,000 16 GL_BALANCES_N3 INDEX 51,200 25,600 0 GLCIDX 07-DEC-00 809,584 30 51,200 25,600 0 GLCIDX 09-NOV-00 783,984 29 51,200 25,600 0 GLCIDX 26-OCT-00 732,784 27 51,200 25,600 0 GLCIDX 19-OCT-00 681,584 25 51,200 25,600 0 GLCIDX 07-SEP-00 655,984 24 51,200 25,600 0 GLCIDX 10-AUG-00 604,784 22 51,200 25,600 0 GLCIDX 06-JUL-00 579,184 21 51,200 25,600 0 GLCIDX 08-JUN-00 527,984 19 51,200 25,600 0 GLCIDX 11-MAY-00 502,384 18 51,200 25,600 0 GLCIDX 06-APR-00 451,184 16 51,200 25,600 0 GLCIDX 09-MAR-00 425,584 15 51,200 25,600 0 GLCIDX 24-FEB-00 399,984 14 GL_IMPORT_REFERENCES_N3 INDEX 148,992 4,096 0 GLIDX 07-DEC-00 226,176 106 148,992 4,096 0 GLIDX 07-SEP-00 222,016 105 148,992 4,096 0 GLIDX 08-JUN-00 217,856 104 148,992 4,096 0 GLIDX 09-MAR-00 213,696 103 148,992 1,024 0 GLIDX 10-FEB-00 209,536 102 Initial Next PCT Owner Name Type Ext(KB) Ext(KB) Incr Tablespace Date KBytes Extents ---------- ------------------------------ ---------- ---------- ---------- ---- --------------- --------- ---------- ----------- GL GL_IMPORT_REFERENCES_N3 INDEX 148,992 1,024 0 GLIDX 27-JAN-00 208,496 101 148,992 1,024 0 GLIDX 06-JAN-00 207,456 100 148,992 1,024 0 GLIDX 09-DEC-99 206,416 99 148,992 1,024 0 GLIDX 11-NOV-99 205,376 98 148,992 1,024 0 GLIDX 21-OCT-99 204,336 97 148,992 1,024 0 GLIDX 30-SEP-99 203,296 96 148,992 1,024 0 GLIDX 09-SEP-99 202,256 95 148,992 512 0 GLIDX 26-AUG-99 201,216 94 148,992 512 0 GLIDX 12-AUG-99 200,656 93 148,992 512 0 GLIDX 30-JUL-99 200,096 92 148,992 512 0 GLIDX 26-JUL-99 199,536 91 148,992 512 0 GLIDX 12-JUL-99 198,976 90