oracle.rst
changeset 2569 8f4415990863
parent 2341 d241ba9f9366
child 2570 f1aad564e5d5
--- a/oracle.rst	Mon Jun 12 19:20:25 2023 +0300
+++ b/oracle.rst	Tue Nov 07 12:40:22 2023 +0200
@@ -159,6 +159,14 @@
 
   select sum(BYTES) from USER_EXTENTS;
 
+List all tables::
+
+  select * from DBA_TABLES;
+
+List table sizes::
+
+  select from DBA_SEGMENTS;
+
 Get LOB stored size::
 
   select sum(dbms_lob.getchunksize(COL))/1024/1024 MiB from TBL;