..

select name, value from v$parameter where name like '%service%';

select * from v$logfile; Status가 Stale 상태인 경우, 아래의 명령어를 이용하여 초기화 한다. alter database clear logfile '\REDO02.LOG'; 참조 : alter database 명령어 참조 http://blog.naver.com/rnarnsms73?Redirect=Log&logNo=40148983687 ========================================================================= alter system switch logfile;

-- 테이블 스페이스 파일 추가 alter tablespace TablespaceName add datafile '파일경로' size 3000M; -- 테이블 스페이스 용량 수정 alter database datafile '파일경로' resize 3000M;

sqlplus "/as sysdba" sql> alter user account identified by password; sql> alter user sys identified by 암호; sql> alter user system identified by 암호;

select B.TS_NAME as "TableSpace", TO_CHAR(SUM(NVL(A.TOT_BYTES/1024/1024,0)),'999,999,999,999') AS "전체용량(M)", TO_CHAR(SUM(NVL(A.TOT_BYTES/1024/1024,0))-SUM(NVL(B.TOT_BYTES/1024/1024,0)),'999,999,999,999') AS "사용한공간(M)", ROUND(((SUM(NVL(A.TOT_BYTES,0))-SUM(NVL(B.TOT_BYTES,0)))/SUM(A.TOT_BYTES))*100,1) AS "사용한공간(%)", TO_CHAR(SUM(NVL(B.TOT_BYTES/1024/1024,0)),'999,999,999..