This book is divided into 6 parts and consists of 32 chapters. Part 1: Basic database management, introduces the responsibilities of Oracle database administrators, creating Oracle databases, using Oracle-managed files, and how to start and shut down the database. Part 2: Oracle server process and storage structure, explaining in detail the management of Oracle processes, management of control files, management of online redo logs, management of job queues, management of table spaces, management of data files and undo space management. Part 3: Schema Objects, including managing schema object space, managing tables, managing indexes, managing partition tables and partition indexes, managing clusters, managing hashes, managing views, sequences and synonyms, general management, detection and repair of schema objects The data block is corrupted. Part 4: Database security, introduces the establishment of security policies, management of users and resources, management of user permissions and roles, and auditing the use of databases. Part 5: Database resource management, describes the use of database resource manager. Part 6: Management of distributed databases, focusing on the concept, management and development of distributed databases, and the concept and management of distributed transactions.
The book directory of "Oracle 9i Database Administrator's Guide (V9.0.1) (1CD)" is as follows:
-------------------------------------------------- ----------------------------------
Part 1, Basic Database Management
1. Oracle database administrator
2. Create Oracle database
3. Use files managed by Oracle
4. Starting and shutting down the database Part 2, Oracle server processes and storage structures
5. Manage Oracle processes
6. Management control files
7. Manage online redo logs
8. Manage archived redo logs
9. Use Logminer to analyze redo log files
10. Manage job queue
11. Manage table space
12. Manage data files
13. Managing Undo Space Part 3, Pattern Objects
14. Management mode object space
15. Management table
16. Manage index
17. Manage partition tables and partition indexes
18. Management cluster
19. Managing hash clusters
20. Manage views, sequences and synonyms
21. General management of schema objects
22. Detecting and Repairing Data Block Corruption Part 4, Database Security
23. Establish a security policy
24. Manage users and resources
25. Manage user permissions and roles
26. Use of audit database Part 5, Database resource management
27. Using Database Explorer Part 6, Management of Distributed Databases
28. The concept of distributed database
29. Manage distributed databases
30. Develop applications for distributed database systems
31. The concept of distributed transactions
32. Manage distributed transactions
Expand
