search for books and compare prices
Tables of Contents for Oracle8 & Windows Nt Black Book
Chapter/Section Title
Page #
Page Count
Introduction
xxiii
Part 1 GETTING STARTED WITH ORACLE ON NT
1
320
Chapter 1 Oracle8 On Windows NT Architecture
3
28
From Oracle7 To Oracle8
5
1
From Unix To Windows NT
6
2
System Global Area
8
5
File Structures
13
4
Threads
17
8
Reading Information From The Database
25
2
Writing Information To The Database
27
1
Connecting To Oracle
28
1
Oracle Products For NT Servers
29
2
Chapter 2 Configuring An NT Server For Oracle8
31
28
Server Usage
33
1
Hardware
34
2
File Systems
36
3
Raw Partitions
39
1
Emergency Repair Disk
39
1
Networking
40
1
Windows NT Security
40
1
Workgroups And Domains
41
6
Practical Guide To Configuring An NT Server For Oracle8
47
12
Configuring A UPS
48
3
Creating An NT Repair Disk
51
2
Installing Network Protocols
53
1
Creating A Windows NT Account
54
2
Giving Administrator Privileges To A Windows NT Account
56
1
Changing Network Identification
57
2
Chapter 3 Installing Oracle8 On Windows NT
59
24
Preparing To Install Oracle8
61
1
Overview Of Oracle8 Products
62
4
Upgrading Or Migrating Existing Databases
66
1
Using Multiple Oracle Home Directories
67
1
Creating A Database During Oracle Installation
68
2
Practical Guide To Installing Oracle8 On Windows NT
70
13
Running The Installer
72
2
Selecting Products To Install
74
2
Creating A Starter Database
76
1
Completing Post-Installation Tasks
77
4
Installing Additional Products
81
2
Chapter 4 Administering The Windows NT Registry And Services
83
28
Introduction To The Windows NT Registry
85
4
Introduction To Windows NT Services
89
6
Oracle Services In The Registry
95
2
Practical Guide To Managing The Windows NT Registry And Services
97
14
Starting And Stopping Services From The Control Panel
98
1
Starting And Stopping Services From The Command Line
98
1
Configuring Automatic Service Startup
99
1
Starting And Stopping Remote Services
100
1
Installing Network Client Administrator Tools On An NT Workstation
101
2
Adding New Registry Values
103
1
Changing Existing Registry Values
104
1
Changing A Remote Registry
104
1
Securing Registry Entries
105
1
Auditing Registry Changes
106
2
Saving Registry Subkeys
108
3
Chapter 5 Administering NT User Accounts
111
32
Introduction To Windows NT Account Security
113
7
Configuring NT User Accounts For Oracle
120
3
Practical Guide To Administering NT User Accounts For Oracle
123
20
Creating User Accounts In The Local Domain
124
2
Changing A User's Group Membership
126
1
Limiting User Logon Hours
126
2
Restricting User Logons To Specific Workstations
128
1
Setting Account Expiration
128
1
Granting Dial-In Permissions
129
1
Creating Local Groups
129
1
Creating Global Groups
130
1
Changing A Personal Profile To A Roaming Profile
131
1
Creating Mandatory User Profiles
132
1
Assigning Profiles To Users
133
1
Managing User Passwords In A Domain
134
2
Sharing Folders
136
1
Mapping A Network Drive
137
1
Setting File And Folder Permissions
138
2
Creating A Policy For A Domain
140
3
Chapter 6 Oracle8 Performance Tuning On Windows NT
143
40
Performance Tuning: Where Do I Start?
145
3
Sources Of Performance Data
148
5
Tuning Windows NT For Oracle
153
1
Tuning Memory
153
11
Tuning I/O
164
5
Tuning: CPU Bottlenecks
169
2
Practical Guide To Monitoring Oracle8 On NT
171
12
Preparing Windows NT For Oracle8
172
4
Adjusting The Windows NT Paging File
176
1
Monitoring System Paging
177
2
Identifying Oracle Service Threads
179
4
Chapter 7 Administering The NT File System For Oracle8
183
38
Overview Of Disk Management
185
1
Disk Partitioning
185
3
Disk Formatting
188
3
Raw Partitions
191
1
File System Security
192
4
Windows NT Fault Tolerance (RAID)
196
7
Practical Guide To Administering The NT File System For Oracle8
203
18
Partitioning A Disk
204
2
Formatting A Partition
206
2
Setting Up A Raw Partition
208
1
Converting A Fat Partition To NTFS
208
1
Sharing A Directory
209
3
Setting Permissions On Files And Directories
212
2
Auditing A File
214
3
Establishing A Disk Mirror
217
1
Establishing A Stripe Set With Parity
218
3
Chapter 8 Configuring Net8, On Windows NT
221
52
What Is Net8?
223
2
Basic Net8 Architecture
225
5
Configuration Files
230
5
Starting And Stopping The Net8 Listener
235
2
Net8 Configuration Tools
237
2
Oracle Names
239
3
ODBC And Net8
242
1
Multithreaded Server
242
2
Connection Manager
244
4
Oracle Security Server
248
1
Advanced Networking Option
249
2
Practical Guide To Configuring Net8 On Windows NT
251
22
Configuring The Net8 Listener
252
3
Using Net8 Easy Config
255
2
Configuring And Testing The Oracle8 ODBC Driver
257
2
Using Net8 Assistant
259
2
Configuring Oracle Names
261
2
Registering The Net8 Listener With Oracle Names
263
1
Controlling The Client Cache Service
264
1
Configuring The Multithreaded Server
265
1
Testing the Multithreaded Server
266
2
Configuring Oracle Connection Manager
268
2
Configuring The Large Pool
270
3
Chapter 9 Creating A Custom Database
273
48
Introduction To Creating A Database
275
1
Configuring The Database Directories
276
9
Practical Guide To Creating A Custom Database
285
36
Creating A Database With The Oracle Database Assistant
286
12
Creating A Database Manually
298
12
Creating A Database From A Script
310
3
Mirroring Control Files
313
2
Mirroring Online Redo Logs
315
1
Configuring Redo Log Archiving
316
3
Compressing Archived Redo Log Files
319
2
Part 2 NEW FEATURES OF ORACLE8
321
164
Chapter 10 Oracle8 New Storage Features
323
50
New Storage Features--An Overview
325
1
Partitioning
326
1
Partitioned Tables
327
4
Partitioned Table Maintenance
331
2
Partitioned Indexes
333
2
Index Variations
335
3
Partitioned Index Maintenance
338
1
UNUSABLE Indexes
339
1
Reverse Key Indexes
340
2
Index-Organized Tables
342
1
Large Object (LOB) Support
343
4
Miscellaneous Datatype Enhancements
347
2
Practical Guide To Oracle8 Storage Features
349
24
Creating A Partitioned Table
350
4
Performing Table Partition Maintenance
354
7
Creating A Partitioned Index
361
3
Performing Index Partition Maintenance
364
1
Identifying And Correcting Unusable Indexes
365
2
Creating An Index-Organized Table
367
1
Using a BFILE
368
5
Chapter 11 Oracle8 Parallel Operations
373
24
Parallel Queries And DML
375
1
Architectural Overview
376
2
Parallel Queries
378
3
Parallel DML
381
7
Parallel Index Creation
388
1
LOGGING And NOLOGGING
389
1
Initialization Parameters Affecting Parallelism
390
1
Data Dictionary Views
391
2
Practical Guide To Parallel Operations
393
4
Issuing A Parallel UPDATE Statement
394
1
Creating And Rebuilding An Index In Parallel
395
2
Chapter 12 Oracle8 Object Extensions
397
36
Object Features Of Oracle8
399
1
A Traditional Data Model
400
3
Object Types
403
4
Collections
407
4
Manipulating Collection Elements
411
4
Object Tables
415
2
Member Methods
417
4
Comparison Methods
421
1
REFs
421
1
Object Views
422
2
Practical Guide To Using Object Extensions
424
9
Creating MAP And ORDER Methods
426
2
Working With REFs
428
2
Creating An Object View
430
3
Chapter 13 Oracle8 ROWIDs
433
24
Very Large Database (VLDB) Support
435
1
Oracle8 ROWIDs
436
7
ROWIDs And Indexes
443
1
ROWIDs And Row Chaining
444
2
The DBMS_ROWID Package
446
2
Interoperability And Migration Issues
448
3
Practical Guide To Working With ROWIDs
451
6
Identifying And Correcting Row Chaining
452
1
Translating Extended ROWIDs To Restricted ROWIDs
453
1
Checking And Converting Migrated ROWIDs
454
3
Chapter 14 Advanced Configurations
457
28
Optional Equipment
459
1
An Overview Of Clusters
459
3
Oracle8 Clusters And Windows NT
462
1
Oracle Parallel Server
463
3
Oracle Fail Safe
466
3
Oracle8 Replication
469
3
Oracle8 Replication Option
472
4
For More Information
476
1
Practical Guide To Using Replication Manager
477
8
Setting Up Master Sites
478
2
Using Multimaster Replication
480
1
Creating An Updatable Snapshot
481
4
Part 3 ADMINISTERING ORACLE8 WITH THE ORACLE ENTERPRISE MANAGER
485
314
Chapter 15 Configuring The Oracle Enterprise Manager
501
20
Introduction To The Oracle Enterprise Manager
489
5
Server Manager
494
1
A Closer Look At The OEM Console
495
4
Understanding Service Discovery
499
2
Practical Guide To Configuring The Oracle Enterprise Manager
501
20
Installing The Oracle Intelligent Agent
502
1
Configuring The Oracle Intelligent Agent
503
1
Building A Repository
504
2
Discovering New Network Services
506
3
Refreshing Network Services
509
1
Manually Configuring Network Services
510
2
Creating A Map
512
1
Changing The Background Bitmap
513
1
Setting Preferred Credentials
514
1
Setting Up Windows NT Accounts For Oracle Intelligent Agents
515
1
Recording SQL Statements In The Database Tools
516
2
Changing Database Connections In The Database Tools
518
3
Chapter 16 Managing Instance Startup And Shutdown
521
28
Overview Of Instance Startup And Shutdown
523
2
Introduction To Instance Startup/Shutdown Tools
525
2
Command-Line Startup/Shutdown
527
4
Practical Guide To Instance Startup And Shutdown
531
18
Starting An Instance
532
2
Stopping An Instance
534
4
Configuring Automatic Startup
538
1
Configuring Automatic Shutdown
539
3
Preventing An NT Workstation Shutdown Without A Logon
542
1
Disconnecting User Sessions Using The OEM Instance Manager
543
1
Disconnecting User Sessions Using An SQL Editing Tool
544
1
Restricting Types Of Sessions
544
1
Changing Initialization Parameter Values
545
3
Saving A Database Configuration
548
1
Chapter 17 Managing Database Space
549
36
Overview Of Database Objects
551
2
Rollback Segment Management
553
5
Reclaiming File System Space
558
1
Introduction To The OEM Storage Manager
559
4
Practical Guide To Managing Database Space
563
22
Creating Tablespaces
564
4
Removing Tablespaces
568
1
Adding Data Files To Tablespaces
569
1
Making Data Files Expandable
570
2
Resizing Existing Data Files
572
1
Relocating A Data File
573
2
Making A Tablespace Read-Only
575
1
Making A Read-Only Tablespace Read-Write
576
2
Adding Rollback Segments
578
2
Altering Rollback Segment Status
580
1
Shrinking Rollback Segments
581
2
Removing Rollback Segments
583
2
Chapter 18 Managing Database Objects
585
48
Overview Of Database Objects
587
13
Object Storage Options
600
2
Introduction To The Schema Manager
602
3
Practical Guide To Managing Database Objects
605
28
Creating Tables With the Crate Table Wizard
606
6
Creating Tables Manually In The Schema Manager
612
5
Altering Existing Tables
617
2
Creating Indexes
619
4
Rebuilding Indexes
623
2
Creating Synonyms
625
2
Creating Views
627
1
Creating Sequences
628
2
Dropping Objects
630
1
Deallocating Unused Space From Tables And Indexes
630
1
Emptying Tables
631
2
Chapter 19 Managing Database Security
633
52
Oracle Database Security Overview
635
1
Oracle User Accounts
636
3
System Privileges
639
7
Object Privileges
646
2
Roles
648
3
Profiles
651
4
Tablespace Quotas
655
1
Creating Database Administrator Accounts
656
3
Introduction To The Oracle Security Manager
659
4
Practical Guide To Managing Database Security
663
22
Creating Password-Verified Database User Accounts
664
4
Creating O/S-Authenticated User Accounts
668
2
Locking And Unlocking User Accounts
670
1
Changing A User's Password
671
1
Removing User Accounts
671
1
Creating Database-Authenticated Roles
672
2
Granting Database-Authenticated Roles To Users
674
1
Creating Windows NT-Authenticated Roles
675
1
Granting Roles And Privileges To Roles
676
1
Creating Resource Profiles
677
2
Enabling Resource Limit Checking
679
1
Creating Password-Authenticated DBA Accounts
679
1
Changing The INTERNAL Password
680
2
Creating Windows NT-Authenticated DBA Accounts
682
1
Encrypting Database Passwords
683
2
Chapter 20 Exporting, Importing, And Loading Oracle Data
685
40
Introduction To Exporting And Importing Oracle Data
687
9
Introduction To Loading Oracle Data
696
11
Introduction To The Oracle Data Manager
707
2
Practical Guide To Exporting, Importing, And Loading Oracle Data
709
16
Exporting From The Command Line
710
1
Exporting With The Data Manager
710
3
Scheduling Export Jobs From The OEM Console
713
2
Reorganizing A Table With Export/Import
715
3
Reorganizing A Database With Export/Import
718
2
Completing A Data Load With The Data Manager
720
1
Creating A Load Job In The OEM Console
721
4
Chapter 21 Managing Database Jobs And Events
725
28
Understanding Jobs And Events
727
3
Scheduling Jobs And Events With The OEM Console
730
3
Introduction To The Oracle Daemon Manager
733
1
Scheduling With The NT AT Command
734
2
Creating OraTCL Job Scripts
736
3
Practical Guide To Managing Database Jobs And Events
739
14
Scheduling Jobs With The OEM Console
740
2
Creating Jobs To Execute Custom TCL Scripts
742
1
Configuring Notification Services For Events
743
1
Defining Operators/Administrators For Events
743
2
Creating Event Sets
745
1
Registering Event Sets
746
2
Acknowledging Events In The OEM Console
748
1
Managing Pending Operations In The Communication Daemon
749
1
Setting Configuration Parameters For The Communication Daemon
750
3
Chapter 22 Backing Up An Oracle Database
753
46
Introduction To Backup And Recovery
755
5
Types Of Recovery
760
3
Backup Strategies
763
5
The Oracle Recovery Manager (RMAN)
768
3
The Oracle Backup Manager
771
1
The Oracle NT Backup Manager And NT Recovery Manager
772
2
The Legato Storage Manager
774
1
Selecting A Backup Type
774
3
Practical Guide To Backing Up An Oracle Database
777
22
Enabling Redo Log Archiving
778
1
Adding Redo Log Groups
779
2
Dropping Redo Log Groups
781
1
Adding Redo Log Members
782
1
Dropping Redo Log Members
783
1
Backing Up An Offline Database With Oracle NT Backup Manager (Cold Backup)
784
2
Backing Up An Online Database With Oracle NT Backup Manager (Hot Backup)
786
1
Completing A Hot Control File Backup
786
2
Configuring The Recovery Manager Recovery Catalog
788
1
Installing And Configuring The Legato Storage Manager
789
3
Backing Up A Database With Oracle Backup Manager
792
7
Index
799