Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Tamanho dos objetos em um schema oracle
-- Todos os objetos do schema
select
owner,
sum(bytes)/1024/1024/1024 schema_size_gig
from
dba_segments
group by
owner;
-- Tamanho por tipo de objeto
select
sum(bytes)/1024/1024/1024 as size_in_gig,
segment_type
from
dba_segments
where
owner='USER'
group by
segment_type;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.