book

Pro Oracle Database 11g Administration

by Darl Kuhn

December 2010

Intermediate to advanced

713 pages

19h 33m

English

Apress

Read now

Unlock full access

Understanding the Optimal Flexible ArchitectureInstalling OracleInstalling with a Copy of an Existing InstallationUpgrading Oracle SoftwareReinstalling After Failed InstallationApplying Interim PatchesInstalling Remotely with the Graphical InstallerSummary
Setting Operating System VariablesCreating a DatabaseConfiguring and Implementing the ListenerCreating a Password FileStarting and Stopping the DatabaseUsing a Response File to Create a DatabaseDropping a DatabaseHow Many Databases on One Server?Summary
Customizing Your Operating System Command PromptCustomizing Your SQL PromptCreating Shortcuts for Frequently Used CommandsRerunning Commands QuicklySetting the Command EditorDeveloping Standard ScriptsOrganizing ScriptsSummary
Understanding the First FiveUnderstanding the Need for MoreCreating TablespacesRenaming a TablespaceControlling the Generation of RedoChanging a Tablespace's Write ModeDropping a TablespaceUsing Oracle Managed FilesCreating a Bigfile TablespaceDisplaying Tablespace SizeAltering Tablespace SizeToggling Datafiles Offline and OnlineRenaming or Relocating a DatafileSummary
Managing Control FilesManaging Online Redo LogsSummary
Understanding Schemas vs. UsersManaging Default UsersCreating UsersModifying PasswordsEnforcing Password SecurityLogging On as a Different UserModifying UsersDropping UsersEnforcing Password Security and Resource LimitsManaging PrivilegesGrouping and Assigning PrivilegesSummary
Understanding Table TypesCreating a TableModifying a TableDisplaying Table DDLDropping a TableUndropping a TableRemoving Data from a TableViewing and Adjusting the High-Water MarkCreating a Temporary TableCreating an Index-Organized TableManaging ConstraintsSummary
Deciding When to Create an IndexWhat to Think AboutIndex-Management GuidelinesCreating IndexesSpecifying Index TablespacesMaintaining IndexesSummary
Implementing ViewsManaging SynonymsManaging SequencesSummary
Data-Dictionary ArchitectureLogical and Physical Database StructuresDisplaying User InformationViewing Table InformationDisplaying Index InformationDisplaying Constraint InformationViewing Basic Security InformationDisplaying Object DependenciesDisplaying Differences in SchemasSummary
Describing Current LOB TypesIllustrating LOB Locators, Indexes, and ChunksDistinguishing Between BasicFiles and SecureFilesCreating a Table with a LOB ColumnMaintaining LOB ColumnsUsing SecureFile FeaturesViewing LOB MetadataLoading LOBsMeasuring LOB Space ConsumedSummary
What Tables Should Be Partitioned?Creating Partitioned TablesMaintaining PartitionsPartitioning IndexesPartition PruningSummary
Data Pump ArchitectureExporting DataImporting DataInteractive Command ModeTips for Getting StartedTransferring DataExporting and Importing Tablespaces and DatafilesFiltering Data and ObjectsCommon Data Pump TasksMonitoring Data Pump JobsData Pump Legacy ModeSummary
SQL*Loader vs. External TablesLoading CSV Files into the DatabasePerforming Advanced TransformationsViewing Text Files from SQLUnloading and Loading Data Using an External TablePreprocessing an External TableSummary
Understanding Materialized ViewsCreating Basic Materialized ViewsGoing Beyond the BasicsModifying Materialized ViewsManaging Materialized View LogsRefreshing Materialized ViewsMonitoring Materialized View RefreshesCreating Remote Materialized View RefreshesManaging Materialized Views in GroupsSummary
Implementing a Cold-Backup Strategy for a Noarchivelog-Mode DatabaseImplementing Archivelog ModeImplementing a Hot-Backup StrategyPerforming a Complete Recovery of an Archivelog-Mode DatabasePerforming an Incomplete Recovery of an Archivelog-Mode DatabaseFlashing Back a TableFlashing Back a DatabaseSummary
Understanding RMANStarting RMANRMAN Architectural DecisionsSegueing from Decisions to ActionUsing a Recovery CatalogSummary
Preparing to Run RMAN Backup CommandsRunning BackupsCreating Incremental BackupsChecking for Corruption in Datafiles and BackupsLogging RMAN OutputRMAN ReportingSummary
Determining Media Recovery RequiredDetermining What to RestoreUsing RMAN to Stop/Start OracleComplete RecoveryRestoring a Control FileIncomplete RecoveryRestoring and Recovering to Different ServerSummary
OSB Editions and FeaturesOSB TerminologyDownload and InstallationCommand-line Access to OSBOSB ConfigurationDatabase BackupDatabase RestoreFile System BackupFile System RestoreOSB Job MonitoringVirtual Test DevicesOSB Software UpgradesSummary
Automating Jobs with Oracle SchedulerOracle Scheduler versus cronAutomating Jobs via cronExamples of Automated DBA JobsSummary
Quickly TriagingIdentifying Bottlenecks via Operating System UtilitiesFinding Resource Intensive SQL StatementsDetecting and Resolving Locking IssuesResolving Open Cursor IssuesTroubleshooting Undo Tablespace IssuesHandling Temporary Tablespace IssuesAuditingSummary

Content preview from Pro Oracle Database 11g Administration

C H A P T E R 15

Materialized Views

Materialized view (MV) technology was introduced in Oracle Database version 7. This feature was originally called snapshots, and you can still see this nomenclature reflected in some data-dictionary structures. A materialized view allows you to execute a SQL query at a point in time and store the result set in a table (either locally or in a remote database). After the MV is initially populated, at some later point in time you can re-run the MV query and store the fresh results in the underlying table. There are two main uses for materialized views: