Sumário Itens Encontrados: 246Part I: Database ConceptsChapter 1: Relational Database Management SystemsA First Look at Oracle Database 12cWhat Is a Database?What Is a Relational Database?The Secret SauceExamples of Relational OperationsEfficiency of Relational OperatorsQuery OptimizationWhat Is a Database Management System?Transaction ManagementThe Atomicity Property of TransactionsThe Consistency Property of TransactionsThe Isolation Property of TransactionsThe Durability Property of TransactionsData IntegrityData SecurityWhat Makes a Relational Database Management System Relational?Further ReadingChapter 2: SQL and PL/SQL by ExampleRailroad DiagramsTypes of SQLData Definition LanguageDatabase Manipulation LanguageEmbedded SQLSQL*Plus and SQL DeveloperCriticisms of SQLDuplicatesRedundancyNullable Data ItemsIntroduction to PL/SQLExercisesChapter 3: Oracle ArchitectureDatabase vs InstanceDatabaseSoftwareConfiguration FilesData FilesTemporary FilesRedo Log FilesArchived Redo Log FilesControl FileEvent LogsDatabase BackupsInstanceSystem Global AreaBuffer CacheShared PoolLog BufferServer ProcessesBackground ProcessesOne-to-Many ConfigurationMany-to-One ArchitectureLife Cycle of a Database SessionPart II: Database ImplementationChapter 4: PlanningLicensingPractical ExampleFree to Download,Free to Learn,Unlimited EvaluationDatabase EditionsArchitectural ChoicesDedicated ServerShared ServerReal Application ClustersStandby DatabaseMaximum Availability Architecture (MAA)SizingDisk SizingOther Disk ConsiderationsMemory SizingCPU SizingNetwork SizingModern OptionsEngineered SystemsCloud ComputingChapter 5: Software InstallationOracle Technology NetworkThe Forgotten ManualsPrerequisites and Preinstallation RequirementsClient InstallationsInstant ClientSQL DeveloperServer InstallationsOracle Database ExamplesChapter 6: Database CreationCreating and Configuring a ListenerCreating and Configuring a DatabaseCommon OptionsInitialization ParametersControl FilesRedo Log GroupsBasic Database Administration TasksStopping the DatabaseStopping the ListenerStarting the ListenerStarting the DatabaseEnterprise Manager Database ExpressChapter 7: Physical Database DesignIndexesUnique vs Non-Unique IndexesConcatenated IndexesFunction-Based IndexesStructure of an IndexWhat Indexes to Create?Index-Organized TablesAdvanced TopicsPartitioningAdvantages of PartitioningList PartitioningRange PartitioningInterval PartitioningHash PartitioningReference PartitioningComposite PartitioningLocal and Global IndexesPartitioned ViewsDenormalization and Materialized ViewsClustersChapter 8: User Management and Data LoadingSchemasUser ManagementCreating UsersGiving Permissions to UsersRevoking Permissions Granted to UsersModifying User AttributesRemoving UsersData LoadingThe Export and Import UtilitiesThe Data Pump UtilitiesSQL*LoaderPart III: Database SupportChapter 9: Taking ControlEnterprise ManagerRemote Diagnostic AgentDictionary Tables and ViewsThird-Party ToolsChapter 10: MonitoringMonitoring Database AvailabilityMonitoring ChangesMonitoring SecurityMonitoring BackupsMonitoring GrowthMonitoring WorkloadMonitoring PerformanceMonitoring CapacityChapter 11: Fixing ProblemsSystematic Five-Step Problem-Solving MethodThe Book We All Want and Best Practices for Problem ManagementReal-Life Example: Unresponsive ListenerDefine the ProblemInvestigate and Analyze the ProblemSolve and Implement the ProblemOne Week LaterOpportunities for ImprovementIncident Management vs Problem ManagementInternet ResourcesWorking with Oracle SupportRemote Diagnostic Agent (RDA)ORAchk Oracle Configuration Audit ToolAutomatic Diagnostic Repository (ADR)Error CodesFour ErrorsORA-01555: Snapshot Too OldORA-00060: Deadlock DetectedORA-00600: Internal Error CodeORA-07445: Exception EncounteredChapter 12: BackupsWhy Do You Need Backups?Types of BackupTape Backups vs Disk BackupsFull Backups vs Partial BackupsLevel 0 Backups vs Level 1 BackupsPhysical Backups vs Logical BackupsConsistent Backups vs Inconsistent BackupsHot vs Cold BackupsOracle-Managed Backups vs User-Managed BackupsPractical Demonstration: Physical BackupsPractical Demonstration: Logical BackupsCommon RMAN CommandsHorror StoriesChapter 13: RecoveryTypes of RecoveryRestore vs RecoverFull Recovery vs Partial RecoveryComplete Recovery vs Incomplete RecoveryTraditional vs FlashbackPhysical Recovery vs Logical RecoveryFlashback TechnologyFlashback QueryFlashback VersionsFlashback TransactionFlashback TableFlashback DropFlashback Data ArchiveFlashback DatabaseLogMinerData Recovery AdvisorDocumentation and TestingChapter 14: Database MaintenanceThe Maintenance PlanBackupsGeneric Best Practices for Database BackupsBest Practices for Oracle Database BackupsStatisticsArchiving and PurgingRebuildingLog File MaintenanceAuditingCapacity ManagementTime SeriesPatchingChapter 15: The Big Picture and the Ten DeliverablesAn Instructive Job InterviewHow I Became a DBAITILThe Big PictureIT Service Management ProcessesStart with the End in Mind: The Ten DeliverablesThe Book You Really Need and the Art of the SOPBenefits of SOPsStructure of an SOPSuggested SOPsPart IV: Database TuningChapter 16: Database TuningUsing a Systematic Five-Step Tuning MethodAnalyzing DB TimeUnderstanding the Oracle Wait InterfaceV$SYSSTAT and V$SESSTATV$SESSION_EVENT and V$SYSTEM_EVENTMining the Statspack RepositoryUsing the Statspack ReportChapter 17: SQL TuningDefining EfficiencyIdentifying Inefficient SQL StatementsUnderstanding the Causes of Inefficient SQLWays to Improve SQLHintsTuning by ExampleCreating and Populating the TablesEstablishing a BaselineExamining the Query PlanIndexes and StatisticsUsing SQL Access AdvisorOptimizer HintsExtreme TuningBut Wait,Thereâs More!