author | Oleksandr Gavenko <gavenkoa@gmail.com> |
Wed, 22 Aug 2018 16:04:23 +0300 (2018-08-22) | |
changeset 2270 | da95425e3010 |
parent 2269 | 7002dd57037b |
child 2271 | 589a1f5f6cbd |
oracle.rst | file | annotate | diff | comparison | revisions |
--- a/oracle.rst Tue Aug 21 21:15:58 2018 +0300 +++ b/oracle.rst Wed Aug 22 16:04:23 2018 +0300 @@ -159,6 +159,10 @@ select sum(BYTES) from USER_EXTENTS; +Get LOB stored size:: + + select sum(dbms_lob.getchunksize(COL))/1024/1024 MiB from TBL; + Table indexes restricted to user:: select * from USER_INDEXES order by TABLE_NAME;