 Меню сайта |
|
| Форма входа |
|
| Категории раздела |
|
| Поиск |
|
| Статистика |
Онлайн всего: 1 Гостей: 1 Пользователей: 0 |
|
| Приветствую Вас, Гость · RSS |
20.05.2024, 05:08 |
|
Список tablespace'ов и файлов с указанием свободного места
select
tablespace_name,
file_name,
free_bytes_in_file,
total_bytes_in_file,
round( free_bytes_in_file / total_bytes_in_file * 100, 1) percent_free_in_file,
free_bytes_in_ts,
total_bytes_in_ts,
round( free_bytes_in_ts / total_bytes_in_ts * 100) percent_free_in_ts,
AUTOEXTENSIBLE,
MAXBYTES,
INCREMENT_BY
from
(
select
df.tablespace_name,
df.file_name,
sum(NVL(fs.bytes, 0) ) free_bytes_in_file,
df.bytes total_bytes_in_file,
sum(sum(NVL(fs.bytes, 0) ) ) over (partition by df.tablespace_name) free_bytes_in_ts,
sum(NVL(df.bytes, 0) ) over (partition by df.tablespace_name) total_bytes_in_ts,
df.AUTOEXTENSIBLE,
df.MAXBYTES,
df.INCREMENT_BY
from
dba_free_space fs,
dba_data_files df
where
fs.file_id (+) = df.file_id
group by
df.tablespace_name,
df.file_name,
df.bytes,
df.AUTOEXTENSIBLE,
df.MAXBYTES,
df.INCREMENT_BY
)
order by
tablespace_name,
file_name
|
| Категория: Все про Oracle | Добавил: basil (31.05.2011)
|
| Просмотров: 508
| Рейтинг: 0.0/0 |
|
|
