Oracle database management

1. Data dictionary and control file
By querying the data dictionary, you can query the relevant information of the data .
Common data dictionary table —
Data field format output –
Dynamic performance table V$start Control files are important to back up 2. Redo log file Redo log files are used for recovery in case of database crash . Query redo log file V$log and V$logfile
3. Table space and data file management
Logical structure database > Table space > paragraph > section > Data blocks
The data block has multiple tablespaces A table space consists of one or more data files , Each data file can only belong to one tablespace , A table space can only belong to one database .
Table spaces are divided into system table spaces and non system table spaces
Tablespace related statements — To be improved
4. Storage structures and their direct relationship
database > Table space > paragraph > section > Data blocks
5. Manage restore data
DML Before the operation is submitted , The data of the previous data will be copied to the restore section , When querying, the data before submission is queried .
The purpose of the restore section ： Transaction rollback Transaction recovery Ensure data reading consistency .
6. Create database
Use the installer to create Use the database configuration assistant to create Use Create... By hand
7. Table management and maintenance
Create table — Sentences to be improved
8. Index management and maintenance
Indexes — In order to improve the query efficiency
9. Manage and maintain data integrity
Integrity constraint type ：
Non empty constraint Unique constraint Primary key constraint Foreign key constraints Conditionality
10. Security management of users and system resources
Create user Delete user password management
11. Administrative authority
It is divided into system permission and object permission
Grant authority Recycling permissions
12. Management roles
A role is a collection of permissions
Create the role Permission recycling of roles Delete the role
13. Cold backup and recovery in non archive mode
Cold backup is also called offline or shutdown backup
Offline backup data block Just copy
14. Archive Mode of data block
Generate archive files That is, redo the log file
Set the data block to file mode
15. Online backup of database is also called hot backup It is the backup when the database is started
16. Database recovery in archive mode – Do not ask
17. Database movement
Database import and export
You can guide by user By table to Derive from table space Import by entire database
18. Flashback technology of database
When a table is deleted Not really delete But in the recycle bin You can recover
19. Design Program and memory optimization
20.I/O Optimize
Find the most performance consuming statement
22. Enterprise manager EM Website management
AWR The report
23.SQL Statement tracking and optimization

Focus on mastering ：
1. Architecture
2. The data dictionary
3. Table space management
4. Import export database
5. Backup of database
6.AWR The report
7. Database performance optimization