Sql

Search

oracle db get table sizes

select segment_name, sum(bytes)/1024 KB 
from user_segments 
where segment_type='TABLE' and segment_name in (SELECT TABLE_NAME FROM ALL_TABLES) 
group by segment_name order by KB desc;

Comment

PREVIOUS	NEXT

Code Example
Sql :: add foreign key constraint in postgresql
Sql :: connecting to mysql database using python
Sql :: sql create table if not exists
Sql :: update with join sql server
Sql :: psql datetime grather than
Sql :: create in sql
Sql :: purge undo tablespace usage
Sql :: create database collation
Sql :: dynamic sql invalid table name
Sql :: Copy Table from SQL to CSV
Sql :: clone table structure mysql
Sql :: mysql date to string
Sql :: insert query in ci
Sql :: mysql find missing values
Sql :: sql delete caracter list
Sql :: mysqldump: Got error: 1045: Access denied for user
Sql :: sql truncate statement
Sql :: psql change table schema
Sql :: what is integrity constraints
Sql :: calculate age in sql postgresql
Sql :: change date format in oracle query
Sql :: postgres foreign key multiple columns
Sql :: mysql error 1251
Sql :: psql fatal database does not exist
Sql :: mysql separator
Sql :: mysql case when on date
Sql :: savepoint in sql
Sql :: mysql generate uuid
Sql :: select last row mysql
Sql :: pl/sql procedure example

Search

SQL

oracle db get table sizes

ADD CONTENT