「Oracle 19c」 表領域の自動拡張を確認する方法

環境
Oracle Database 19c Enterprise Edition

SQL構文

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
SELECT
TABLESPACE_NAME
, FILE_NAME
, AUTOEXTENSIBLE
FROM
DBA_DATA_FILES
ORDER BY
1
SELECT TABLESPACE_NAME , FILE_NAME , AUTOEXTENSIBLE FROM DBA_DATA_FILES ORDER BY 1
SELECT
    TABLESPACE_NAME
    , FILE_NAME
    , AUTOEXTENSIBLE 
FROM
    DBA_DATA_FILES 
ORDER BY
    1

DBA_DATA_FILESを使ってOracleの表領域が自動拡張になっているか確認します。

実行結果

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
TABLESPACE_NAME FILE_NAME AUTOEXTENSIBLE
SYSAUX C:\ORACLE\ORADATA\ORCL\DATAFILE\O1_MF_SYSAUX_JRDTRMP7_.DBF YES
SYSTEM C:\ORACLE\ORADATA\ORCL\DATAFILE\O1_MF_SYSTEM_JRDTPQD6_.DBF YES
UNDOTBS1 C:\ORACLE\ORADATA\ORCL\DATAFILE\O1_MF_UNDOTBS1_JRDTTM8K_.DBF YES
USERS C:\ORACLE\ORADATA\ORCL\DATAFILE\O1_MF_USERS_JRDTXHC8_.DBF YES
TABLESPACE_NAME FILE_NAME AUTOEXTENSIBLE SYSAUX C:\ORACLE\ORADATA\ORCL\DATAFILE\O1_MF_SYSAUX_JRDTRMP7_.DBF YES SYSTEM C:\ORACLE\ORADATA\ORCL\DATAFILE\O1_MF_SYSTEM_JRDTPQD6_.DBF YES UNDOTBS1 C:\ORACLE\ORADATA\ORCL\DATAFILE\O1_MF_UNDOTBS1_JRDTTM8K_.DBF YES USERS C:\ORACLE\ORADATA\ORCL\DATAFILE\O1_MF_USERS_JRDTXHC8_.DBF YES
TABLESPACE_NAME	FILE_NAME	                                            AUTOEXTENSIBLE
SYSAUX	        C:\ORACLE\ORADATA\ORCL\DATAFILE\O1_MF_SYSAUX_JRDTRMP7_.DBF	YES
SYSTEM	        C:\ORACLE\ORADATA\ORCL\DATAFILE\O1_MF_SYSTEM_JRDTPQD6_.DBF	YES
UNDOTBS1	C:\ORACLE\ORADATA\ORCL\DATAFILE\O1_MF_UNDOTBS1_JRDTTM8K_.DBF	YES
USERS	       C:\ORACLE\ORADATA\ORCL\DATAFILE\O1_MF_USERS_JRDTXHC8_.DBF	YES

 

Oracle 19c

Posted by arkgame