Oracle GoldenGate (OGG) on OCI is a fully managed, cloud-native solution for real-time replication between Oracle and non-Oracle databases. But to maintain low-lag, data consistency, and high availability, monitoring performance is critical.
This post lays out a practical, hands-on guide to monitoring GoldenGate performance in OCI and outlines key metrics, tools, and proactive alerting practices.
Leave a CommentMost Oracle DBA & Oracle Apps DBAs are already aware that the technology world is moving fast and that is a fact that no one…
Leave a CommentThe parallel hint in Oracle Database is used to specify that a particular query or operation should be executed in parallel mode, using multiple parallel…
3 CommentsBelow is some basic information on how database level parameters are managed between CD and PDB databases in Oracle multitenant architecture: Changing parameters for CDB…
Leave a CommentConverting a database SID from uppercase to lowercase in the Oracle database can be needed sometimes. Below are general steps for converting a database SID…
Leave a CommentSQL Profile and SQL Baseline are both used to optimize the performance of SQL statements in Oracle databases. However, they work in slightly different ways:…
Leave a CommentPL/SQL lock timer wait event in Oracle occurs when a session is waiting for a lock held by another session to be released. This can…
Leave a CommentFrom the user and application perspective, the data dictionary in each container in a CDB is separate, as it would be in a non-CDB.
For example, the DBA_OBJECTS view in each PDB can show a different number of rows. This dictionary separation enables Oracle Database to manage the PDBs separately from each other and from the root.
Leave a Comment
Oracle Multitenant database can provide few good benefits if we plan carefully and specially by having a non-traditional approach. In the starting it may seem intimidating to the seasoned DBAs as this architecture need some learning and practice. Few of the key benefits which Oracle describes are mentioned below:
Leave a CommentThe multitenant architecture enables an Oracle database to function as a multitenant container database (CDB).
This feature is available in Oracle Database 12c or later releases so you must install or upgrade to Oracle Database 12c or later releases. The database compatibility level must be set to 12.0.0 or later to utilize the multitenant feature.
Leave a Comment
