2013/10/23 ws2 memo

* architecture

- memory 1. SGA

  2. PGA

- process 1. user process

   2. server process

   3. background process

   4. 기타

- storage  1. physical - database - redo log file

                  - control file

                  - data file

                   - other files - parameter file

            - password file

                  - diagnostic file

      - archieved log file

      - backup file

   2. logical - tablespace -segment- extent- block

* oracle database server?  = database+instance

            ---------

* block ( default = 8k) : 2k, 4k, 8k, 16k,32k 중 하나로 설정할수있다.

* datafile - meta data, user data

* sysaux

* ADDM ( automatic database diagnostic monitor_) 

: http://blog.naver.com/thanycall?Redirect=Log&logNo=100146388152

============================================================================================================================

* backup (복사?)

* resore (복원)

* recovery (복구)

* failure 유형 + downtime

* backup 

- logical : export, datapump

- physical : OS, RMAN

+ 3rd party

* restore : 파일을 원래 위치고 갖다두는것.

* recovery (restore -> redo)

- complete recovery

- incomplete recovery

: 필요에 의한복구

============================================================================================================================

* tablespace -> container

* segment -> space occupying object

* extent -> continuos block

* blck -> storage와 i/o 의 최소단위

database    ------- 

|                   |

tablespace --    datafile

|                   |

segment               |

|                   |

extent >----------|

|                   |

block  >------- os page

============================================================================================================================

col file_name format a50

col segment_name format a30

select tablespace_name, file_name from dba_data_files;

select segment_name, segment_type, extents, blocks

from dba_segments

where owner = 'SH'

and segment_name = 'TIMES;l

select segment_name, extent_id, block_id, blocks

from dba_extents

where owner = 'SH'

and segment_name = 'TIMES';

select *

from dba_free_space

============================================================================================================================

* space 관리

- ASM (storage) vs file system, row device

- OMF (file) vs UMF

database area -> show parameter db_create

recovery area -> show parameter db_recovery

alter system set db_create_file_dest = '/u01/app/oraccle/oradata/jydb/';

-> create tablespace 시에 지정한 parameter 로 들어감 ㅇㅇ

alter system set db_create_online_log_dest_1 =  '/u01/app/oraccle/oradata/jydb/';

alter system set db_create_online_log_dest_2 =  '/u01/app/oraccle/oradata/jydb/';

create tablespace ts1;

drop tablespace ts1;

- LMT (extent) vs DMF

- ASSM (block) vs MSSM(FLM)