Jdi na obsah Jdi na menu
 


vypis tbs volny flek a.t.d.

2. 2. 2010

 

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řidat komentář

Přehled komentářů

united healthcare pharmacy dgsolbvfdExcedsqzpre

(FlamsVed, 30. 5. 2021 17:56)

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