select file_id, file_name,
tablespace_name ts_name,
0 frequency,
0 x_2_null,
0 x_2_null_forced_write,
0 x_2_null_forced_stale,
0 x_2_s,
0 x_2_s_forced_writes,
0 x_2_ssx,
0 x_2_ssx_forced_writes,
0 s_2_null,
0 s_2_null_forced_stale,
0 ss_2_null,
0 wrb,
0 wrb_forced_write,
0 rbr,
0 rbr_forced_write,
0 rbr_forced_stale,
0 cbr,
0 cbr_forced_write,
0 null_2_x,
0 s_2_x,
0 ssx_2_x,
0 n_2_s,
0 n_2_ss
from dba_data_files
SELECT FILE_ID
, FILE_NAME
,
TABLESPACE_NAME TS_NAME
,
0 FREQUENCY
,
0 X_2_NULL
,
0 X_2_NULL_FORCED_WRITE
,
0 X_2_NULL_FORCED_STALE
,
0 X_2_S
,
0 X_2_S_FORCED_WRITES
,
0 X_2_SSX
,
0 X_2_SSX_FORCED_WRITES
,
0 S_2_NULL
,
0 S_2_NULL_FORCED_STALE
,
0 SS_2_NULL
,
0 WRB
,
0 WRB_FORCED_WRITE
,
0 RBR
,
0 RBR_FORCED_WRITE
,
0 RBR_FORCED_STALE
,
0 CBR
,
0 CBR_FORCED_WRITE
,
0 NULL_2_X
,
0 S_2_X
,
0 SSX_2_X
,
0 N_2_S
,
0 N_2_SS
FROM DBA_DATA_FILES
|
|
|