equal
deleted
inserted
replaced
164 select * from DBA_TABLES; |
164 select * from DBA_TABLES; |
165 |
165 |
166 List table sizes:: |
166 List table sizes:: |
167 |
167 |
168 select from DBA_SEGMENTS; |
168 select from DBA_SEGMENTS; |
|
169 |
|
170 Schema sizes:: |
|
171 |
|
172 select OWNER, sum(BYTES)/1024/1024 as MiB |
|
173 from DBA_SEGMENTS |
|
174 group by OWNER; |
169 |
175 |
170 Get LOB stored size:: |
176 Get LOB stored size:: |
171 |
177 |
172 select sum(dbms_lob.getchunksize(COL))/1024/1024 MiB from TBL; |
178 select sum(dbms_lob.getchunksize(COL))/1024/1024 MiB from TBL; |
173 |
179 |