[test:oracle]:/home/oracle>sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Tue Mar 15 10:24:56 2022
Version 19.11.0.0.0

Copyright (c) 1982, 2020, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.11.0.0.0

SQL> select sum(bytes) / 1024 / 1024 /1024 as GB　from cdb_data_files;

        GB
----------
278.899414

sys@test 08:53:03> select tablespace_name ,sum(bytes) / 1024 / 1024 as MB　from cdb_data_files group by tablespace_name;

TABLESPACE_NAME              MB
-------------------- ----------
SYSTEM                     1190
UNDOTBS2                   1024
SYSAUX                     1750
TBS001                      500
OGG_TBS                    5120
RMAN_TS                    1024
USERS                   1871.25
APP_SCHE_DA        150
TA_TBS


8 rows selected.

sys@testdb 10:28:54> col tablespace_name for a50
sys@testdb 10:29:15> col file_name for a50
sys@testdb 10:29:22> select tablespace_name,file_name from dba_data_files;

TABLESPACE_NAME                                    FILE_NAME
-------------------------------------------------- --------------------------------------------------
SYSTEM                                             /oradata/testdb/system01.dbf
SYSAUX                                             /oradata/testdb/sysaux01.dbf
USERS                                              /oradata/testdb/users01.dbf
UNDOTBS2                                           /oradata/testdb/undotbs03.dbf
OGG_TBS                                            /oradata/testdb/ogg_tbs.dbf
RMAN_TS                                            /oradata/testdb/rmants.dbf
TBS001                                             /oradata/testdb/tbs001.dbf
APPRPTFASDLS_SCHE_DATA_TBS                         /oradata/testdb/APPRPTFASDLS_SCHE_DATA_TBS.dbf

8 rows selected.

版权声明：本文为博主原创文章，未经博主允许不得转载。

oracle