[progress Communities] [progress Openedge Abl] Forum Post: Re: Excessive Clob Growth

Status
Not open for further replies.
C

ctoman

Guest
here you go... /home/dbadmin->sudo proutil /db/data/carolina -C dbanalys "Lobs" OpenEdge Release 11.4 as of Fri Jul 25 19:00:25 EDT 2014 PROGRESS Database Analysis Database: /db/data/carolina Blocksize: 8192 RecSpaceSearchDepth: 5 Options: chanalys ixanalys tabanalys area Lobs Date: Fri Apr 29 16:55:37 2016 [Warning] database in use - reported statistics are approximations. (2486) CHAIN ANALYSIS FOR AREA "Lobs": 72 ---------------------------------------------------------- FREE CLUSTER CHAIN ANALYSIS --------------------------- 0 cluster(s) found in the free cluster chain. FREE CHAIN ANALYSIS ------------------- Number of Object Object Blocks Type ---------------------------------------------------------------------------------------------------------------- 505 Master --:0 0 Table PUB.zsaztdl:624 0 Blob PUB.zsaztdl.querydata:2 0 Blob PUB.zsaztdl.returndata:3 0 Blob PUB.zsaztdl.reqheader:4 0 Blob PUB.zsazaudit.rqst:9 0 Blob PUB.zsazaudit.rspons:10 RM CHAIN ANALYSIS --------------------------- Number of Object Object Blocks Type ---------------------------------------------------------------------------------------------------------------- 182160 Table PUB.zsaztdl:624 182162 Blob PUB.zsaztdl.querydata:2 239 Blob PUB.zsaztdl.returndata:3 248 Blob PUB.zsaztdl.reqheader:4 457 Blob PUB.zsazaudit.rqst:9 323 Blob PUB.zsazaudit.rspons:10 INDEX DELETE CHAIN ANALYSIS --------------------------- AREA "Lobs": 72 BLOCK ANALYSIS ------------------------------------------------- 1781948 block(s) found in the area. Current high water mark: 1781759 RECORD BLOCK SUMMARY RECORD BLOCK SUMMARY FOR AREA "Lobs": 72 ------------------------------------------------------- RECORD BLOCK SUMMARY FOR SHARED TABLES -------------------------------------------- -Record Size (B)- ---Fragments--- Scatter Table Records Size Min Max Mean Count Factor Factor PUB.zsaztdl 451692 44.8M 103 124 103 451692 1.0 1.0 ----------------------------------------------------------------------------- Subtotals: 451692 44.8M 103 124 103 451692 1.0 1.1 ----------------------------------------------------------------------------- Summary for AREA "Lobs": 72 Subtotals: 451692 44.8M 103 124 103 451692 1.0 1.1 ----------------------------------------------------------------------------- Totals: 451692 44.8M 103 124 103 451692 1.0 1.1 1781224 RM block(s) found in the storage area. 26.53% of the RM block space is used. 0 index block(s) found in the storage area. 0.0% of the index block space is used. DATABASE SUMMARY SUMMARY FOR AREA "Lobs": 72 ------------------------------------------------------- SUMMARY FOR SHARED OBJECTS: -------------------------------------------- Records Indexes Combined NAME Size Tot % Size Tot % Size Tot % PUB.zsaztdl 44.8M 100.0 0.0B 0.0 44.8M 100.0 ----------------------------------------------------------- Total 44.8M 100.0 0.0B 0.0 44.8M 100.0 Size key: B = bytes K = kilobytes M = megabytes G = gigabytes T = terabytes AREA BLOCK ANALYSIS: ----------------------- 1 area block(s) found in the storage area. 7 cluster list block(s) found in the storage area. 7 cluster allocation block(s) found in the storage area. 7 object block(s) found in the storage area. 1 object list block(s) found in the storage area. 7 object allocation block(s) found in the storage area. 0 row allocation block(s) found in the storage area. 505 free block(s) found in the storage area. 189 empty block(s) found in the storage area. 1781948 total blocks found in the storage area. [Warning] database in use - reported statistics are approximations. (2486) Database analysis complete Fri Apr 29 16:57:13 2016

Continue reading...
 
Status
Not open for further replies.
Top