tablespace 100 percent full
778369Jul 7 2011 — edited Aug 13 2012two node rac
windows
10.2.0.4
asm
some tablespaces are 100 percent full
do ineed to take any actions?
any suggestions?
any monitoring required?
please le t me know
you can observe below output
cheers :-)
TABLESPACE_NAME size MB free MB % used
---------------------------------------- ------------ ----------- ------
OSMM_FK_IDX 500 500 0
OSMM_IAS_IDX 500 500 0
PORTAL_LOG 50 50 0
SOMUTS 10 10 0
UNDOTBS1 83,340 83,299 0
OSMM_IAE_IDX 500 500 0
UNDOTBS2 25,280 25,199 0
OSMM_PK_IDX 500 500 0
OSMM_IRF_IDX 500 500 0
PORTAL_DOC 40 39 2
OLTS_BATTRSTORE 15 15 2
OSMM_TA_PARTITION0_SIDX 500 485 3
BAM 200 194 3
WCRSYS_TS 45 44 3
OCATS 35 34 5
USERS 11,439 10,618 7
ORABPEL 100 89 11
DISCO_PTM5_META 10 9 13
DISCO_PTM5_CACHE 10 9 13
DSGATEWAY_TAB 35 30 15
OLTS_SVRMGSTORE 15 13 18
os250kcolour 1,000 794 20
OSMM_TA_PARTITION0_DATA 1,000 762 23
B2B_LOB 40 30 26
osgazetteer 200 131 34
B2B_IDX 40 26 36
OSSTRATEGI 1,300 828 36
OLTS_ATTRSTORE 15 9 40
PORTAL_IDX 50 30 40
UDDISYS_TS 50 30 40
B2B_RT 75 37 50
OLTS_DEFAULT 15 8 52
PORTAL 100 35 65
IAS_META 300 95 68
OSBOUNDARYLINE 3,000 889 70
OSMM_TA_PARTITION15_SIDX 1,800 508 71
OSMM_TA_PARTITION10_SIDX 3,000 828 72
OSMM_TA_PARTITION4_SIDX 4,900 1,368 72
OSMM_TA_PARTITION16_SIDX 1,600 435 72
OSMM_TA_PARTITION7_SIDX 3,500 963 72
OSMM_TA_PARTITION13_SIDX 3,500 958 72
OSMM_TA_PARTITION3_SIDX 4,900 1,353 72
OSMM_TA_PARTITION12_SIDX 3,300 871 73
OSMM_TA_PARTITION6_SIDX 3,700 978 73
OSMM_TA_PARTITION9_SIDX 3,800 991 73
OSMM_TA_PARTITION1_SIDX 3,600 941 73
OSMM_TA_PARTITION5_SIDX 3,300 833 74
OSMM_TA_PARTITION11_SIDX 3,000 751 74
OSLANDFORMPANORAMADTM 1,000 244 75
OSMM_TA_PARTITION2_SIDX 4,000 968 75
OSMASTERMAP 500 125 75
OSMM_TA_PARTITION8_SIDX 3,000 745 75
OSMM_TA_PARTITION14_SIDX 2,300 506 78
B2B_DT 75 15 81
oscodepoint 300 57 81
os50kcolour 5,000 772 84
OSODLOGS 51,400 7,630 85
os10kcolour 40,500 5,694 85
OLTS_CT_STORE 45 5 89
DCM 100 10 90
SYSTEM 999 74 92
os10kbw 40,500 2,638 93
OSVECTORMAPDISTRICT 20,000 687 96
OSMERIDIAN2 1,500 39 97
OSITNROADS 4,500 102 97
OSLANDFORMPANORAMACOUNTOURS 1,100 25 97
SYSAUX 2,720 31 98
OSITNPATHS 2,800 41 98
OSLANDFORMPROFILEDTM 7,500 83 98
OSMM_TA_PARTITION8_DATA 12,300 56 99
OSMM_TA_PARTITION11_DATA 12,300 34 99
OSMM_TA_PARTITION12_DATA 12,200 40 99
OSMM_TA_PARTITION13_DATA 12,900 11 99
OSMM_TA_PARTITION15_DATA 7,400 10 99
OSMM_TA_PARTITION14_DATA 10,300 97 99
os25kcolour 15,400 2 99
RMANTS 580 2 99
OSMM_TA_PARTITION5_DATA 14,400 79 99
OSMM_TA_PARTITION7_DATA 13,500 86 99
OSMM_TA_PARTITION9_DATA 14,500 63 99
OSMM_TA_PARTITION10_DATA 11,300 59 99
OSMM_IFD_IDX 18,900 80 99
OSMM_TA_PARTITION3_DATA 17,500 68 99
OSLANDFORMPROFILECONTOURS 19,700 54 99
OSLOCATOR 550 6 99
OSMM_TA_PARTITION4_DATA 17,500 80 99
OSMM_TA_PARTITION1_DATA 15,700 46 99
OSMM_TA_PARTITION2_DATA 16,200 8 99
OSMM_TA_PARTITION16_DATA 8,400 23 99
osstreetview 21,900 56 99
OSVECTORMAPLOCAL 80,700 164 99
OSMM_TA_PARTITION6_DATA 13,600 50 99
TEMP **TEMP** 2,250 0 100
OSMM_TEMP_4 **TEMP** 13,544 0 100
OSMM_TEMP_2 **TEMP** 4,096 0 100
OSMM_TEMP_1 **TEMP** 2,048 0 100
OSMM_TEMP_3 **TEMP** 10,240 0 100