- TOTAL AVAILABLE SPACE IN TABLESPACES
TSNAME BYTES BLOCKS DATA_FILES
---------- -------------- -------------- ----------
EINDEX 1,409,286,144 688,128 1
RBS 104,857,600 51,200 1
SYSTEM 57,671,680 28,160 1
TEMP 524,288,000 256,000 1
TOOLS 26,214,400 12,800 1
USERS 3,616,538,624 1,765,888 2
- SPACE RESERVED IN TABLESPACES - TOTAL
TSNAME BYTES BLOCKS % USED
---------- -------------- -------------- ---------
EINDEX 854,884,352 26,089 46.59
RBS 44,171,264 1,348 28.08
SYSTEM 17,432,576 532 23.75
TEMP 311,459,840 9,505 15.23
TOOLS 6,324,224 193 24.13
USERS 1,221,394,432 37,274 31.06
- Major tables
TABLE_NAME NUM_ROWS BLOCKS EMPTY_BLOCKS AVG_SPACE AVG_ROW_LEN
----------------- ---------- ---------- ------------ ---------- -----------
RENGASTETTU 5200073 18395 13604 2571 53
RENGASTUS 2667917 18395 13604 2571 153
TAPAAMINEN 528216 2800 399 792 167
- Major indexes
INDEX_NAME BLEVEL LEAF_BLOCKS DISTINCT_KEYS AVG_LEAF AVG_DATA
--------------- ---------- ----------- ------------- ---------- ----------
XCRENGASTUS 1 1802 2667917 1 0
XPRENGASTETTU 2 3574 5200073 1 1
XPRENGASTUS 1 1762 2667917 1 1
XPTAPAAMINEN 1 355 528216 1 1
XSRENGASTETTU1 2 3351 5199503 1 1
XSRENGASTUS1 1 1472 376 3 560
XSRENGASTUS2 1 1426 560 2 208
XSRENGASTUS3 2 2018 128405 1 2
XSRENGASTUS4 1 1203 1264 1 51
XSRENGASTUS5 1 1588 15200 1 34
XSTAPAAMINEN1 1 244 289 1 103
XSTAPAAMINEN10 1 341 375358 1 1
XSTAPAAMINEN2 1 240 549 1 96
XSTAPAAMINEN3 1 44 984 1 39
XSTAPAAMINEN4 1 398 70200 1 2
XSTAPAAMINEN6 1 308 18004 1 17
XSTAPAAMINEN7 1 226 73 3 367
XSTAPAAMINEN8 1 341 375653 1 1
XSTAPAAMINEN9 1 178 897 1 44