vypis tbs volny flek a.t.d.
set pagesize 2000;
column tablespace_name format a30;
select tablespace_name,
round(sum(tbs_bytes_total)/1024/1024,3) tot_MB,
round((sum(tbs_bytes_total)- SUM(tbs_bytes_free ))/1024/1024,2) used_MB,
round ((sum(tbs_bytes_total)- SUM(tbs_bytes_free )) *100
/ (sum(tbs_bytes_total)) ,2) used_percent
from
(SELECT tablespace_name, 0 tbs_bytes_total, SUM(bytes) tbs_bytes_free
FROM dba_free_space
GROUP BY tablespace_name
UNION
SELECT tablespace_name ,SUM(bytes) tbs_bytes_total, 0 tbs_bytes_free
FROM v$datafile_header
group by tablespace_name )
group by tablespace_name
order by used_percent desc;
-----------------------------------------------------
# Tablespaces datafiles
select file_name,bytes/1024/1024 from dba_data_files where tablespace_name like '
select file_name from dba_data_files where file_name like '
select file_name,bytes/1024/1024 from dba_temp_files where tablespace_name like 'TEMP';
set pagesize 5000
set linesize 110
col tablespace_name for a24
SELECT f.tablespace_name,f.MEGABYTES_FREE,d.MEGABYTES_TOTAL,ROUND(f.MEGABYTES_FREE/d.MEGABYTES_TOTAL*100,3) AS "still free [%]"
FROM
(SELECT tablespace_name, ROUND(sum(bytes)/(1024*1024)) MEGABYTES_FREE
FROM dba_free_space group by tablespace_name) f,
(SELECT tablespace_name, ROUND(sum(bytes)/(1024*1024)) MEGABYTES_TOTAL
FROM dba_data_files group by tablespace_name) d
WHERE f.tablespace_name=d.tablespace_name
ORDER BY "still free [%]";
------------------------------------------------------
set linesize 121
col file_name format a45
col tablespace_name format a20
SELECT file_name, tablespace_name,
bytes/1024/1024 MB, blocks
FROM dba_data_files
UNION ALL
SELECT file_name, tablespace_name,
bytes/1024/1024 MB, blocks
FROM dba_temp_files
ORDER BY tablespace_name, file_name;
----------------------------------------------------------
select df.file_name,round(df.bytes/1024/1024) TotalSize,fs.FreeSize
from dba_data_files df,
(select file_id,round(sum(bytes/1024/1024)) FreeSize
from dba_free_space
group by file_id
) fs
where df.file_id=fs.file_id(+)
order by 2,3 desc
Komentáře
Přehled komentářů
generic medications cialis https://krocialis.com/ - kamagranow cialis cut cialis in half
geeahdAdvorBtjSmeawb
(TymnSwa, 29. 5. 2021 6:33)cialis professional legitimate https://ckacialis.com/ - cialis online australia cialis online
comprar cialis online afhsdbcExcedsyxrsl
(Flamsloh, 26. 5. 2021 0:38)max dose of cialis https://rcialisgl.com/ - generic cialis fast shipping how long until cialis works
tadalafil 5 mg hvdgeeahdAdvorBtjSmeawj
(BbshTymn, 23. 5. 2021 7:34)best generic viagra https://loxviagra.com/ viagra vs sildenafil
what is cialis tadalafil 20 mg used for olgstnoegfdAdvorBtjSmeawt
(GtnbguefS, 17. 5. 2021 9:44)when was viagra invented https://jokviagra.com/ viagra cheap
was ist besser viagra oder fhwsbbolthdAdvorBtjSmeawx
(Fmrfscabs, 16. 5. 2021 3:51)10 mg generic cialis https://cialisee.com/ cialis online
viagra zasada dziaЕ‚ania fcsogsaxzvofbldAdvorBtjSmeawo
(Anooscabs, 16. 5. 2021 2:19)gold viagra from china https://llviagra.com/ intpharmacy.com viagra
people's pharmacy fdvaefbfbldAdvorBtjSmeawu
(Lebnscabs, 12. 5. 2021 21:55)online pharmacy china https://xlnpharmacy.com/ indianpharmacy com
canada drugs pharmacy frbdcacldAdvorBtjSmeawi
(Jebgscabs, 12. 5. 2021 20:48)canadian drugs pharmacies online https://pharmacylo.com/ publix pharmacy online ordering
cialis generika paypal afhsdbcExcedsqzayc
(RebfFlams, 10. 5. 2021 22:39)australia cialis on line https://rcialisgl.com/ cialis los angeles
viagra acting time fhwsbbolthdAdvorBtjSmeawd
(Fmrfscabs, 9. 5. 2021 12:31)cialis 20 mg dosage https://cialisee.com/ cialis with dapoxetine buy
canada cialis with dapoxetine afhsdbcExcedsasyos
(RebfFlams, 4. 5. 2021 0:34)viagra cialis trail pack https://rcialisgl.com/ canadian pharmacy cialis brand
tadalafil dosage bodybuilding olgsasbnvoegfdAdvorBtjSmeawq
(GvdbguefS, 1. 5. 2021 3:01)difference between tadalafil and cialis https://boxtadafil.com/ tadalafil combitic
reasors pharmacy afhdbcExcedslttyp
(RfvbFlams, 23. 4. 2021 5:39)viagra no prescription cialis https://cileve.com/ price of cialis
united healthcare pharmacy dgsolbvfdExcedsqzpre
(FlamsVed, 30. 5. 2021 17:56)