https://www.adminschool.net/wiki/ 2026-04-22T04:59:50+00:00 https://www.adminschool.net/wiki/ https://www.adminschool.net/wiki/lib/exe/fetch.php?media=wiki:dokuwiki.svg text/html 2025-10-03T13:30:50+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adminschool.net/wiki/doku.php?id=dbms:oracle:10g:admin&rev=1759498250&do=diff Database Administration * Oracle 10g Directory Structure * HWM(HIGH Water Mark) * Direct Path Load * Oracle Server Side Callout Oracle Administrator SYSTEM * lock session 제어 * 오라클이 설치된 OS에서 / as sysdba 로 접속 막는방법 * 특정 머신에서 접속된 세션들 죽이기 * 오라클 서비스 포트 변경하기 SQL Query * Table 생성시기를 알아오는 쿼리 * 전체테이블 TRUNCATE하는 쿼리 만들기 * COMMENT를 이용한 테이블 정의를 출력해주는 쿼리 Management Query * 관리쿼리 01 * Oracle Etc * 잡다한거 DBA * datafile… text/html 2025-10-03T13:30:50+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adminschool.net/wiki/doku.php?id=dbms:oracle:10g:arch&rev=1759498250&do=diff Oracle Architecture Memory * 용어정의(9i기준) * 오라클 구조 * SGA(System Global Area) * PGA(Program Global Area) * Oracle Process * Oracle Dictionary * Oracle Dictionary View Disk * TABLESPACE * DATAFILE * Blocks * Extents * Segments Process * 오라클 SQL 처리과정 * Process Vs Session * remote database link text/html 2025-10-03T13:30:50+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adminschool.net/wiki/doku.php?id=dbms:oracle:10g:backuprecovery&rev=1759498250&do=diff Oracle Backup & Recovery export/import * 오라클 exp/imp * 오라클 Data Pump (expdp/impdp) 스크립트 예제 * oracle export scripts 예제 * oracle Datapump export scripts 예제 RMAN 스크립트 예제 * RMAN recovery catalog 예제 * RMAN backup scripts 예제 Flashback * Oracle Table Purge/Flashaback Method text/html 2025-10-03T13:30:50+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adminschool.net/wiki/doku.php?id=dbms:oracle:10g:devel&rev=1759498250&do=diff Oracle Development SQL * SQL*PLUS * 오라클 조인(Join)의 방법과 형태 * SQL/92 * SQL/99 PL/SQL * PL/SQL 기초 * Function * Procedure * Package * Trigger * Exception 기본함수 * Single Row Functions * Aggregate Functions * Grouping Rows 날짜함수 / 시간함수 * text/html 2025-10-03T13:30:50+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adminschool.net/wiki/doku.php?id=dbms:oracle:10g:grid&rev=1759498250&do=diff Grid Computing RAC(Real Application Clusters) * 오라클 RAC 관리 * Oracle CRS (Oracle Cluster Ready Services) text/html 2025-10-03T13:30:50+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adminschool.net/wiki/doku.php?id=dbms:oracle:10g:install&rev=1759498250&do=diff Oracle Installation Common * 오라클 환경변수 * Parameter File(init.ora,spfile.ora) * Oracle Parameter Installation * Install Oracle 11gR2(11.2.0) on Ubuntu Linux 16.04 (64bit) (2019.01.05) * Install Oracle 11gR2(11.2.0) on Ubuntu Linux 14.04 (64bit) (2016.04.13) * Install Oracle 11g on Ubuntu Linux 10.04 * Install Oracle 11g on Debian Linux (lenny) - (2010.07.04) * Install Oracle 10g on Debian Linux (etch) * Install Oracle 10g on Debian Linux (lenny) - (2010.01.20) * Install… text/html 2025-10-03T13:30:50+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adminschool.net/wiki/doku.php?id=dbms:oracle:10g:objects&rev=1759498250&do=diff Oracle Database Objects * INSTANCE * SCHEMA * INDEX * TABLE * VIEW * TRIGGER * SYNONYMS * CONSTRAINT * SEQUENCES * DATABASE LINK * DBMS_SCHEDULES * GRANT/ROLE text/html 2025-10-03T13:30:50+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adminschool.net/wiki/doku.php?id=dbms:oracle:10g:performance&rev=1759498250&do=diff Performance * OWI(Oracle Wait Event) text/html 2025-10-03T13:30:50+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adminschool.net/wiki/doku.php?id=dbms:oracle:10g:troubleshoot&rev=1759498250&do=diff Oracle Database Troubleshooting * 에러코드(ORA-*****) * Bugs and Issue(버그 및 이슈) * oradebug * SQL Trace * Oracle Block Dumps