Oracle Database 11g Database Management Art (covering all database management knowledge required by DBAs)

Oracle Database 11g Database Management Art (covering all database management knowledge required by DBAs)

Basic Information

Original Title: Expert Oracle Database 11G Administration
Original Publishing House: apress
Author: (US) Sam R. alapati
Translator: Zhong Ming; Yang Hua; Yang Weijun; Sun Dengfeng
Series name: Turing programming Series
Press: People's post and telecommunications Press
ISBN: 9787115227867
Mounting time:
Published on: February 1, June 2010
Start: 16
For more details, see: http://www.china-pub.com/196710
More wonderful sample free trial read: http://www.china-pub.com/ureader/product.asp? Bookid = 1, 196710

Introduction

This book targets most of the daily Oracle Database 11g database management tasks, comprehensively covers DBA industry knowledge, and combines theory with practice, aims to provide early and intermediate DBAs with all aspects of knowledge required for efficient database operation, help them find the information they need from a large volume of data released by Oracle. The content of this book is mainly focused on common problems of most enterprises, such as installing and upgrading the database software to the Oracle Database 11 GB, creating a database, exporting and importing data, backing up and restoring the database, and optimizing the performance.
This book also provides the necessary basic uniix, SQL, PL/SQL and Data Modeling knowledge for DBAs to complete their jobs. It also provides many interesting examples, the concepts and features of the Oracle database 11g database are described in detail and step by step through these instances.

Directory

