Oracle database Intensive and Difficult Analysis (2nd edition)

Oracle Database Intensive and Difficult Analysis (2nd edition)

Zhaoping Editor

Isbn978-7-121-20021-2

published in April 2013

Price: 148.00 RMB

1100 Page

16 Open

Edit Recommendation

It took 3 years for the author to resign at home and concentrate on writing.

754 practice, pieces from the actual work experience and lessons, with a practical quick search catalogue

Share experience, now the author manages the database, by copying the contents of the book to fix the problem

Remove Oracle's veil for beginners, less detours

Provide quick search manuals for professionals, and do not beg for trouble

Content Summary

This book is an unreserved Oracle learning treasure. Through the author's 3 years of writing, this book describes Oracle installation and uninstall, database Startup/shutdown, table space and data file management, Oracle Network management, password file management, memory management, process management, user management, data import/export, backup and recovery, pattern object management, As well as application development and other related knowledge. The purpose of this book is to answer the questions that you encounter with Oracle and to demonstrate a great deal of skill in managing Oracle.

The 2nd edition of this book provides a more in-depth introduction to Oracle, adding content such as RAC (clustering), hugepage, synchronous I/O, asynchronous I/O, direct I/OS, memory file system, automatic storage Management (ASM). Each content is almost Oracle's advanced topic, and they take a different approach to Oracle's performance and are worth the reader's taste. In addition, a system introduction to RAC makes it easier for readers to understand and build their own Oracle clusters.

Directory

Article 1th create your own Oracle database

The 1th chapter knows Oracle's World--oracle Architecture 2

1.1 Oracle's Hair History 2

1.2 Database 3

1.3 Database management System (DBMS) 3

1.4 Concept of relational Databases (RDBMS) 3

1.4.1 Relational Database Model 4

1.4.2 Table 5

1.5 Oracle's overall framework structure 5

1.5.1 Oracle Instance (Oracle Instance) 6

1.5.2 Oracle's storage structure 7

1.6 Data Dictionary (Dictionary) 8

1.6.1 Data Dictionary Overview 8

Structure of the 1.6.2 data dictionary 8

Use of 1.6.3 data dictionary 8

2nd Chapter 1th Step--oracle Installation/Uninstall 10

Installation of 2.1 Oracle 10

Several concepts of 2.1.1 Oracle installation 10

2.1.2 Oracle 11g R2 (11.2) Installation--windows article 12

Installation of 2.1.3 Oracle 11g RAC--linux 27

2.1.4 Oracle Installation Troubleshooter 98

2.2 Oracle's Uninstall 123

2.2.1 Oracle Full Uninstall--windows Article 123

2.2.2 Oracle Full Uninstall--unix Article 128

The 3rd chapter has rice cooking--database creation and deletion 137

3.1 Creating a Database 137

3.1.1 Database Creation Overview 137

3.1.2 Solaris to create a database with DBCA 139

3.1.3 Diy--solaris Create a database by hand 149

Troubleshoot 3.1.4 Database Creation 155

3.2 Delete Database 164

3.2.1 Database Deletion Overview 164

3.2.2 Database Deletion--manual 165

3.2.3 Database Delete--DBCA Article 165

2nd Chapter Network Management

4th Chapter Oracle Network Management is not difficult 168

4.1 Oracle Network Architecture 168

Several network architectures for 4.1.1 Oracle Applications 168

4.1.2 Oracle Net 170

4.1.3 OSI Model 170

Stack structure for 4.1.4 Oracle NET 171

4.1.5 Oracle Listener 172

4.1.6 Connection descriptor (connect identifier) 173

4.1.7 Network Services name (NET service name) 174

4.1.8 Naming method 176

4.1.9 Tools for configuring Oracle Networks 176

4.2 Oracle Network Management Practice 176

4.2.1 Oracle network server-side configuration 176

4.2.2 Oracle Network Client Configuration 182

4.3 Oracle network Management Troubleshooting 187

4.3.1 Oracle network server-side configuration troubleshooting 187

4.3.2 Oracle Network Client Configuration Troubleshooting 194

4.3.3 Oracle Network and Firewall (Firewall) 215

3rd Article System Management

The 5th Chapter system housekeeper--sql*plus use 222

5.1 System Management Tool Sql*plus 222

5.2 SQL Buffers (SQL buffer) 223

Environment configuration for 5.3 Sql*plus 223

environment variable of 5.3.1 Sql*plus 223

5.3.2 Sql*plus Site Profile 223

5.3.3 Sql*plus User Profile 223

5.4 Sql*plus's boot 223

5.5 Sql*plus Proprietary Command Introduction 225

5.5.1 Login, Logoff command 225

