본문 바로가기

IT/Database

Oracle 11g Upgrade Oracle 11g Upgrade UNIX 더보기
오라클 테이블스페이스 사용량 조회 1. Redo Log Usage col MEMBER format a40 SELECT l.group#, l.bytes/(1024*1024) AS "MEGA", l.status, f.member FROM v$log l, v$logfile f WHERE l.group# = f.group#; 2. DATA Tablespace Usage SELECT A.TABLESPACE_NAME AS "TABLESPACE" , A.BYTES / 1024 / 1024 AS "TOTAL(MB)" , (A.BYTES - NVL(B.FREEBYTES,0)) / 1024 / 1024 AS "Used(MB)" , NVL(B.FREEBYTES,0) / 1024 / 1024 AS "Free(MB)" , ROUND(NVL(B.FREEBYTES.. 더보기
[ORACLE] opatch적용시 checkactivefilesandexecutables 발생 [대상] - Windows x64 - Oracle 11.2.0.3 [원인] - OPATCH version 11.2.0.3.0의 Bug 13902704 "SRVM.JAR IS LOCKED BY OPATCH 11.2.0.3.0" [해결방안] %ORACLE_HOME%\Opatch\jlib\oracle.opatch.classpath.jar -> oracle.opatch.classpath1.jar 로 수정 더보기
Note 1431798 - Oracle 11.2.0: Database Parameter Settings Symptom This note contains SAP's recommendations for the optimal configuration of Oracle Database Release 11.2. These parameter recommendations are relevant for all SAP products. This note will be updated regularly once a month. Beyond that, changes will only be made in exceptional cases for critical Oracle parameters. Change history: October 27, 2011: add WIN 11.2.0.1 to _OPTIMIZER_USE_CBQT_STA.. 더보기
SAP Notes 596423 Events and SPFILE Symptom This note describes how to set events when the Oracle database was started with SPFILE. Other terms event, events, init.ora, init.ora, SPFILE, parameter, Oracle 9i, server parameter fileReason and Prerequisites You are using Oracle 9i or higher and you are using the SPFILE (= binary server side parameter file) as parameter file.Solution (For further information on SPFILEs, see SAP Note 6.. 더보기
[ORACLE] ORA-02097, ORA-00439 Unable to restore resource manager plan to '': ORA-02097: 지정된 값이 부적당해서 매개변수를 수정할 수 없습니다 ORA-00439: 사용 가능한 기능이 아닙니다: Database resource manager Oracle 10g SE버전에서 RMAN을 사용할 수 없어서 발생하는 Alert Msg. 그냥 무시해도 무방하며, 10.2.0.3에서 Fix되었다. 보기 싫은 사람은 10.2.0.3이상으로 패치를 해주면 해결된다. 더보기