-
Oracle DBMSDatabase & SQL 2019. 6. 22. 11:44
Oracle DBMS
• Oracle DBMS = Instance + Database
• Instance = SGA(메모리) + Background Processes (프로세스)
• SGA = Data Buffer Cache + Shared Pool + Large Pool + Java pool + Redo Log Buffer
• Process
- BackGround Process
- Server Process
- User Process
• Database = Data Files + Control Files + Redolog Files'Database & SQL' 카테고리의 다른 글
Index Scan vs Full Table Scan (0) 2019.06.29 Transaction Type (0) 2019.06.22 SQL 처리과정과 Parsisng , Shared SQL Area (0) 2019.06.22 SQL의 주요특징 (0) 2019.06.22 데이터 처리 방식에 따른 성능 편차 (0) 2019.06.22