5.5.2 Edit Command 225

5.5.3 Other Useful sql*plus command 227

Practice and difficult analysis of 5.6 Sql*plus 228

The 6th chapter and the beginning--the database starts and closes 247

6.1 Database Startup 247

6.1.1 Database Startup Principle 247

6.1.2 Database Startup Practice 248

6.1.3 Database Startup Troubleshooting 261

6.2 Database Shutdown 284

6.2.1 Database Shutdown principle 284

6.2.2 Database Shutdown (SHUTDOWN) Practice 284

6.2.3 Database Shutdown Troubleshooting 288

The 7th chapter is to clarify two mode problems--proprietary/shared server mode 292

7.1 Understanding proprietary Server Mode 292

7.2 Shared Server Mode principle 293

7.2.1 Shared Server schema 293

Relationship between the 7.2.2 listener and the scheduling process 293

7.2.3 Request queue (requester queue)/response queue (Response queue) 294

7.2.4 Scheduling Process (Dispatcher processes,dnnn) 294

7.2.5 Sharing Server process (Shared server processes,snnn) 294

7.3 Shared Server Mode practice 294

7.4 Shared server Mode troubleshooting 305

The 8th chapter grasps two management questions--the table space and the data file management 317

8.1 Database Storage Structure 317

8.1.1 Physical Structure 317

8.1.2 Logical Structure 320

8.2 Deep understanding of table space 327

8.2.1 Large File Table space 327

8.2.2 system table Space 327

8.2.3 Secondary Table Space 327

8.2.4 Rollback table Space (Undo tablespace) 327

8.2.5 Temporary table Space 330

8.2.6 table space Management mode in central 331

8.2.7 the middle of the table space management mode 332

8.2.8 Non-standard block table space 333

8.2.9 offline (Offline) and online 333

8.2.10 read-only table space (read-only tablespace) 333

8.3 Deep Understanding Data File 334

Contents of the 8.3.1 data file 334

8.3.2 Data file size (size) 334

8.3.3 Offline data File 334

8.3.4 Temporary data file (temporary datafiles) 334

8.4 Table space Management practice and difficult analysis 335

8.4.1 Permanent Table Space Management 335

8.4.2 Temporary table space management practice and difficult analysis 366

8.4.3 The space management practice and difficult analysis of the rollback table 373

8.5 Data file management practice and difficult analysis 379

8.5.1 Data File Management practice 379

8.5.2 data file Management troubleshooting 388

Chapter 9th Process Management 390

9.1 Oracle Process Introduction 390

9.2 User Process 391

9.3 Oracle Process 391

9.3.1 Server Process 391

9.3.2 Background Process 391

9.4 Process Integrated management practice and difficult analysis 395

9.5 Session Management practice and difficult analysis 403

Chapter 10th Memory Management 408

Introduction to 10.1 Oracle Memory Architecture 408

10.2 System Global Area (SGA) 409

10.2.1 SGA Profile 410

10.2.2 SGA Composition 411

10.3 Program Global Area (PGA) 414

10.3.1 Private SQL Area 414

10.3.2 SQL Workspace 415

10.3.3 User Global Area 415

10.4 Software Code Area 415

10.5 How Oracle Memory is managed 415

10.5.1 PGA Automatic Management 415

10.5.2 SGA Automatic Management 416

10.5.3 Automatic Memory Management 416

10.6 Memory management practices and troubleshooting 416

Chapter 11th User Management 439

11.1 User authentication 440

11.1.1 Password Authentication 440

11.1.2 External Certification 440

11.1.3 Global Certification 441

11.2 Oracle's Security Portal-permissions (privileges) 441

11.2.1 System Permissions 441

11.2.2 Object Permissions 444

11.3 Making permission management easier-Role 445

11.4 Limit User Resource Consumption-resource constraint file (profile) 446

11.4.1 level of resource limit 447

11.4.2 parameter 447 of the resource limit

11.5 User and Rights management practices and troubleshooting 448

11.5.1 User management practice and difficult analysis 448

11.5.2 Rights Management practice and difficult analysis 453

11.5.3 role management practice and difficult analysis 457

11.5.4 Resource Limited file management practice and difficult analysis 463

4th Mobile Database

12th Chapter Data Export 468

12.1 Data Export Method Introduction 468

12.1.1 Oracle Latest Export Tool--data Pump Export 468

12.1.2 Oracle Original Export Tool--export 468

12.2 Data Export Practice 471

12.3 Data Export Troubleshooting 489

13th Chapter Data Import 508

13.1 Introduction to Data import Method 508

13.1.1 Oracle Latest Import Tools--data Pump Import 508

13.1.2 Oracle's previous import method--import&nbs