See Data Pump
Oracle Enterprise Manager (OEM), 42
job control and monitoring, 200??“206
Oracle Identity Management (IM), 286??“287
Oracle Internet Directory
directory naming, 534??“537
replacing tnsnames.ora with, 517
Oracle Managed Files (OMF), 6, 29
initialization parameters, 178
managing space with, 177??“178
using for undo tablespaces, 215
Oracle Net
connect descriptors, 515??“516
controlling the listener server process,
528??“531
database links, 538??“539
debugging connection problems,
541??“542
directory naming with Oracle Internet
Directory, 534??“537
Directory Usage Configuration,
524??“525
easy connect naming, 537??“538
limiting resource usage, 541
Listener Control utility commands,
529??“530
listeners, 517??“520, 521??“522
Local Net Service Name
Configuration, 523
naming methods configuration, 523
net service names, 516??“517
Oracle Connection Manager, 531??“534
Oracle Net Configuration Assistant,
520??“525
Oracle Net Manager, 525??“527
overview, 512??“515
replacing tnsnames.ora with Oracle
Internet Directory, 517
starting the listener server process,
527??“528
tuning, 540??“542
Oracle Network Configuration
Assistant, 376
Oracle Streams, 42
Oracle System Identifier (SID), 640
Oracle Technology Network (OTN), 637
Oracle Universal Installer (OUI), 638
OS space management, 197
OTN. See Oracle Technology
Network (OTN)
OUI. See Oracle Universal Installer (OUI)
P
package development, 160
acceptance test procedures, 162
data requirements, 161
execution plans, 161??“162
generating diagrams, 160
security requirements, 161
Index 663
space requirements, 160
testing, 162
tuning goals, 161
version requirements, 161
packages, 23
Parallel Query, and distribution of CPU
requirements, 244
parallelism, 131, 244??“245
partition elimination, 130
partition keys, 14
partitioned indexes, 15
partitioned tables, 14??“15, 557
application-controlled (system)
partitioning, 570
coalescing table partitions, 579??“580
composite list-hash, list-list, and listrange
partitioning, 565??“566
composite range-hash partitioning,
561??“563
composite range-list partitioning,
563??“565
composite range-range partitioning,
566??“567
compressed partitioned tables, 571
creating, 557
hash partitioning, 560??“561
indexing partitions, 571??“575
interval partitioning, 567??“569
list partitioning, 561
maintaining index partitions, 580
maintaining table partitions, 576??“577
managing with EM Database Control,
582??“588
merging partitions, 580
range partitioning, 557??“559
reference partitioning, 569??“570
renaming local index partitions,
581??“582
splitting, adding, and dropping
partitions, 577??“579
splitting global index partitions,
580??“581
virtual column partitioning, 570
Partitioning Option, 131
partitions, 130??“131, 266
sizing, 149
password files, 29, 280??“283
password-enabled roles, 311
pctfree, estimating the proper value of,
147??“148
permanent tablespaces, 62??“65
permissions, Flashback Data Archive,
237??“238
Personal Edition, 638
PGA.
Pages:
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966