안녕하세요. . 이런경우를 처음봐서 혹시 아시는분이 계신지 질문 올립니다.

요지는 dba_data_files의 file_id 와 dba_free_space 의 file_id를 조인해서

테이블 스페이스의 사이즈 산정을 위한 쿼리였고  실제 dba_data_files에는 33개의 파일이 있는데

dba_Free_space에는 27개의 파일만 보이네요.  

보기쉽게 file_id를 outer join으로 해서 확인하면 아래 6개의 파일이 안보이는것을 확인 할 수 있습니다.

데이터 파일 모두 status가 enable  상태이고 실제 online_status 도 online 상태 입니다.

TABLESPACE_NAME                TABLESPACE_NAME                   FILE_ID    FILE_ID
------------------------------ ------------------------------ ---------- ----------
LOG                            LOG                                    30         30
LOG                            LOG                                    42         42
LOG                            LOG                                    43         43
LOG                            LOG                                     5          5
LOG                            LOG                                    47         47
LOG                            LOG                                     8          8
LOG                            LOG                                    31         31
LOG                            LOG                                    38         38
LOG                            LOG                                    46         46
LOG                            LOG                                    33         33
LOG                            LOG                                    35         35
TABLESPACE_NAME                TABLESPACE_NAME                   FILE_ID    FILE_ID
------------------------------ ------------------------------ ---------- ----------
LOG                            LOG                                    40         40
LOG                            LOG                                    41         41
LOG                            LOG                                    49         49
LOG                            LOG                                    50         50
LOG                            LOG                                     6          6
LOG                            LOG                                    32         32
LOG                            LOG                                    34         34
LOG                            LOG                                    37         37
LOG                            LOG                                    36         36
LOG                            LOG                                    44         44
LOG                            LOG                                    52         52
TABLESPACE_NAME                TABLESPACE_NAME                   FILE_ID    FILE_ID
------------------------------ ------------------------------ ---------- ----------
LOG                            LOG                                    39         39
LOG                            LOG                                    45         45
LOG                            LOG                                    48         48
LOG                            LOG                                    51         51
LOG                            LOG                                     7          7
LOG                                                                   10
LOG                                                                   12
LOG                                                                   14
LOG                                                                    9
LOG                                                                   13
LOG                                                                   11