https://dbstudy.co.kr/w/index.php?action=history&feed=atom&title=%ED%98%84%ED%96%89_%EC%8B%9C%EC%8A%A4%ED%85%9C_%EB%B6%84%EC%84%9D%EC%84%9C 2026-05-09T00:02:43Z 이 문서의 편집 역사 MediaWiki 1.39.10 https://dbstudy.co.kr/w/index.php?title=%ED%98%84%ED%96%89_%EC%8B%9C%EC%8A%A4%ED%85%9C_%EB%B6%84%EC%84%9D%EC%84%9C&diff=1063&oldid=prev 2025-07-24T07:13:01Z

<p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="ko"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← 이전 판</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">2025년 7월 24일 (목) 16:13 판</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l20">20번째 줄:</td> <td colspan="2" class="diff-lineno">20번째 줄:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>4.2.3 DB 계정별 권한 13</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>4.2.3 DB 계정별 권한 13</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>4.3 오브젝트 보유 현황 22</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>4.3 오브젝트 보유 현황 22</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>4.3.1 <del style="font-weight: bold; text-decoration: none;">통합경영체관리(UNIFARM) </del>22</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>4.3.1 <ins style="font-weight: bold; text-decoration: none;">통합경영관리 </ins>22</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>4.3.2 <del style="font-weight: bold; text-decoration: none;">AgriX관리시스템(AGSA) </del>23</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>4.3.2 <ins style="font-weight: bold; text-decoration: none;">AX관리시스템 </ins>23</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">4.3.3 농지매매(AGSA3) 25</del></div></td><td colspan="2" class="diff-side-added"></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">4.3.4 비료품질관리(AGSA4) 27</del></div></td><td colspan="2" class="diff-side-added"></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">4.3.5 축산관리(SIDODB9I) 28</del></div></td><td colspan="2" class="diff-side-added"></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">4.3.6 모바일(MOBSITEDB) 28</del></div></td><td colspan="2" class="diff-side-added"></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">4.3.7 통계(AGST) 29</del></div></td><td colspan="2" class="diff-side-added"></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>4.4 테이블스페이스 현황 30</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>4.4 테이블스페이스 현황 30</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>4.5 데이터파일 현황 30</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>4.5 데이터파일 현황 30</div></td></tr> <tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l33">33번째 줄:</td> <td colspan="2" class="diff-lineno">28번째 줄:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>4.6.2 파티션 현황 31</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>4.6.2 파티션 현황 31</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>4.7 주요 DB Parameter 현황 41</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>4.7 주요 DB Parameter 현황 41</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>4.7.1 <del style="font-weight: bold; text-decoration: none;">통합경영체관리(UNIFARM) </del>41</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>4.7.1 <ins style="font-weight: bold; text-decoration: none;">통합경영관리 </ins>41</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>4.7.2 <del style="font-weight: bold; text-decoration: none;">AgriX관리시스템(AGSA) </del>42</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>4.7.2 <ins style="font-weight: bold; text-decoration: none;">AX관리시스템 </ins>42</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">4.7.3 농지매매(AGSA3) 42</del></div></td><td colspan="2" class="diff-side-added"></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">4.7.4 비료품질관리(AGSA4) 43</del></div></td><td colspan="2" class="diff-side-added"></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">4.7.5 축산관리(SIDODB9I) 44</del></div></td><td colspan="2" class="diff-side-added"></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">4.7.6 모바일(MOBSITEDB) 45</del></div></td><td colspan="2" class="diff-side-added"></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">4.7.7 통계(AGST) 45</del></div></td><td colspan="2" class="diff-side-added"></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>4.8 Network 현황 46</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>4.8 Network 현황 46</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>5. 데이터베이스 운영 현황 46</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>5. 데이터베이스 운영 현황 46</div></td></tr> </table>

Oracle https://dbstudy.co.kr/w/index.php?title=%ED%98%84%ED%96%89_%EC%8B%9C%EC%8A%A4%ED%85%9C_%EB%B6%84%EC%84%9D%EC%84%9C&diff=1062&oldid=prev 2025-07-24T07:11:27Z

