장기기억장치

# index 확인--script로 사용시 주석 없앨 것.column INDEX_NAME heading "TYPE : INDEX_NAME" format a42column "UQ" format a2column column_name format a20column ordinal heading "ORD" format 99column descend heading "DESC" format a4column column_emp format a30--set verify off--set echo off--set feedback off--set serveroutput on--set pagesize 999--set linesize 200--break on index_name skip 1--prompt--accept tnam..

RMAN으로 대상 DB를 접속한 후에 수행 예시 > rman target / catalog sys/manager@# tablespace backup RMAN> run { allocate channel c1 type disk; backup tag tbs_ format '/tbs__t%t_s%s' (tablepsace ); release channel c1; } # tablespace 백업 확인 RMAN> list backupset of tablepsace users; # tablespace 복구 RMAN> run { allocate channel c1 type disk; sql "alter tablespace users offline immediate"; restore tablespace users; re..

https://neo-orcl.tistory.com/53 Replace OCR, votedisk to ASM Disk Groupdata DG에서 ocrvote DG로 OCR과 votedisk를 옮기는 작업로그이다. ocrvote DG를 normal redundancy로 3ea 디스크를 1g씩 넣어서 만들었다. [root@mid1 disk]# crsctl query css votedisk ## STATE File Universal..neo-orcl.tistory.com # /u01/app/11.2.0/grid/log/rac1/alertrac1.log 2019-11-18 16:45:44.402: [  OCRASM][71276288]proprasmo: Error in open/create file in dg ..

1. 리눅스 설치 및 구성https://drive.google.com/file/d/18fuIOicvvpnwWUUkaLJ-iybYIKlQ6u94/view?usp=sharing Oracle Database 11g RAC_6장_리눅스 설치 및 구성.pdf drive.google.com2. 그리드인프라스트럭처 설치https://drive.google.com/file/d/1HDgOSBlmePZSSM7csrib07qvYrf7fwiG/view?usp=sharing Oracle Database 11g RAC_7장_그리드 인프라스트럭처 설치.pdf drive.google.com3. RDBMS 설치 & DBCAhttps://drive.google.com/file/d/1mhc-FRIVu1lwRgQOiWC5-mykbYtLVx..

SQL> select table_name from dictionary order by table_name;     TABLE_NAME -------------------------------------------------------------------------------- ALL$OLAP2_AWS ALL_ALL_TABLES ALL_ANALYTIC_VIEWS ALL_ANALYTIC_VIEW_ATTR_CLASS ALL_ANALYTIC_VIEW_BASE_MEAS ALL_ANALYTIC_VIEW_CALC_MEAS ALL_ANALYTIC_VIEW_CLASS ALL_ANALYTIC_VIEW_COLUMNS ALL_ANALYTIC_VIEW_DIMENSIONS ALL_ANALYTIC_VIEW_DIM_CLASS AL..

https://docs.google.com/presentation/d/1Y7Hc29-vJXfPuMiuX32g4zLTE90cA50_/edit#slide=id.p1 Shared pool 프레젠테이션_v2.2.pptx drive.google.com엑셈 면접 때 준비했던 Shared Pool 관련 내용입니다.