Sumário Itens Encontrados: 282Chapter 1: Developing Successful Oracle ApplicationsMy ApproachThe Black Box ApproachHow (and How Not) to Develop Database ApplicationsUnderstanding Oracle ArchitectureUnderstanding Concurrency ControlMultiversioningDatabase Independence?How Do I Make It Run Faster?The DBA-Developer RelationshipChapter 2: Architecture OverviewDefining Database and InstanceThe SGA and Background ProcessesConnecting to OracleDedicated ServerShared ServerMechanics of Connecting over TCP/IP Pluggable DatabasesReduced Resource UtilizationReduced MaintenanceHow Is a Pluggable Database Different?Chapter 3: FilesParameter FilesWhat Are Parameters?Legacy init.ora Parameter FilesServer Parameter Files (SPFILEs)Converting to SPFILEsTrace FilesRequested Trace FilesTrace Files Generated in Response to Internal ErrorsTrace File Wrap-upAlert FileData FilesA Brief Review of File System MechanismsThe Storage Hierarchy in an Oracle DatabaseDictionary-Managed and Locally-Managed TablespacesTemp FilesControl FilesRedo Log FilesOnline Redo LogArchived Redo LogPassword FilesChange Tracking FileFlashback LogsFlashback DatabaseFast Recovery Area DMP Files (EXP/IMP Files)Data Pump FilesFlat FilesChapter 4: Memory StructuresThe Process Global Area and User Global AreaManual PGA Memory ManagementAutomatic PGA Memory ManagementChoosing Between Manual and Auto Memory ManagementPGA and UGA Wrap-upThe System Global AreaFixed SGARedo BufferBlock Buffer CacheShared PoolLarge PoolJava PoolStreams PoolSGA Memory ManagementChapter 5: Oracle ProcessesServer ProcessesDedicated Server ConnectionsShared Server ConnectionsDatabase Resident Connection Pooling (DRCP)Connections vs. SessionsDedicated Server vs. Shared Server vs. DRCPDedicated/Shared Server Wrap-upBackground ProcessesFocused Background ProcessesUtility Background Processes Slave ProcessesI/O SlavesPnnn: Parallel Query Execution ServersChapter 6: Locking and LatchingWhat Are Locks?Locking IssuesLost UpdatesPessimistic LockingOptimistic LockingOptimistic or Pessimistic Locking?BlockingDeadlocksLock EscalationLock TypesDML LocksDDL LocksLatchesMutexesManual Locking and User-Defined LocksChapter 7: Concurrency and MultiversioningWhat Are Concurrency Controls?Transaction Isolation LevelsREAD UNCOMMITTEDREAD COMMITTEDREPEATABLE READSERIALIZABLEREAD ONLY Implications of Multiversion Read ConsistencyA Common Data Warehousing Technique That FailsAn Explanation for Higher Than Expected I/O on Hot TablesWrite ConsistencyConsistent Reads and Current ReadsSeeing a RestartWhy Is a Restart Important to Us?Chapter 8: TransactionsTransaction Control StatementsAtomicityStatement-Level AtomicityProcedure-Level AtomicityTransaction-Level AtomicityDDL and AtomicityDurabilityWRITE Extensions to COMMITCOMMITS in a Nondistributed PL/SQL BlockIntegrity Constraints and TransactionsIMMEDIATE ConstraintsDEFERRABLE Constraints and Cascading UpdatesBad Transaction HabitsCommitting in a LoopUsing AutocommitDistributed TransactionsAutonomous TransactionsHow Autonomous Transactions WorkWhen to Use Autonomous TransactionsChapter 9: Redo and UndoWhat Is Redo?What Is Undo?How Redo and Undo Work TogetherExample INSERT-UPDATE-DELETE-COMMIT ScenarioCommit and Rollback ProcessingWhat Does a COMMIT Do?What Does a ROLLBACK Do?Investigating RedoMeasuring RedoCan I Turn Off Redo Log Generation?Why Canât I Allocate a New Log?Block CleanoutLog ContentionTemporary Tables and Redo/UndoInvestigating UndoWhat Generates the Most and Least Undo?ORA-01555: Snapshot Too Old ErrorChapter 10: Database TablesTypes of TablesTerminologySegmentSegment Space ManagementHigh-water MarkFREELISTSPCTFREE and PCTUSEDLOGGING and NOLOGGINGINITRANS and MAXTRANS Heap Organized TablesIndex Organized TablesIndex Organized Tables Wrap-upIndex Clustered Tables Wrap-upHash Clustered TablesHash Clustered Tables Wrap-upSorted Hash Clustered TablesNested TablesNested Tables SyntaxNested Table StorageNested Tables Wrap-upTemporary TablesStatistics Prior to 12cStatistics Starting with 12cTemporary Tables Wrap-upObject TablesObject Tables Wrap-upChapter 11: IndexesAn Overview of Oracle IndexesB*Tree IndexesIndex Key CompressionReverse Key IndexesDescending IndexesWhen Should You Use a B*Tree Index?B*Trees Wrap-up Bitmap IndexesWhen Should You Use a Bitmap Index?Bitmap Join IndexesBitmap Indexes Wrap-upFunction-Based IndexesA Simple Function-Based Index ExampleIndexing Only Some of the RowsImplementing Selective UniquenessCaveat Regarding ORA-01743Function-Based Indexes Wrap-upApplication Domain IndexesInvisible IndexesMultiple Indexes on the Same Column CombinationsIndexing Extended ColumnsVirtual Column SolutionFunction-Based Index SolutionFrequently Asked Questions and Myths About IndexesDo Indexes Work on Views?Do Nulls and Indexes Work Together?Should Foreign Keys Be Indexed?Why Isnât My Index Getting Used?Myth: Space Is Never Reused in an IndexMyth: Most Discriminating Elements Should Be FirstChapter 12: DatatypesAn Overview of Oracle DatatypesCharacter and Binary String TypesNLS OverviewCharacter StringsBinary Strings: RAW TypesExtended DatatypesNumber TypesNUMBER Type Syntax and UsageBINARY_FLOAT/BINARY_DOUBLE Type Syntax and UsageNon-Native Number TypesPerformance ConsiderationsLong TypesRestrictions on LONG and LONG RAW TypesCoping with Legacy LONG TypesDates,Timestamps,and Interval TypesFormatsDATE TypeTIMESTAMP TypeINTERVAL TypeLOB TypesInternal LOBsBFILEsROWID/UROWID TypesChapter 13: PartitioningPartitioning OverviewIncreased AvailabilityReduced Administrative BurdenEnhanced Statement PerformanceReduced Contention in an OLTP SystemTable Partitioning SchemesRange PartitioningHash PartitioningList Partitioning Interval PartitioningReference PartitioningInterval Reference PartitioningVirtual Column PartitioningComposite PartitioningRow MovementTable Partitioning Schemes Wrap-upPartitioning IndexesLocal Indexes vs. Global IndexesLocal IndexesGlobal IndexesPartial IndexesPartitioning and Performance,RevisitedEase of Maintenance FeaturesMultiple Partition Maintenance OperationsCascade TruncateCascade ExchangeAuditing and Segment Space CompressionChapter 14: Parallel ExecutionWhen to Use Parallel ExecutionA Parallel Processing AnalogyOracle ExadataParallel QueryParallel DMLParallel DDLParallel DDL and Data Loading Using External TablesParallel DDL and Extent Trimming Procedural ParallelismParallel Pipelined FunctionsDo-It-Yourself ParallelismOld School Do-It-Yourself ParallelismChapter 15: Data Loading and UnloadingExternal TablesSetting Up External TablesDealing with ErrorsUsing an External Table to Load Different FilesMultiuser IssuesPreprocessingData Pump UnloadSQLLDRLoading Data with SQLLDR FAQsSQLLDR CaveatsFlat File Unload