Hi Tom, Please clarify the following points: 1.what is the difference between local context and global context? 2.For a session, can both exists and if yes, what differentiates them? 3.I have heard that this concept is basically used for web based application because of the conce...

I need to perform db operations where I need to inserts .5 million reocrds from another complex query involving joins,exists etc: As of now I am using INSERT INTO SELECT inside a pl/sq package. but some time I am observing for same data set this queries takes more time  Will For ...

Chris & Connor, We are working on a new project and were wondering as to what options are currently available / provided by Oracle for Change Data Capture, besides the DIY MViews ( MVIEW logs mostly ), triggers etc, does Oracle 11.2.0.4 and above provide an out of the box solutio...

SYS@standby28> select database_role,open_mode from v$database; DATABASE_ROLE OPEN_MODE -------------------------------- ---------------------------------------- PHYSICAL STANDBY READ ONLY WITH APPLY SYS@standby28> desc v$dataguard_sta

Hi all We offload reading/long queries to physical dataguard standby We also know that a fact that the physical standby is applying redo stream generated from primary It also does seems that - uncommitted undo generated from primary DMLs is not required in the standby - unexpired...