Hot answers tagged oracle-10g
As @Leigh Riffel noted, a select max(ora_rowscn) will result in a full table scan. An alternative is to have a timestamp column (we will call sys_ts for this example) which is populated to the time of statement execution (which is not the same as statement commitment, which is when the scn is generated/populated). An index on the sys_ts column will allow you ...
Only top voted, non community-wiki answers of a minimum length are eligible