<p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="ko"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← 이전 판</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">2025년 7월 24일 (목) 16:11 판</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">1번째 줄:</td> <td colspan="2" class="diff-lineno">1번째 줄:</td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>목  차</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">&#039;&#039;&#039;</ins>목  차<ins style="font-weight: bold; text-decoration: none;">&#039;&#039;&#039;</ins></div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div> </div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">&lt;pre&gt;</ins></div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>1. 개요 1</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>1. 개요 1</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>2. 데이터베이스 구성도 1</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>2. 데이터베이스 구성도 1</div></td></tr> <tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l51">51번째 줄:</td> <td colspan="2" class="diff-lineno">51번째 줄:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[별첨1] 현행 테이블스페이스 현황 50</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[별첨1] 현행 테이블스페이스 현황 50</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[별첨2] 현행 데이터파일 현황 50</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[별첨2] 현행 데이터파일 현황 50</div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">&lt;/pre></ins></div></td></tr> </table>

Oracle https://dbstudy.co.kr/w/index.php?title=%ED%98%84%ED%96%89_%EC%8B%9C%EC%8A%A4%ED%85%9C_%EB%B6%84%EC%84%9D%EC%84%9C&diff=1024&oldid=prev 2025-07-24T04:47:41Z

<p>새 문서: 목 차 1. 개요 1 2. 데이터베이스 구성도 1 2.1 논리 데이터베이스 구성 1 2.2 물리 데이터베이스 구성 2 2.2.1 H/W 구성도 2 2.2.2 데이터베이스 구성도 2 2.2.3 데이터 연계 3 3. 데이터베이스 기술 환경 3 3.1 서버 현황 3 3.2 DBMS 보유 현황 4 3.2.1 H/W 구성 4 3.2.2 S/W 구성 4 4. 데이터베이스 현황 4 4.1 데이터베이스 기본 정보 4 4.2 DB 계정 5 4.2.1 DB 계정 용도 5 4.2.2 DB Role 12 4.2.3 DB 계정...</p> <p><b>새 문서</b></p><div>목 차<br /> <br /> 1. 개요 1<br /> 2. 데이터베이스 구성도 1<br /> 2.1 논리 데이터베이스 구성 1<br /> 2.2 물리 데이터베이스 구성 2<br /> 2.2.1 H/W 구성도 2<br /> 2.2.2 데이터베이스 구성도 2<br /> 2.2.3 데이터 연계 3<br /> 3. 데이터베이스 기술 환경 3<br /> 3.1 서버 현황 3<br /> 3.2 DBMS 보유 현황 4<br /> 3.2.1 H/W 구성 4<br /> 3.2.2 S/W 구성 4<br /> 4. 데이터베이스 현황 4<br /> 4.1 데이터베이스 기본 정보 4<br /> 4.2 DB 계정 5<br /> 4.2.1 DB 계정 용도 5<br /> 4.2.2 DB Role 12<br /> 4.2.3 DB 계정별 권한 13<br /> 4.3 오브젝트 보유 현황 22<br /> 4.3.1 통합경영체관리(UNIFARM) 22<br /> 4.3.2 AgriX관리시스템(AGSA) 23<br /> 4.3.3 농지매매(AGSA3) 25<br /> 4.3.4 비료품질관리(AGSA4) 27<br /> 4.3.5 축산관리(SIDODB9I) 28<br /> 4.3.6 모바일(MOBSITEDB) 28<br /> 4.3.7 통계(AGST) 29<br /> 4.4 테이블스페이스 현황 30<br /> 4.5 데이터파일 현황 30<br /> 4.6 Segment 현황 30<br /> 4.6.1 Segment 사이즈(GB) 30<br /> 4.6.2 파티션 현황 31<br /> 4.7 주요 DB Parameter 현황 41<br /> 4.7.1 통합경영체관리(UNIFARM) 41<br /> 4.7.2 AgriX관리시스템(AGSA) 42<br /> 4.7.3 농지매매(AGSA3) 42<br /> 4.7.4 비료품질관리(AGSA4) 43<br /> 4.7.5 축산관리(SIDODB9I) 44<br /> 4.7.6 모바일(MOBSITEDB) 45<br /> 4.7.7 통계(AGST) 45<br /> 4.8 Network 현황 46<br /> 5. 데이터베이스 운영 현황 46<br /> 5.1 DBMS 관리 도구 보유 현황 46<br /> 5.2 데이터 암호화 현황 47<br /> 5.3 DBMS 백업 현황 47<br /> 5.4 통계 수집 현황 47<br /> 6. DB 계정 PROFILE 47<br /> 7. 현행 운영부서 요청사항 49<br /> 8. 개선 검토 사항 49<br /> [별첨1] 현행 테이블스페이스 현황 50<br /> [별첨2] 현행 데이터파일 현황 50</div>

Oracle