查看Oracle 数据库的每天归档量大小

 1、日志位置

SQL>  select group#,member from v$logfile;

    GROUP# MEMBER

---------- ------------------------------------------------------------

    GROUP# MEMBER

---------- ------------------------------------------------------------

    GROUP# MEMBER

---------- ------------------------------------------------------------

24 rows selected.

SQL> select GROUP#,MEMBERS,BYTES/1024/1024,THREAD# from v$log;

---------- ---------- --------------- ----------

12 rows selected.

SQL> archive log list;

Oldest online log sequence     1001

Next log sequence to archive   1006

SQL> show parameter recover;

------------------------------------ ----------- ------------------------------

SQL> Select to_char(completion_time,'yyyy-mm-dd') as date1,count(0) as cnt,round(sum((blocks *block_size)/1024/1024)) as m

b from v$archived_loggroup by to_char(completion_time,'yyyy-mm-dd') order by date1 desc;  

---------- ---------- ----------

---------- ---------- ----------

21 rows selected.

SQL>  select sum(a.BLOCK_SIZE*a.BLOCKS)/1024/1024 from v$archived_log a ; 

SUM(A.BLOCK_SIZE*A.BLOCKS)/1024/1024

------------------------------------

【注】查看数据库数据大小信息：

 1、查看所有表空间及表空间大小：

SQL> select tablespace_name ,(sum(bytes) / 1024 / 1024) as MB from dba_data_files group by tablespace_name;

TABLESPACE_NAME        MB

------------------------------ ----------

HTTBS_MESPRD        36863.9844

SYSAUX     14336

UNDOTBS1      1024

USERS      2000

HTTBS_ES_DBA      2000

SYSTEM      4096

HTTBS_MESPRD_IDX     10240

MHDB     24576

UNDOTBS2      1024

9 rows selected.

2、查看所有表空间对应的数据文件：

SQL> select tablespace_name,file_name from dba_data_files;

TABLESPACE_NAME        FILE_NAME

------------------------------ ------------------------------------------------------------

SYSTEM        +DATA/mhdb/datafile/system.265.982084581

SYSAUX        +DATA/mhdb/datafile/sysaux.258.982084619

UNDOTBS1        +DATA/mhdb/datafile/undotbs1.257.982084655

UNDOTBS2        +DATA/mhdb/datafile/undotbs2.271.982084669

USERS        +DATA/mhdb/datafile/users.270.982084671

HTTBS_MESPRD        +DATA/mhdb/datafile/httbs_mesprd.269.982084937

HTTBS_ES_DBA        +DATA/mhdb/datafile/httbs_es_dba.268.982085079

HTTBS_MESPRD_IDX        +DATA/mhdb/datafile/httbs_mesprd_idx.264.982085081

MHDB        +DATA/mhdb/datafile/mhdb.263.982085179

SYSAUX        +DATA/mhdb/datafile/sysaux.284.1004630203

HTTBS_MESPRD        +DATA/mhdb/datafile/httbs_mesprd.273.1004630353

MHDB        +DATA/mhdb/datafile/mhdb.279.1004630391

12 rows selected.

亿速云「云数据库 MySQL」免部署即开即用，比自行安装部署数据库高出1倍以上的性能，双节点冗余防止单节点故障，数据自动定期备份随时恢复。点击查看>>