Latest Tweets

OraExplorer - Exploring Oracle

  • Oracle Database Gateways 11g R2 (11.2) Installation and Configuration for heterogeneous connection from Oracle to Microsoft SQL database

    Installation Install the Oracle Database Gateways 11g R2 (11.2). See the screen snapshots of the installation here. Configuration During the installation, the following+ default initialization parameter file is created: [ORACLE_DG_HOME]\dg4msql\admin\initdg4msql.ora dg4msql = Database gateway for Microsoft SQL Server. If you choose a different database option, use the appropriate path name. Copy initdg4msql.ora to a new [...]

  • How long did Oracle materialized view refresh run?

    The LAST_REFRESH_DATE column of the DBA_MVIEWS or the LAST_REFRESH column of the DBA_MVIEW_REFRESH_TIMES indicates the start refresh time. But what if we’d like to find out how long the refresh of the materialized view really takes. Well, we can query the DBA_MVIEW_ANALYSIS. For Complete Refresh, the refresh duration will be in the FULLREFRESHTIM column of [...]

Latest Videos
Views: 103
4 ratings
Time: 01:52 More in Pets & Animals
Life of New Oracle DBA - trying to recover database crash for the first time but has no clue what to do. Well, at the end, it is easier to find a new job.
Views: 416
3 ratings
Time: 00:35 More in Entertainment

Latest Links