I recently had to determine the size of my schema and the size of the text indexes used in that schema. These SQL statements got me the results:
SQL> select sum(bytes) from dba_segments where owner='SCHEMA_NAME' and SEGMENT_NAME like '%$%';
SUM(BYTES)
----------
6663307264
SQL> select sum(bytes) from dba_segments where owner='SCHEMA_NAME';
SUM(BYTES)
----------
9464446976
A blog about software development, primarily in Java and about web applications.
About Me
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment