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
Showing posts with label oracle 11g. Show all posts
Showing posts with label oracle 11g. Show all posts
Monday, February 22, 2010
Subscribe to:
Posts (Atom)