Part 1 background knowledge, data modeling, Unix/Linux, and SQL * Plus
Chapter 2 World 2 of Oracle DBA
1.1 Oracle DBA Task 2
1.2 different DBA job categories 6
1.3 Database Type 6
1.4 Training and Certification 7
1.5 routine work of common Oracle DBA 12
1.6 Suggestions 12
Chapter 2 Relational Database Modeling and database design 14
2.1 relational database overview 14
2.2 relational database model 15
2.3 relational database lifecycle 17
2.4 Reverse Design Database 28
2.5 object-relational and object database 28
Chapter 3 Oracle DBA Unix/Linux basics 31
3.1 UNIX and Linux Operating System Overview 31
3.2 understand Unix shell 33
3.3 Access UNIX system 33
3.4 basic Unix Command overview 35
3.5 viewing files and directories in UNIX 42
3.6 use the VI editor to write files 46
......
Chapter 3 SQL * Plus and Oracle Enterprise Manager 73
4.1 start SQL * Plus session 73
4.2 Exit SQL * Plus 77
4.3 SQL * Plus and SQL command 77
4.4 SQL * Plus management command 87
4.5 key SQL * Plus "working" command 90
4.6 formatting SQL * Plus output and report creation command 93
......
Part 2 architecture, model, and transaction management of Oracle Database 11g
Chapter 2 Oracle Database 11g architecture 5th
5.1 Oracle database structure 128
5.2 Oracle process 139
5.3 Oracle memory structure 145
5.4 simple Oracle database transactions 153
5.5 submit and roll back 154
5.6 data consistency and concurrency 155
......
Chapter 4 manage tablespaces 6th
6.1 tablespace area size and space management 169
6.2 create a tablespace 172
6.3 temporary tablespace 181
6.4 default permanent tablespace 186
6.5 large file tablespace 187
6.6 sysaux tablespace management 189
......
Chapter 4 model management 7th
7.1 SQL statement Type 209
7.2 Oracle mode 211
7.3 Oracle table 212
7.4 Special Oracle table 222
7.5 Partition Table 225
7.6 manage the data dictionary view of a table 235
......
Chapter 2 Oracle Transaction Management 8th
8.1 Oracle transactions 272
8.2 features of transactions 274
8.3 transaction concurrency control 275
8.4 isolation level and ISO transaction standard 276
8.5 Oracle isolation level 278
8.6 implement Oracle concurrency control 280
......
Part 3 install and upgrade to Oracle Database 11 GB to create a database
Chapter 4 install and upgrade to Oracle Database 11g 9th
9.1 install Oracle 316
9.2 ofa 317
9.3 run the pre-installation task 323
9.4 final checklist for installation 334
9.5 task 341 after installation
9.6 uninstall Oracle 343
......
Chapter 4 Create an Oracle database 10th
10.1 prepare to create a database 359
10.2 create a parameter file 362
10.3 create a new database 383
10.4 use server parameter file 400
10.5 enable and disable database 403 from SQL * Plus
Part 4 connection and user management
Chapter 2 connection and network 11th
11.1 Oracle network and database connection 414
11.2 network concept: How Oracle networks work 415
11.3 establish an oracle connection 418
11.4 Oracle client 419
11.5 Instant Client 421
11.6 listener and connection 421
11.7 naming and connection 425
11.8 Oracle and Java database connection 437
Chapter 4 user management and database security 12th
12.1 Manage Users 441
12.2 database resource manager 450
12.3 control database access 461
12.4 audit database usage 477
12.5 Authenticated Users 485
12.6 enterprise user security 491
12.7 Data Security notice 497
Part 5 data loading, backup, and recovery
Chapter 4 loading and transforming data 13th
13.1 overview of extraction, conversion, and loading 508
13.2 use SQL * loader utility 509
13.3 use external tables to load data 524
13.4 convert data 533
13.5 use ORACLE stream replication and sharing information 545
Chapter 4 Export and Import using a Data Pump 14th
14.1 introduction to Data Pump Technology 549
14.2 perform data pump export and import 557
14.3 Monitoring Data Pump Operation 578
14.4 Use Data Pump API 580
14.5 portable tablespace 581
Chapter 2 backup database 15th
15.1 back up Oracle Database 587
15.2 flash recovery zone 594
15.3 recovery manager 600
15.4 backup control file 636
15.5 Oracle Secure Backup 637
15.6 user-managed backup 640
15.7 database Crash Detection 645
15.8 enhanced data protection for disaster recovery 647
Chapter 4 database restoration 16th
16.1 database fault type 650
16.2 Oracle recovery process 652
16.3 restore with RMAN 657
16.4 typical media recovery solution 661
16.5 data recovery consultant 674
16.6 clone a database 678
16.7 granularity Recovery Technology 683
16.8 flash back technology and recovery 689
......
Part 6 Oracle Database Management
Chapter 4 automatic management and online functions 17th
17.1 automatic database diagnostic monitor (ADDM) 714
17.2 Automatic Memory Management 728
17.3 automatic optimizer statistics collection 732
17.4 Automatic Storage Management 734
17.5 automatic space management 752
17.6 Oracle Database 11g online functions 762
Chapter 4 managing and monitoring running databases 18th
18.1 Oracle Performance Statistics type 773
18.2 server-generated warning 777
18.3 baseline measurement and adaptive threshold 779
18.4 AWR 783
18.5 ash 793
18.6 management consultancy framework 797
18.7 use of withdrawal and MTTR consultancy 801
18.8 managing online redo logs 802
......
Part 7 Performance Tuning
Chapter 4 improving database performance: SQL query
Optimized by 852
19.1 Oracle Performance Tuning Method 852
19.2 Oracle query optimization 853
19.3 query optimization and Oracle CBO 857
19.4 write efficient SQL 872
19.5 how does DBA help improve SQL processing 881
19.6 SQL Plan Management 885
......
Chapter 2 Oracle performance optimization: instance optimization 20th
20.1 instance optimization overview 927
20.2 automatic performance tuning and dynamic performance view 929
20.3 Oracle memory optimization 929
20.4 System Performance Evaluation 947
20.5 measure I/O performance 952
20.6 instance performance measurement 954
20.7 a simple method for instance optimization 982
Appendix A Oracle Database 11g SQL and PL/SQL basics 1005