equal
deleted
inserted
replaced
156 |
156 |
157 select SEGMENT_NAME, SEGMENT_TYPE, sum(BYTES) from USER_EXTENTS |
157 select SEGMENT_NAME, SEGMENT_TYPE, sum(BYTES) from USER_EXTENTS |
158 group by SEGMENT_NAME, SEGMENT_TYPE order by sum(BYTES); |
158 group by SEGMENT_NAME, SEGMENT_TYPE order by sum(BYTES); |
159 |
159 |
160 select sum(BYTES) from USER_EXTENTS; |
160 select sum(BYTES) from USER_EXTENTS; |
|
161 |
|
162 Get LOB stored size:: |
|
163 |
|
164 select sum(dbms_lob.getchunksize(COL))/1024/1024 MiB from TBL; |
161 |
165 |
162 Table indexes restricted to user:: |
166 Table indexes restricted to user:: |
163 |
167 |
164 select * from USER_INDEXES order by TABLE_NAME; |
168 select * from USER_INDEXES order by TABLE_NAME; |
165 |
169 |