RAM&KRISHNA BLOG

  SET   LINES   200 SET PAGES 999 COL LGWR FOR A5 COL THREAD FOR 99999 COL GROUP FOR 9999 COL STATUS FOR A8 COL ARCHIVED FOR A8 COL LOGFILE_TYPE FOR A12 COL MEMBER FOR A10 COL FILE_NAME FOR A50 COL MB FOR 9999 COL IS_RECOVERY_DEST_FILE FOR A22 SELECT DECODE ( LG . STATUS , 'CURRENT' , THREAD # || ' -->',NULL) AS LGWR, LG . THREAD # "THREAD", LG . GROUP # "GROUP", LF . TYPE LOGFILE_TYPE , LG . STATUS , LG . SEQUENCE # AS LOG_SEQUENCE, LG . ARCHIVED , LG . MEMBERS AS GROUP_MEMBER , ROUND ( LG . BYTES / 1024 / 1024 ) MB , LF . MEMBER FILE_NAME , LF . IS_RECOVERY_DEST_FILE FROM V$LOG LG , V$LOGFILE LF WHERE LG . GROUP #=LF.GROUP# ORDER BY LG . GROUP #;

    Differences Between Classic and Integrated Capture in Oracle GoldenGate Classic Capture: In Classic Capture mode, the Oracle GoldenGate Extract process captures data changes directly from Oracle redo or archive log files . In Oracle RAC environments, a separate ASM user must be created, and the necessary privileges must be granted to access the logs in ASM redo/archive. Alternatively, you can use the TRANLOGOPTIONS DBLOGREADER parameter in the Extract configuration for Classic Capture in a RAC setup. Performance : Classic Capture can be CPU-intensive and is generally slower when dealing with complex data types, such as LOBs (Large Objects). Multitenant Architecture : Not supported. RAC Support : Requires manual specification of threads based on the number of RAC nodes. TDE (Transparent Data Encryption) : More manual configuration is needed for TDE setups. Scalability : Less scalable in larger environments due to its single-thr

  How to Improve Oracle Data Pump Performance:- Use Parallelism : Set the PARALLEL parameter to at least 2 * number of CPUs . This allows multiple worker processes to perform tasks simultaneously, speeding up both export and import processes. Example: PARALLEL=4 for a system with 2 CPUs. Perform Import Using NETWORK_LINK : Use the NETWORK_LINK parameter to import data directly from the source database. This method is particularly helpful when space is constrained, as it streams the data without needing to generate dump files on the source. It can also reduce time compared to exporting and then importing, as data is streamed directly from the source to the target database. Disable Archivelog Mode (Standalone Databases) : For standalone databases, temporarily disable archive logging during the import process. Import operations can generate a lot of redo logs, slowing down the import. Disabling