본문 바로가기

IT/Database

(6)
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..