size_in_bytes, space_used from v$exa_file where con_id=3 and file_name like '%USERS%'; FILE_NAME SIZE_IN_BYTES SPACE_USED __________________________________________________________________________________________________________________________ ________________ _____________ KIXSX-VMC2-59BCD16C14006F20BFFEDAF765F1B057/DB0129_X6G_KIX/2CD29BC56E31AD0DE0635600000ADF66/DATAFILE/USERS.OMF.6E8F1E73 1073750016 3221250048 コンソール作成フルクローン SQL> select file_name, size_in_bytes, space_used from v$exa_file where con_id=4 and file_name like '%USERS%'; FILE_NAME SIZE_IN_BYTES SPACE_USED __________________________________________________________________________________________________________________________ ________________ _____________ KIXSX-VMC2-59BCD16C14006F20BFFEDAF765F1B057/DB0129_X6G_KIX/2CD3A96825BD4163E0635600000A4D97/DATAFILE/USERS.OMF.4665B422 1073750016 3221250048 コンソール作成シンクローン SQL> select file_name, size_in_bytes, space_used from v$exa_file where con_id=5 and file_name like '%USERS%'; FILE_NAME SIZE_IN_BYTES SPACE_USED __________________________________________________________________________________________________________________________ ________________ _____________ KIXSX-VMC2-59BCD16C14006F20BFFEDAF765F1B057/DB0129_X6G_KIX/2CD42B34C253E0D9E0635600000A2B9B/DATAFILE/USERS.OMF.6E8F1E73 1073750016 322161867 コマンド作成シンクローン(SNAPSHOT COPY句) SQL> select file_name, size_in_bytes, space_used from v$exa_file where con_id=7 and file_name like '%USERS%'; FILE_NAME SIZE_IN_BYTES SPACE_USED __________________________________________________________________________________________________________________________ ________________ _____________ KIXSX-VMC2-59BCD16C14006F20BFFEDAF765F1B057/DB0129_X6G_KIX/2CD45043F3C68CD6E0635600000A032C/DATAFILE/USERS.OMF.6E8F1E73 1073750016 322161867 SIZE_IN_BYTES は同じだが、シンクローンのSPACE_USED が一桁小さいことが分かる PDB シン・クローン Copyright © 2026, Oracle and/or its affiliates 139 ※2025年2月更新