1- كيف يمكن معرفة جحم قاعدة البيانات ؟
2- ومن اي الجداول يمكن معرفة حجم قاعدة البيانات ؟

ارجو المساعدة ..........

The majority of the size comes from the datafiles. To find out how many
megabytes are allocated by ALL tablespaces, type:

select sum(bytes)/1024/1024 from dba_data_files;

Add to this the size (in megabytes) of your redo logs:

select sum(bytes)/1024/1024 from v$log;

The above two queries will show you how large your database is. Also, if
you are in archivelog mode, you will generate files in your archivelog
destination. Issue the following query to see where your archived redo
logs get placed:

select * from v$parameter where name = 'log_archive_dest';

shokraaaaa

selman0
askelwos

تم تعديل 14 يونيو 200619 سنة بواسطة selman0