'Tech_Info > SAP' 카테고리의 다른 글
SAP Bandwidth Test by SAP (0) | 2010.01.28 |
---|---|
SAP Database Patches (0) | 2010.01.22 |
SAP PAM (Product Availability Matrix) (0) | 2010.01.20 |
WIN7 에서의 SAP GUI호환성 - OK (0) | 2010.01.20 |
SAP TDMS Server (0) | 2010.01.15 |
SAP Bandwidth Test by SAP (0) | 2010.01.28 |
---|---|
SAP Database Patches (0) | 2010.01.22 |
SAP PAM (Product Availability Matrix) (0) | 2010.01.20 |
WIN7 에서의 SAP GUI호환성 - OK (0) | 2010.01.20 |
SAP TDMS Server (0) | 2010.01.15 |
Query designer 3.5 에서 쿼리 편집 시 제한 조건 선택하면 아래와 같은 에러 발생 (0) | 2009.11.25 |
---|---|
BW BEx 가 7.0으로 열리지 않고 3.1로 열릴때 (RRMX) (0) | 2009.11.12 |
HPUX] ftp user login failed (0) | 2007.04.12 |
crontab에 권한이 없다고 나올경우에는 생성해 주면 된다. (0) | 2007.04.03 |
Shell] 한달치의 nmon data를 매월 1일 마다 FTP서버로 옮겨놓기 (0) | 2007.03.05 |
SET PAGESIZE 50
COLUMN tablespace_name FORMAT a15 HEADING "TableSPace(KB)"
COLUMN total_size_kb FORMAT 999,999,999 HEADING "Total(KB)"
COLUMN free_size_kb FORMAT 99,999,999 HEADING "Free(KB)"
COLUMN used_size_kb FORMAT 999,999,999 HEADING "Used(KB)"
COLUMN usedpercentage FORMAT 999.99 HEADING "Used %"
COLUMN files FORMAT 99999 HEADING "Files"
COLUMN largest FORMAT 99,999,999 HEADING "Largest"
select
T.tablespace_name,
TS."total_size_b"/1024 as "total_size_kb",
NVL(FS."free_size_b"/1024, 0) as "free_size_kb",
NVL((TS."total_size_b"-FS."free_size_b")/1024, 0) as "used_size_kb",
NVL(Round(100 * ((TS."total_size_b"-FS."free_size_b") / TS."total_size_b"), 2), 0) as "usedpercentage",
TS."filecnt" as "files",
FS."maxfree" as "largest"
from
dba_tablespaces T,
(select tablespace_name, round (sum(bytes), 0) as "total_size_b",
count(file_name) as "filecnt"
from dba_data_files
group by tablespace_name) TS,
(select tablespace_name, round(sum(bytes), 0) as "free_size_b",
max(bytes)/1024 as "maxfree"
from dba_free_space
group by tablespace_name) FS
where
T.tablespace_name = TS.tablespace_name and
T.tablespace_name = FS.tablespace_name (+)
order by "usedpercentage" DESC;
by : DHKIM (사실 작자미상)
Shell] 한달치의 nmon data를 매월 1일 마다 FTP서버로 옮겨놓기 (0) | 2007.03.05 |
---|---|
[Solaris] /home 디렉토리에 디렉토리가 생성이 안되요. (0) | 2007.02.28 |
Data 이동작업 (0) | 2007.01.26 |
crontab 의 내용이 수행이 되지 않을때 (0) | 2007.01.23 |
터미널 서비스 막기 (0) | 2007.01.08 |
출처는 모르겠고, 예전회사에서 쓰던 Tablespace 사용량 확인하는 스크립트이다.
set pagesize 50
COLUMN tablespace_name FORMAT a15 HEADING "TableSPace(KB)"
COLUMN total_size_kb FORMAT 999,999,999 HEADING "Total(KB)"
COLUMN free_size_kb FORMAT 99,999,999 HEADING "Free(KB)"
COLUMN used_size_kb FORMAT 999,999,999 HEADING "Used(KB)"
COLUMN usedpercentage FORMAT 999.99 HEADING "Used %"
COLUMN files FORMAT 99999 HEADING "Files"
COLUMN largest FORMAT 99,999,999 HEADING "Largest"
select
T.tablespace_name,
TS."total_size_b"/1024 as "total_size_kb",
NVL(FS."free_size_b"/1024, 0) as "free_size_kb",
NVL((TS."total_size_b"-FS."free_size_b")/1024, 0) as "used_size_kb",
NVL(Round(100 * ((TS."total_size_b"-FS."free_size_b") / TS."total_size_b"), 2), 0) as "usedpercentage",
TS."filecnt" as "files",
FS."maxfree" as "largest"
from
dba_tablespaces T,
(select tablespace_name, round (sum(bytes), 0) as "total_size_b",
count(file_name) as "filecnt"
from dba_data_files
group by tablespace_name) TS,
(select tablespace_name, round(sum(bytes), 0) as "free_size_b",
max(bytes)/1024 as "maxfree"
from dba_free_space
group by tablespace_name) FS
where
T.tablespace_name = TS.tablespace_name and
T.tablespace_name = FS.tablespace_name (+)
order by "usedpercentage";
SQL Server Errorlog archive 개수 늘리기 (0) | 2006.06.26 |
---|---|
xp_cmdshell 삭제하기 (0) | 2006.06.26 |