SG Review All (all SG overview)

1. SQL Basics

Go to the check-gaps phase

2. PL/SQL

Enter the practice stage

3. Fundamental 1

This part is still more important.

Architecture

Database Startup and shutdown steps

instance and parameter file

Create DATABASE Manual and DBCA

Comparison of commonly used data dictionaries

Multiplexing of control file

Redo log File structure

Tablespace & DataFile Features

Characteristics of storage such as physical blocks

Structure and characteristics of undo

Manage Tables Table

Manage Indexes

Manage Data consistency

Managing password file and resources

Manage Users and Permissions

Globalization support, Character set, Time type

4. Fundamental 2

Network

Set the database to archive mode

Backup

Export & Import

Loading Data Tool

5. Tuningapplication Tuning

(mostly SQL) main use tool: Autotrace, 10046 Event

Database schema design, with what table, what field, what index

DBA Tuning

(Set parameters, etc.) main use tool Statspack (Alertlog, tracefile)

In this part, the individual believes that the need is: (The following sections, will be used as a thematic experiment to test)

(1) If a table is too large, you need to dump part of the data

(2) Undo table space problems, such as full

(3) Deadlock problem, latch

(4) Wait event (combined with Statspack Top 5, then check online for specific)

(5) After 11g, the parameters that really need to be set by the DBA are very few, so the tuning of the setting parameters is not confirmed.

System Administrator Tuning

(Physical storage, I/O)

SG Review All (all SG overview)