반응형
10g까지(11g 이후에서도 사용 가능합니다.)
SQL> select value from v$parameter where name='background_dump_dest';
VALUE
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
/oratest/app/oracle/admin/kiupdev/bdump
11g 이후
SQL> select * from v$diag_info;
INST_ID NAME VALUE CON_ID
-------------- ---------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------
1 Diag Enabled TRUE 0
1 ADR Base /logs/oracle 0
1 ADR Home /logs/oracle/diag/rdbms/dbjcmt/DBJCMT 0
1 Diag Trace /logs/oracle/diag/rdbms/dbjcmt/DBJCMT/trace 0
1 Diag Alert /logs/oracle/diag/rdbms/dbjcmt/DBJCMT/alert 0
1 Diag Incident /logs/oracle/diag/rdbms/dbjcmt/DBJCMT/incident 0
1 Diag Cdump /logs/oracle/diag/rdbms/dbjcmt/DBJCMT/cdump 0
1 Health Monitor /logs/oracle/diag/rdbms/dbjcmt/DBJCMT/hm 0
1 Default Trace File /logs/oracle/diag/rdbms/dbjcmt/DBJCMT/trace/DBJCMT_ora_5104.trc 0
1 Active Problem Count 1 0
1 Active Incident Count 1 0
11 rows selected.
반응형
'Oracle > 운영' 카테고리의 다른 글
INDEX Rebuild시 parallel옵션 사용에 따른 degree확인 테스트(partitioned index 포함) (0) | 2022.05.03 |
---|---|
SQL*Loader 를 이용해서 리스너 로그 -> DB 테이블로 넣기 (0) | 2022.04.22 |
DML 이력 확인 딕셔너리뷰 (DBA_TAB_MODIFICATION) (0) | 2022.01.15 |
테이블의 Reorg 대상확인 프로시저(DBMS_SPACE.SPACE_USAGE) (0) | 2022.01.14 |
RESUMABLE_TIMEOUT 파라미터 (0) | 2022.01.05 |
댓글