schema size in oracle

Question

342 views24/09/2022Oracle Database

0

Ezana886 01/08/2022 0 Comments

How to calculate the size of a schema in oracle database?

meda Changed status to publish 01/08/2022

Write your answer.

score 0 · Answer 1 · 2022-09-24T07:38:51+00:00

To calculate the actual size of the schema or user in oracle database use the query below.

SQL> select owner, sum(bytes)/1024/1024/1024 Size_GB from dba_segments group by owner;