Oracle Enterprise Manager
ü α ͵ 踦 ľϿ ̺ ϴ Ϳ ̺ (帧) ľϿ ϴ α ü Ȱ ϵ
Ŭ ̽ Ű ϰ ̽ ̽ ϴ ϰ, ϵ.
̽ ҿ Ʃ ϰ ڷμ ̽ ֵ Ѵ 2.
1) Ŭ SQL Ȱ
2) Ŭ α
3) PL/SQL Ȱ ǹ Ʈ
4) ̽ Ʈ
5) Ŭ Ű
6) Ÿ̽ ŴƮ
7) Ÿ̽
8) Ÿ̽ Ʃ
9) Ʈ3. ð
- Ⱓ: 10 (2010.07.27 ~ 2010.10.07) - ð: (~) : 09:00 ~ 16:00 - : 50 (Ѿ 250 200 , ںδ 50 ) / ſ 11 * 4 (ĺ& )- ο: 15 ()- 300ð/ 10 .
4. Ư- ü 輾 η ġ ȭ- ڷ (հݷ 90% ̻) - OCP- Oracle .(EVENTⰣ: ٿó ) - OCP 5. α Ŀŧ
Ŭ SQL Ȱ
[DBMS ]
ü- ̽ , Oracle ġ
[SELECT Լ Ȱ]
Selection(ڸ ) Լ Ȱ
[]
(̺ //) Ӽ
[ ]
Join(eque/outer/self/cross)
[DML ɰ TCL ]
Insert / update / delete , Transaction ɾ
[Ŭ ü Ȱ ]
Sequence , Index , View , /Role , , Synonym
Ŭ α
[PL/SQL ⺻]
PL/SQL
[Cursor]
Cursor Ȱ
[Procedure]
Procedure ü Ȱ
[Function]
Function ü Ȱ
[Trigger]
Trigger ü Ȱ
[Exception]
Ÿ ó Ȱ
PL/SQL Ȱ ǹ Ʈ
[Ʈ ȹ]
ľǰ α ü ȹ
[Ʈ ]
ľǰ α ü α
ǹ ̽ α
̽ Ʈ
[ ]
// ̽
[ 帧]
Ʈ
ȭ (1ȭ, 2ȭ, 3ȭ, ȭ)
[ER ̾ ]
ER ̾ , ER-WIN , ER-WIN ü
[Ʈ ȹ ]
м ü ȹ
ǹ ̽ α , Ʈ ý
Ŭ Ű
[ͺ̽ ]
Database
[ ۰ ]
Instance ۿ
Database File ʱ Ķ/ȣ
Ÿ̽ ŴƮ
Control file , Redolog file , Data file (Data & Undo& Temp file)
Locally Tablespace / Extent & Block
[Data Migrantion]
Row Migrantion
[SQLLDR]
SQL*Loader
[Export & Import]
Export & Import Utility
" , Role & Privilege , "
Ÿ̽
[NoArchivelog mode ]
Offline Backup, ̽ (NoArchivelog mode)
[Archivelog mode ȯ ]
Archivelog mode ȯ / Full Database Recovery, Online Backup Recovery, Temp tablespace
[ ҿ ]
Complete() Database recovery/ ð ҿ , Ʈ
[б ]
Read-Only
Ÿ̽ Ʃ
[Ʃ ]
Ʃ , α , ý
[νϽ Ʃ]
, Data Dictionary cache Ʃ, Library cache Ʃ
[ũ Ʃ]
I/O Ʃ(ũ ü), Block ȭ
[ȭ ]
۾ Ʃ(Application tuning), Optimizer mode
[ü м LOCK ]
Index Ʃ, Ÿ ü ̿ Ʃ(Analyzeɾ) ,LOCK
[SQL м Ʃ]
Explain Plan (ȹ)
[DBA ÿ Ʈ ȹ]
̽ м ȹ
м ȹ
ǹ ̽ , Ʈ ý
Ȩ : http://eduhanbit.co.krȭ : 02-702-0592