Sumário Itens Encontrados: 288Chapter 1: Developing Successful Oracle ApplicationsMy ApproachThe Black Box Approach.How (and How Not) to Develop Database ApplicationsUnderstanding Oracle ArchitectureUnderstanding Concurrency ControlMulti-VersioningDatabase Independence?How Do I Make It Run Faster?The DBA-Developer Relationship. Chapter 2: Architecture Overview.Defining Database and Instance.The SGA and Background Processes.Connecting to OracleDedicated ServerShared ServerMechanics of Connecting over TCP/IP 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 Files.A Brief Review of File System MechanismsThe Storage Hierarchy in an Oracle DatabaseDictionary-Managed and Locally-Managed Tablespaces.Temp FilesControl FilesRedo Log FilesOnline Redo LogArchived Redo LogPassword Files.Change Tracking FileFlashback Logs.Flashback DatabaseFlash Recovery AreaDMP Files (EXP/IMP Files)Data Pump FilesFlat Files Chapter 4: Memory Structures.The Process Global Area and User Global AreaManual PGA Memory ManagementAutomatic PGA Memory ManagementChoosing Between Manual and Auto Memory Management.PGA and UGA Wrap-upThe System Global Area.Fixed SGARedo BufferBlock Buffer CacheShared PoolLarge Pool.Java PoolStreams PoolAutomatic SGA Memory ManagementAutomatic Memory Management Chapter 5: Oracle ProcessesServer Processes.Dedicated Server ConnectionsShared Server ConnectionsDatabase Resident Connection Pooling (DRCP)Connections vs. SessionsDedicated Server vs. Shared Server vs. DRCPDedicated/Shared Server Wrap-upBackground ProcessesFocused Background Processes.Utility Background Processes.Slave ProcessesI/O Slaves.Pnnn: Parallel Query Execution Servers Chapter 6: Locking and LatchingWhat Are Locks?Locking IssuesLost Updates.Pessimistic LockingOptimistic LockingOptimistic or Pessimistic Locking?.Blocking.DeadlocksLock EscalationLock Types.DML LocksDDL LocksLatchesMutexesManual Locking and User-Defined Locks Chapter 7: Concurrency and Multi-versioningWhat Are Concurrency Controls?.Transaction Isolation LevelsREAD UNCOMMITTED.READ COMMITTEDREPEATABLE READSERIALIZABLEREAD ONLYImplications of Multi-version Read Consistency.A Common Data Warehousing Technique That Fails.An 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 COMMIT.COMMITS in a Non-Distributed PL/SQL BlockIntegrity Constraints and Transactions.IMMEDIATE ConstraintsDEFERRABLE Constraints and Cascading Updates.Bad Transaction Habits.Committing in a LoopUsing AutocommitDistributed Transactions.Autonomous TransactionsHow Autonomous Transactions Work.When to Use Autonomous Transactions Chapter 9: Redo and Undo.What Is Redo?What Is Undo?How Redo and Undo Work TogetherExample INSERT-UPDATE-DELETE ScenarioCommit and Rollback ProcessingWhat Does a COMMIT Do?What Does a ROLLBACK Do?Investigating RedoMeasuring Redo.Can I Turn Off Redo Log Generation?Why Canât I Allocate a New Log?Block Cleanout.Log Contention.Temporary Tables and Redo/UndoInvestigating UndoWhat Generates the Most and Least Undo?ORA-01555: snapshot too old Error Chapter 10: Database TablesTypes of TablesTerminologySegmentSegment Space ManagementHigh-water MarkFREELISTSPCTFREE and PCTUSEDLOGGING and NOLOGGINGINITRANS and MAXTRANSHeap 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 TablesTemporary Tables Wrap-upObject TablesObject Tables Wrap-up Chapter 11: IndexesAn Overview of Oracle IndexesB*Tree IndexesIndex Key CompressionReverse Key IndexesDescending IndexesWhen Should You Use a B*Tree Index?B*Trees Wrap-upBitmap IndexesWhen Should You Use a Bitmap Index?Bitmap Join IndexesBitmap Indexes Wrap-upFunction-Based IndexesImportant Implementation DetailsA Simple Function-Based Index ExampleIndexing Only Some of the Rows.Implementing Selective UniquenessCaveat Regarding ORA-01743Function-Based Indexes Wrap-upApplication Domain IndexesFrequently Asked Questions and Myths About Indexes.Do 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 First Chapter 12: DatatypesAn Overview of Oracle DatatypesCharacter and Binary String TypesNLS OverviewCharacter StringsBinary Strings: RAW TypesNumber Types.NUMBER Type Syntax and UsageBINARY_FLOAT/BINARY_DOUBLE Type Syntax and Usage.Non-native Number TypesPerformance ConsiderationsLong TypesRestrictions on LONG and LONG RAW TypesCoping with Legacy LONG TypesDates,Timestamps,and Interval TypesFormatsDATE TypeTIMESTAMP Type.INTERVAL TypeLOB TypesInternal LOBsBFILEs.ROWID/UROWID Types Chapter 13: Partitioning.Partitioning OverviewIncreased AvailabilityReduced Administrative BurdenEnhanced Statement Performance.Table Partitioning Schemes.Range PartitioningHash PartitioningList PartitioningInterval PartitioningReference Partitioning.Composite PartitioningRow Movement.Table Partitioning Schemes Wrap-up.Partitioning IndexesLocal Indexes vs. Global Indexes.Local IndexesGlobal IndexesPartitioning and Performance,RevisitedAuditing and Segment Space Compression. Chapter 14: Parallel Execution.When to Use Parallel ExecutionA Parallel Processing AnalogyOracle Exadata.Parallel QueryParallel DML.Parallel DDLParallel DDL and Data Loading Using External TablesParallel DDL and Extent Trimming.Parallel RecoveryProcedural Parallelism.Parallel Pipelined FunctionsDo-It-Yourself ParallelismOld School Do-It-Yourself Parallelism Chapter 15: Data Loading and Unloading.SQL*Loader.Loading Data with SQLLDR FAQsSQLLDR CaveatsExternal TablesSetting Up External TablesDealing with ErrorsUsing an External Table to Load Different FilesMultiuser IssuesFlat File UnloadData Pump Unload Chapter 16: Data EncryptionTypes of EncryptionData in MotionData at RestManual Application EncryptionThe Oracle WalletTransparent Column Level EncryptionTransparent Tablespace EncryptionWhat Encryption Is Not AboutImplementing Manual Application EncryptionReasons to Avoid the Manual ApproachPerformance Implications of the Manual ApproachWhen to Use the Manual ApproachImplementing Column Level EncryptionHow to Use Column EncryptionData Storage with Column EncryptionMeasuring the Performance Impact of Column EncryptionInfluences on the MagnitudeLimitations of Column Encryption.Implementing Tablespace Encryption.How to Use Tablespace EncryptionData Storage with Tablespace EncryptionMeasuring the Performance Impact of Tablespace EncryptionDeciding on an Encryption Technique