|
최길호
[LIST]
|
2013-04-13 09:46:55, 조회 : 2,783 |
select 'alter tablespace '||t.name||' alter datafile '''||f.name||''' autoextend on
next 200m maxsize unlimited;'
from v$datafiles f, v$tablespaces t where f.spaceid=t.id;
select * from x$stable_mem_datafiles;
-- 용량 확인
set vertical on;
SELECT
UF.NAME SPACENAME,
ROUND(DF.MAXSIZE, 3)||' MB' MAXSIZE ,
ROUND(DF.CURRSIZE, 3)||' MB' CURRSIZE ,
NVL(to_char(ROUND(UF.ALLOCATED_PAGE_COUNT*8/1024,3)),'N/A')||' MB' USEDSIZE
FROM
(SELECT
SUM(MAXSIZE)*8/1024 MAXSIZE ,
SUM(CURRSIZE)*8/1024 CURRSIZE ,
SPACEID
FROM
V$DATAFILES
GROUP BY SPACEID) DF , V$TABLESPACES UF
where DF.SPACEID = UF.ID
UNION ALL
SELECT
'SYS_TBS_MEMORY' SPACENAME,
ROUND(MEM_MAX_DB_SIZE/1024/1024,3)||' MB' MAXSIZE,
ROUND(MEM_ALLOC_PAGE_COUNT*32/1024,3)||' MB' CURRSIZE,
TO_CHAR(ROUND(MEM_ALLOC_PAGE_COUNT*32/1024,3))||' MB' USEDSIZE
FROM
V$DATABASE
ORDER BY 1;
-- 출처 : http://support2.dbworks.co.kr/index.php?mid=b_other_databases&page=3&listStyle=gallery&document_srl=1110 |
3.235.78.122
|
|
06/29 