daohoan122

☘️

On vacation

daohoan122 / calculate_more_power.sql

Created March 13, 2023 08:03 — forked from rponte/calculate_more_power.sql

calculating tables size in Oracle

	COLUMN TABLE_NAME FORMAT A32
	COLUMN OBJECT_NAME FORMAT A32
	COLUMN OWNER FORMAT A10

	SELECT
	owner, table_name, TRUNC(sum(bytes)/1024/1024) Meg
	FROM
	(SELECT segment_name table_name, owner, bytes
	FROM dba_segments
	WHERE segment_type = 'TABLE'