book

Oracle Distributed Systems

Name: Oracle Distributed Systems
Author: Charles Dye
ISBN: 9781565924321

by Charles Dye

April 1999

Intermediate to advanced

552 pages

15h 39m

English

O'Reilly Media, Inc.

Read now

Unlock full access

Oracle Distributed Systems
Preface
Audience for This Book
About Replication
About Oracle Versions and Platforms
Structure of This Book
Part IPart IIPart III
Conventions Used in This Book
About the Scripts
Comments and Questions
Acknowledgments
I. The Distributed System

1. Introduction to Distributed Systems
Terminology and Concepts
What Is a Distributed Database System?
Benefits of Distributed Databases
TunabilityPlatform AutonomyFault ToleranceScalabilityLocation TransparencySite AutonomyEnhanced Security
Multiple Schema Versus Multiple Databases
The Single Database with Multiple SchemaDatabase Instances Devoted to a Single Application
Options for Distributed Data
Export/ImportDatabase LinksRead-Only SnapshotsUpdateable SnapshotsAdvanced ReplicationProcedural Replication
Perils of Distributed Databases
SecurityData ConsistencyTransaction ManagementMonitoringRecoveryPerformance
Differences Between Oracle7 and Oracle8
2. SQL*Net and Net8
Protocol OverviewDistributed ProcessingNetwork Transparency and Network IndependenceMultiple Network Protocol InteroperabilityOracle Names
Architecture
SQL*Net/Net8, TNS, and the OSI Reference ModelApplication layerPresentation layerSession layerTransport, network, data link, and physical layersSQL*Net/Net8 ElementsConnection ScenariosBequeathed and Redirected ConnectionsHow a bequeathed connection is established on UnixHow a redirected connection is establishedExample: Connecting to a Multi-Threaded ServerExample: Connecting to a Prespawned Server Process
SQL*Net/Net8 Tuning
Do You Have a Problem?Tuning the multi-threaded serverTuning multi-threaded server dispatchers in Oracle8Tuning multi-threaded server server processesMeasuring m ulti-threaded server server activityTuning Dedicated Processes and Prespawned ProcessesBreak Out the Sniffer
Load Balancing
Multiple TNS Listeners and Multi-Threaded Server with a Single Database InstanceMultiple TNS Listeners and Multi-Threaded Server with Multiple Database InstancesMultiple TNS Listeners and Dedicated Processes
Oracle8 Scalability Options
Connection PoolingSession MultiplexingScalability: Summary
SQL*Net/Net8 Client Configuration
Dead Connection DetectionTracing and LoggingDefault DomainsOracle Names ParametersAdditional Parameters
SNMP Support
Configuring SNMP SupportUsing SNMP
Security
3. Configuration and Administration
Initialization ParametersCOMMIT_POINT_STRENGTHDB_DOMAINDBLINK_ENCRYPT_LOGIN (Oracle8)DISTRIBUTED_LOCK_TIMEOUTDISTRIBUTED_RECOVERY_CONNECTION_HOLD_TIMEDISTRIBUTED_TRANSACTIONSGLOBAL_NAMESJOB_QUEUE_INTERVALJOB_QUEUE_PROCESSESMAX_TRANSACTION_BRANCHESOPEN_LINKSOPEN_LINKS_PER_INSTANCE (Oracle8)REMOTE_DEPENDENCIES_MODEREMOTE_LOGIN_PASSWORD_FILEREMOTE_OS_AUTHENTREMOTE_OS_ROLESREPLICATION_DEPENDENCY_TRACKING (Oracle8)SNAPSHOT_REFRESH_INTERVALSNAPSHOT_REFRESH_PROCESSES
Database Links
Global Names and Database LinksPublic, Private, and Global Database LinksWhen to use public database linksWhen to use private database linksWhen to use global database linksCreating Database LinksPrerequisites for creating database linksThe PUBLIC qualifierThe SHARED qualifierThe connection qualifierThe CONNECT clauseThe CURRENT_USER qualifierThe USING clauseThe AUTHENTICATED clauseDropping Database LinksAccessing Data over a Database LinkHow Database Links Are ResolvedThe algorithmExample of database link resolutionListing Information About Database LinksData Relocation with Database LinksRestrictions on Distributed Operations over Database Links
Distributed Queries and Transactions
Behind the Scenes of a Distributed TransactionTwo-phase commit: The participantsTwo-phase commit: ExplainedWhen Things Go WrongTypes of distributed transaction failuresForcing commits and rollbacks of distributed transactionsTesting recovery of failed distributed transactionsRestrictions on Distributed Transactions
Distributed Backup and Recovery
Distributed RecoverySnapshotsBackup Strategy Considerations
Multiversion Interoperability
4. Distributed Database Security
Privilege ManagementThe Simplistic ApproachAdvantages of the simplistic approachDisadvantages of the simplistic approachThe Mirrored Account ApproachAdvantages of the mirrored account approachDisadvantages of the mirrored account approachThe Local View ApproachAdvantages of the local view approachDisadvantages of the local view approachThe Local Wrapper ApproachAdvantages of the local wrapper approachDisadvantages of the local wrapper approachConclusions on Privilege Management
Authentication Methods
Database AuthenticationWrite a wrapper command around sqlplusUse operating system authenticated (OPS$) accountsDon’t invoke programs with username and password on command lineOperating System AuthenticationCreating OPS$ accountsThe assumed risks of OPS$ accountsExternal Authentication
5. Designing a Distributed System
Characteristics of a Distributed SystemDistributed System ObjectivesLocal autonomyNo reliance on a single siteContinuous operationLocation transparencyFragmentation independenceReplication independenceDistributed query processingDistributed transaction managementHardware independenceOperating system independenceNetwork independenceRDBMS independenceDistributed System ClassificationsHomogeneous distributed systemsHeterogeneous distributed systemsFederated database systemsRedundant backup systemsDistributed system classifications: Summary
The Global Data Dictionary
Placement of the Global Data DictionaryObject NamingThe Local Data DictionaryManagement of Interdatabase Integrity ConstraintsManagement of User Accounts and Privileges
Replication-Specific Issues
Replication ArchitectureLog-based replicationAdvantagesDisadvantagesTransactional replicationAdvantagesDisadvantagesSoftware CompatibilityData ConsistencyData ExtractionPrimary KeysConflict Avoidance
Data Partitioning Methodologies
Identify Users, Locations, and ActivitiesAssess Existing Network and Hardware InfrastructureIdentify Coordinated Recovery RequirementsMap Processes to DataAssess Global RequirementsPropose and Validate Data Locations
Application Partitioning Strategies
Enforcing Business Rules in the Database TierEnforcing Business Rules in the Presentation TierCreating a Third TierHow Many Tiers Are Right for You?
Procedural Replication
6. Oracle’s Distributed System Implementation
Meeting the 12 Objectives with OracleLocal AutonomyNo Reliance on a Single SiteContinuous OperationLocation TransparencyFragmentation IndependenceReplication IndependenceDistributed Query ProcessingDistributed Transaction ManagementHardware IndependenceOperating System IndependenceNetwork IndependenceRDBMS Independence.Conclusions
Oracle’s Global Data Dictionary
Global NamingData Dictionary Views and Location Transparency
7. Sample Configurations
The High-Availability SystemThe Hot Standby DatabaseAdvantages and disadvantages of the hot standby databaseOracle Parallel ServerAdvantages and disadvantages of Oracle parallel serverAdvanced ReplicationAdvantages and disadvantages of advanced replication
Geographic Data Distribution
Workflow Partitioning
Data Collection and Consolidation
Loosely Coupled Federation
8. Engineering Considerations
Schema Design and IntegrationInterdatabase Referential IntegrityNaming ConventionsDistributed Queries and TransactionsControl the driving siteControl index usageMaintenance of Database Link ConnectionsError Handling
Application Tiering
Designing a Replicated System
Transactional ConsistencySchema Differences and PartitioningRow-Level Replication or Procedural Replication?Primary Keys and Unique IndexesForeign Keys and Referential IntegrityTriggers on Replicated TablesDatatypesTimeSequencesUsing a single sequence at a master siteAllocating sequence ranges to sitesUsing a multicolumn primary keyMultiple Character Sets
II. Replication
9. Oracle Replication Architecture
What Is Oracle Replication?
Types of Replication
Architecture Components
The QueuesThe Triggers and PackagesThe read-only snapshot mechanismThe updateable snapshot mechanismThe multi-master replication mechanismThe Background Processes
Replication of DDL
Oracle8 Enhancements
Oracle8i Enhancements
Alternatives to Replication
A pplication- and Trigger-Based ReplicationExport/ImportCOPY/CREATE TABLE AS SELECT
10. Advanced Replication Installation
Initialization Parameters
Redo Logs and Rollback Segments
Size and Placement of Data Dictionary Objects
Administrative Accounts, Privileges, and Database Links
Configuring Oracle7 for the Mirrored User Access ModelConfiguring Oracle7 for the Global Access ModelConfiguring Oracle8 for Advanced Replication
11. Basic Replication
About Read-Only Snapshots
Prerequisites and Restrictions
Initialization ParametersSystem PrivilegesRestrictions
Snapshot Creation Basics
The Snapshot STORAGE ClauseThe REFRESH ClauseThe Defining Query
Simple Versus Complex Snapshots
Snapshot Logs
Restrictions on Snapshot LogsCreation TipsSnapshot Logs for ROWID Snapshots
Subquery Subsetting
Restrictions on Subquery SubsetsSubquery Subset Snapshot Base TablesA Special Case
Refresh Groups
Creating and Destroying Refresh GroupsCreating a snapshot refresh group of read-only snapshotsCreating a snapshot refresh group of read-only snapshots with specialized parametersCreating a snapshot r efresh group that uses parallel propagation (Oracle8 only)Dropping a refresh group
Management and Optimization
Tuning SnapshotsAdministrative TasksReorganizing a Master Table in Oracle8Steps for reorganizing a master table using truncationSteps for reorganizing a master table by renamingOffline Instantiation of SnapshotsTroubleshootingSnapshots are not refreshingSnapshots refreshing continuouslySnapshot logs are growing uncontrollably
Scripts
12. Multi-Master Replication
Concepts and TerminologyDeferred TransactionReplication GroupQuiescenceMaster Definition SiteMaster SiteReplication SupportConflictPropagation LatencyInstantiation
Getting Started
The Quick-and-Dirty SetupA Quick-and-Dirty Example
Replication Groups
API CallsNaming ConventionsWhich Tables Belong in the Same Replication Group?How to Drop a Replication Group
Master Site Maintenance and Propagation
API CallsAdding a Master SiteCreating the REGIONS tableCreating constraints and indexes on REGIONS tableCreating user-defined triggers on the REGIONS tableDropping a Master SiteRelocating a Master Definition Site
Controlling Propagation
API CallsAbout the ParametersParallel PropagationManaging parallel propagationChecking parallel pushesParallel push errorsSynchronous versus asynchronous propagationScheduling multiple push intervals for the same database
The Replication Catalog
Replication Catalog Data Dictionary ViewsPushing repcatlog EntriesMonitoring ProgressCorrecting Errors
Table Replication
API CallsColumn GroupsMinimum Communication and SEND_AND_COMPARE_OLD_VALUESTriggers on Replicated TablesA trigger to populate fields at the originating site onlyA trigger to populate a field from a sequence on inserts and fields used for conflict resolutionReplicating triggers themselvesUsing Offline InstantiationOffline instantiation caveatsAn alternative to DBMS_OFFLINE_OGAdding and Removing TablesAdding replicated tables.Removing replicated tablesDropping replicated tables: caveatsPartially dropped tables (Oracle8 only)
Replicating DDL
RestrictionsExamplesCreating an indexCompiling a replicated package bodyAltering a column in a replicated tableManually Executing Entries in the repcatlogDeleting Errors from the repcatlog
Your Replicated Environment
Monitoring Queued TransactionsMonitoring Deferred Transaction ErrorsMonitoring Snapshot LogsMonitoring: Summary
Advanced Replication Limitations
13. Updateable Snapshots
About Updateable SnapshotsRestrictions
Creating Updateable Snapshots
Preliminary StepsPreparing the Master TablePreparing the Snapshot SiteUser-Defined Triggers on Updateable Snapshots
Communication Flow
Controlling Propagation and Refreshes
Real-Time (Synchronous) PropagationOnce-a-Day PropagationPropagation on Demand
Maintenance
Altering the Master TableDropping a Replicated Snapshot ObjectMaster table still existsRemastering a snapshot
14. Procedural Replication
When to Use Procedural Replication
How Procedural Replication Works
Creating a Replicated Package Procedure
Restrictions on Procedural Replication
An Example
cr_seq_audit_admin.sqlcr_audit_admin.sqlpl_useradmin.sqlrep_useradmin.sql
15. Conflict Avoidance and Resolution Techniques
Data Integrity Versus Data Convergence
Applications That Avoid Conflicts
NormalizeDesignate a Governing Column for Column GroupsStandardize on a Time ZoneIdentify WorkflowConsider Token PassingPerform Strategic Administration
Types of Conflicts Detected
Limitations of Delete Conflict ResolutionDefining a delete conflict handlerLimitations of NULL Values in Conflict ResolutionReferential Integrity Violations and Conflict ResolutionConflicts Arising from Procedural Replication
How Oracle Detects and Resolves Conflicts
Column Groups and Priority Groups
Column GroupsHow the column group resolution mechanism worksAPIs for column groupsPriority GroupsSite PriorityAPIs for priority groups and site priority
The Built-in Methods
Minimum Value/Maximum ValueEarliest Timestamp/Latest TimestampOverwrite Update/Discard UpdateAverage/AdditiveAppend Site Name/Append SequenceIgnore Insert/Discard Insert
Writing Your Own Conflict Resolution Handler
III. Appendixes
A. Built-in Packages for Distributed Systems
DBMS_DEFER: Building Deferred CallsHow the Package Is UsedInstallation and AccessDBMS_DEFER ProceduresDBMS_DEFER ExceptionsDBMS_DEFER Nonprogram Elements
DBMS_DEFER.CALL
DBMS_DEFER.COMMIT_WORK
DBMS_DEFER.datatype_ARG
DBMS_DEFER.TRANSACTION
DBMS_DEFER_QUERY: Performing Diagnostics and Maintenance
How the Package Is UsedInstallation and AccessDBMS_DEFER_QUERY ProceduresDBMS_DEFER_QUERY Nonprogram Elements
DBMS_DEFER_QUERY.GET_ARG_TYPE
DBMS_DEFER_QUERY.GET_CALL_ARGS
DBMS_DEFER_QUERY.GET_datatype_ARG
DBMS_DEFER_SYS: Managing Deferred Transactions
How the Package Is UsedInstallation and AccessDBMS_DEFER_SYS ProceduresDBMS_DEFER_SYS ExceptionsDBMS_DEFER_SYS Nonprogram Elements
DBMS_DEFER_SYS.ADD_DEFAULT_DEST
DBMS_DEFER_SYS.COPY (Oracle7 only)
DBMS_DEFER.SYS.DELETE_DEFAULT_DEST
DBMS_DEFER_SYS.DELETE_ERROR
DBMS_DEFER_SYS.DELETE_TRAN
DBMS_DEFER_SYS.DISABLED
DBMS_DEFER_SYS.EXCLUDE_PUSH (Oracle8 Only)
DBMS_DEFER_SYS.EXECUTE
DBMS_DEFER_SYS.EXECUTE_ERROR
DBMS_DEFER_SYS.PURGE (Oracle8 Only)
DBMS_DEFER_SYS.PUSH
DBMS_DEFER_SYS.REGISTER_PROPAGATOR (Oracle8 Only)
DBMS_DEFER_SYS.SCHEDULE_EXECUTION
DBMS_DEFER_SYS.SCHEDULE_PURGE (Oracle8 Only)
DBMS_DEFER_SYS.SCHEDULE_PUSH (Oracle8 Only)
DBMS_DEFER_SYS.SET_DISABLED
DBMS_DEFER_SYS.UNREGISTER_PROPAGATOR (Oracle8 Only)
DBMS_DEFER_SYS.UNSCHEDULE_EXECUTION
DBMS_DEFER_SYS.UNSCHEDULE_PURGE (Oracle8 Only)
DBMS_DEFER_SYS.UNSCHEDULE_PUSH (Oracle8 Only)
DBMS_OFFLINE_OG: Performing Site Instantiation
How the Package Is UsedInstallation and AccessDBMS_OFFLINE_OG ProceduresDBMS_OFFLINE_OG ExceptionsDBMS_OFFLINE_OG Nonprogram Elements
DBMS_OFFLINE_OG.BEGIN_INSTANTIATION
DBMS_OFFLINE_OG.BEGIN_LOAD
DBMS_OFFLINE_OG.END_INSTANTIATION
DBMS_OFFLINE_OG.END_LOAD
DBMS_OFFLINE_OG.RESUME_SUBSET_OF_MASTERS
DBMS_OFFLINE_SNAPSHOT: Performing Offline Snapshot Instantiation
How the Package Is UsedInstallation and AccessDBMS_OFFLINE_SNAPSHOT ProceduresDBMS_OFFLINE_SNAPSHOT Exceptions
DBMS_OFFLINE_SNAPSHOT.BEGIN_LOAD
DBMS_OFFLINE_SNAPSHOT. END_LOAD
DBMS_RECTIFIER_DIFF: Comparing Replicated Tables
How the Package Is UsedInstallation and AccessDBMS_RECTIFIER_DIFF ProceduresDBMS_RECTIFIER_DIFF Exceptions
DBMS_RECTIFIER_DIFF.DIFFERENCES
DBMS_RECTIFIER_DIFF. RECTIFY
DBMS_REFRESH: Managing Snapshot Groups
How the Package Is UsedInstallation and AccessDBMS_REFRESH ProceduresDBMS_REFRESH Nonprogram Elements
DBMS_REFRESH.ADD
DBMS_REFRESH.CHANGE
DBMS_REFRESH.DESTROY
DBMS_REFRESH.MAKE
DBMS_REFRESH.REFRESH
DBMS_REFRESH. SUBTRACT
DBMS_REPCAT: Performing Replication Administration
How the Package Is UsedInstallation and AccessDBMS_REPCAT ProceduresDBMS_REPCAT ExceptionsDBMS_REPCAT Nonprogram ElementsDBMS_REPCAT.ADD_conflicttype_RESOLUTIONParametersExceptionsRestrictions
DBMS_REPCAT.ADD_GROUPED_COLUMN
DBMS_REPCAT.ADD_MASTER_DATABASE
DBMS_REPCAT.ADD_PRIORITY_datatype
DBMS_REPCAT.ADD_SITE_PRIORITY_SITE
DBMS_REPCAT. ALTER_MASTER_PROPAGATION
DBMS_REPCAT. ALTER_MASTER_REPOBJECT
DBMS_REPCAT.ALTER_PRIORITY
DBMS_REPCAT.ALTER_PRIORITY_datatype
DBMS_REPCAT.ALTER_SITE_PRIORITY
DBMS_REPCAT.ALTER_SITE_PRIORITY_SITE
DBMS_REPCAT.ALTER_SNAPSHOT_PROPAGATION
DBMS_REPCAT.CANCEL_STATISTICS
DBMS_REPCAT.COMMENT_ON_conflicttype_RESOLUTION
DBMS_REPCAT.COMMENT_ON_COLUMN_GROUP
DBMS_REPCAT.COMMENT_ON_PRIORITY_GROUP
DBMS_REPCAT. COMMENT_ON_REPGROUP
DBMS_REPCAT. COMMENT_ON_REPOBJECT
DBMS_REPCAT.COMMENT_ON_REPSITES
DBMS_REPCAT.COMMENT_ON_SITE_PRIORITY
DBMS_REPCAT.CREATE_MASTER_REPGROUP
DBMS_REPCAT.CREATE_MASTER_REPOBJECT
DBMS_REPCAT. CREATE_SNAPSHOT_REPGROUP
DBMS_REPCAT.CREATE_SNAPSHOT_REPOBJECT
DBMS_REPCAT.DEFINE_COLUMN_GROUP
DBMS_REPCAT.DEFINE_PRIORITY_GROUP
DBMS_REPCAT.DEFINE_SITE_PRIORITY
DBMS_REPCAT .DO_DEFERRED_REPCAT_ADMIN
DBMS_REPCAT.DROP_conflicttype_RESOLUTION
DBMS_REPCAT.DROP_COLUMN_GROUP
DBMS_REPCAT.DROP_GROUPED_COLUMN
DBMS_REPCAT.DROP_MASTER_REPGROUP
DBMS_REPCAT.DROP_MASTER_REPOBJECT
DBMS_REPCAT.DROP_PRIORITY
DBMS_REPCAT.DROP_PRIORITY_datatype
DBMS_REPCAT.DROP_PRIORITY_GROUP
DBMS_REPCAT.DROP_SITE_PRIORITY
DBMS_REPCAT.DROP_SITE_PRIORITY_SITE
DBMS_REPCAT.DROP_SNAPSHOT_REPGROUP
DBMS_REPCAT.DROP_SNAPSHOT_REPOBJECT
DBMS_REPCAT.EXECUTE_DDL
DBMS_REPCAT.GENERATE_REPLICATION_PACKAGE
DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT
DBMS_REPCAT.GENERATE_REPLICATION_TRIGGER
DBMS_REPCAT.MAKE_COLUMN_GROUP
DBMS_REPCAT. PURGE_MASTER_LOG
DBMS_REPCAT.PURGE_STATISTICS
DBMS_REPCAT.REFRESH_SNAPSHOT_REPGROUP
DBMS_REPCAT.REGISTER_STATISTICS
DBMS_REPCAT. RELOCATE_MASTERDEF
DBMS_REPCAT.REMOVE_MASTER_DATABASES
DBMS_REPCAT. REPCAT_IMPORT_CHECK
DBMS_REPCAT.RESUME_MASTER_ACTIVITY
DBMS_REPCAT.SEND_AND_COMPARE_OLD_VALUES (Oracle8 Only)
DBMS_REPCAT. SET_COLUMNS
DBMS_REPCAT.SUSPEND_MASTER_ACTIVITY
DBMS_REPCAT.SWITCH_SNAPSHOT_MASTER
DBMS_REPCAT.VALIDATE
DBMS_REPCAT.WAIT_MASTER_LOG
DBMS_REPCAT_ADMIN: Setting Up Administrative Accounts
How the Package Is UsedInstallation and AccessDBMS_REPCAT_ADMIN ProceduresDBMS_REPCAT_ADMIN Exceptions
DBMS_REPCAT_ADMIN.GRANT_ADMIN_ANY_REPGROUP
DBMS_REPCAT_ADMIN.GRANT_ADMIN_REPGROUP
DBMS_REPCAT_ADMIN.REVOKE_ADMIN_ANY_REPGROUP
DBMS_REPCAT_ADMIN.REVOKE_ADMIN_REPGROUP
DBMS_REPCAT_AUTH: Setting Up More Administrative Accounts
How the Package Is UsedInstallation and AccessDBMS_REPCAT_AUTH ProceduresDBMS_REPCAT_AUTH Exceptions
DBMS_REPCAT_AUTH.GRANT_SURROGATE_REPCAT
DBMS_REPCAT_AUTH.REVOKE_SURROGATE_REPCAT
DBMS_REPUTIL: Enabling and Disabling Replication
How the Package Is UsedInstallation and AccessDBMS_REPUTIL ProceduresDBMS_REPUTIL Nonprogram Elements
DBMS_REPUTIL.REPLICATION_OFF
DBMS_REPUTIL.REPLICATION_ON
DBMS_SNAPSHOT: Managing Snapshots
How the Package Is UsedInstallation and AccessDBMS_SNAPSHOT Procedures
DBMS_SNAPSHOT.BEGIN_TABLE_REORGANIZATION (Oracle8 Only)
DBMS_SNAPSHOT.END_TABLE_REORGANIZATION (Oracle8 Only)
DBMS_SNAPSHOT.I_AM_A_REFRESH
DBMS_SNAPSHOT.PURGE_LOG
DBMS_SNAPSHOT.REFRESH
DBMS_SNAPSHOT.REFRESH_ALL
DBMS_SNAPSHOT.REGISTER_SNAPSHOT (Oracle8 Only)
DBMS_SNAPSHOT.SET_I_AM_A_REFRESH
DBMS_SNAPSHOT.UNREGISTER_SNAPSHOT (Oracle8 Only)
B. Scripts and Utilities
busycirc.sql
busydisp.sql
busyq.sql
checklatency
colgroups.sql
confstats.sql
cr_regions.sql
defcall.sql
defcalldest.sql
defcallinfo.sql
defdest.sql
deferror.sql
deferror8.sql
deforigin.sql
defschedule.sql
deftran.sql
deftrandest.sql
disprate.sql
errorinfo.sql
fixdefer.sql
gendelerrtran.sql
gendeltran.sql
gengensup.sql
groupedcols.sql
invalids.sql
jobs.sql
keycols.sql
lastsnap.sql
latent.sql
links.sql
mastersnapinfo.sql
mlogs.sql
needsgen.sql
nonrepobjects.sql
pk_regions.sql
prioritygroups.sql
prioritysites.sql
propmode.sql
refgroups.sql
regsnaps.sql
repcaterr.sql
repcatlog.sql
repconflict.sql
repgroup.sql
repobjects.sql
repres.sql
repsites.sql
resconfs.sql
snaps.sql
snaps7.sql
trg_regions.sql
UserAdmin
Index
Colophon

404

Not Found

Either this content does not exist or you do not have access to it. Try searching for something new.

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

Oracle Distributed Systems

by Charles Dye

404

Not Found