venerdì 19 agosto 2011

Oracle total size of tables


Using the fooling SQL command in SQL Plus or TOAD:

SELECT SUM(BYTES) FROM USER_SEGMENTS WHERE SEGMENT_TYPE='TABLE';

this is the result


Nessun commento:

Posta un commento