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 CommentIn Oracle Database, an invisible index is a type of index that is not used by the optimizer by default but can still be used…
1 CommentTo fetch the DDL of a table: SELECT DBMS_METADATA.GET_DDL(‘TABLE’, ‘table_name’) FROM DUAL; To fetch the DDL of a view: SELECT DBMS_METADATA.GET_DDL(‘VIEW’, ‘view_name’) FROM DUAL; To…
2 CommentsMost 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…
2 CommentsThe below script can be utilized to find if any UNIX process has a database session linked to it and if yes, provide all the…
Leave a CommentThe below script can be used to find SQL details from AWR. set lines 155 col execs for 999,999,999 col avg_etime for 999,999.999 col avg_lio…
Leave a CommentBelow 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 CommentHere are a few scripts that can be used to compile invalid objects in an Oracle database: Note: Please make sure that you have the…
Leave a CommentThe “library cache pin” wait event in an Oracle database occurs when a session is waiting to acquire a shared lock on an object in…
Leave a Comment