■SI Object Browser 掲示板

こんにちは
栗田@SIです。

ご返信が遅くなり、申し訳ございません
ご質問頂いた件についてですが、各画面の表示時には、
以下のSQLを発行しております。

よろしければ、こちらをSQLPlus等で実行頂き、
問題切り分けにご活用ください。

表領域タブ表示時:
SELECT D.TABLESPACE_NAME
,NVL
(U.BYTES
,0
)
,NVL
(U.MAXBYTES
,0
)
,NVL
(F.BYTES
,0
)
,D.STATUS
,D.CONTENTS
,NULL BLOCK_SIZE
,D.INITIAL_EXTENT
,D.NEXT_EXTENT
,D.MIN_EXTENTS
,D.MAX_EXTENTS
,D.PCT_INCREASE
,D.MIN_EXTLEN
,D.LOGGING
,D.EXTENT_MANAGEMENT
,D.ALLOCATION_TYPE
,D.PLUGGED_IN
,NULL SEGMENT_SPACE_MANAGEMENT
FROM DBA_TABLESPACES D
,
(
SELECT TABLESPACE_NAME
,SUM
(BYTES
) BYTES
,SUM
(MAXBYTES
) MAXBYTES
FROM DBA_DATA_FILES
GROUP BY TABLESPACE_NAME
) U
,
(
SELECT TABLESPACE_NAME
,SUM
(BYTES
) BYTES
FROM DBA_FREE_SPACE
GROUP BY TABLESPACE_NAME
) F
WHERE
(D.EXTENT_MANAGEMENT ＜＞
'LOCAL
'
OR D.CONTENTS ＜＞
'TEMPORARY
'
)
AND D.TABLESPACE_NAME = U.TABLESPACE_NAME(+)
AND D.TABLESPACE_NAME = F.TABLESPACE_NAME(+)
UNION ALL
SELECT D.TABLESPACE_NAME
,NVL
(U.BYTES
,0
)
,NVL
(U.MAXBYTES
,0
)
,NVL
(U.BYTES
,0
) - NVL
(F.BYTES
,0
)
,D.STATUS
,D.CONTENTS
,NULL BLOCK_SIZE
,D.INITIAL_EXTENT
,D.NEXT_EXTENT
,D.MIN_EXTENTS
,D.MAX_EXTENTS
,D.PCT_INCREASE
,D.MIN_EXTLEN
,D.LOGGING
,D.EXTENT_MANAGEMENT
,D.ALLOCATION_TYPE
,D.PLUGGED_IN
,NULL SEGMENT_SPACE_MANAGEMENT
FROM DBA_TABLESPACES D
,
(
SELECT TABLESPACE_NAME
,SUM
(BYTES
) BYTES
,SUM
(MAXBYTES
) MAXBYTES
FROM DBA_TEMP_FILES
GROUP BY TABLESPACE_NAME
) U
,
(
SELECT TABLESPACE_NAME
,SUM
(BYTES_CACHED
) BYTES
FROM V$TEMP_EXTENT_POOL
GROUP BY TABLESPACE_NAME
) F
WHERE D.EXTENT_MANAGEMENT =
'LOCAL
'
AND D.CONTENTS =
'TEMPORARY
'
AND D.TABLESPACE_NAME = U.TABLESPACE_NAME(+)
AND D.TABLESPACE_NAME = F.TABLESPACE_NAME(+)

データファイルタブ表示時:
SELECT D.FILE_NAME
,D.TABLESPACE_NAME
,D.BYTES
,D.MAXBYTES
,SUM
(S.BYTES
)
,T.STATUS
FROM DBA_DATA_FILES D
,DBA_FREE_SPACE S
,DBA_TABLESPACES T
WHERE D.FILE_ID = S.FILE_ID (+)
AND D.TABLESPACE_NAME = T.TABLESPACE_NAME
GROUP BY D.FILE_NAME
,D.TABLESPACE_NAME
,T.STATUS
,D.BYTES
,D.MAXBYTES
UNION ALL
SELECT D.FILE_NAME
,D.TABLESPACE_NAME
,D.BYTES
,D.MAXBYTES
,D.BYTES - NVL
(SUM
(S.BYTES_CACHED
)
,0
)
,T.STATUS
FROM DBA_TEMP_FILES D
,V$TEMP_EXTENT_POOL S
,DBA_TABLESPACES T
WHERE D.FILE_ID = S.FILE_ID (+)
AND D.TABLESPACE_NAME = T.TABLESPACE_NAME
GROUP BY D.FILE_NAME
,D.TABLESPACE_NAME
,T.STATUS
,D.BYTES
,D.MAXBYTES

※表示の都合上、"＜＞"を全角にしております。
置き換えてご利用ください。

何卒よろしくお願いいたします。