The ODF Comparison utility(ADODFCMP) is used to compare the data model of a customer’s data to a standard set of data model files from the current Oracle Application release. It can optionally modify the database to match the standard data model. Each application consists of certain building blocks. There is an object descriptor file (ODF) […]
How to recover corrupt blocks using RMAN Blockrecover
1. Recovering Data blocks By Using All Available Backups Run the BLOCKRECOVER command at the RMAN prompt, specifying the file and block numbers for the corrupted blocks RMAN>BLOCKRECOVER DATAFILE 11 BLOCK 15; Recover multiple blocks in single command RMAN>BLOCKRECOVER DATAFILE 11 BLOCK 15 DATAFILE 2 BLOCK 10 2. Recovering Data blocks Using Selected Backups Run […]
How to set Table Monitoring in Oracle and Relationship with STATISTICS_LEVEL
What is Table Monitoring in Oracle Table monitoring is checking for how many updates,deletes ,insert happened in the tables so that we can find out if the statistics are stale or good for the table .It is a very useful functionality in gathering stats for the tables in Oracle How to Set the Table Monitoring […]
PL/SQL Gateway in R11i
The PL/SQL Gateway in R11i provides support for building PL/SQL-based applications on the Web. PL/SQL stored procedures can retrieve data from a database and generate HTTP responses containing data and code to display in a Web browser. Also can upload/download file to oracle database table from browser and access that file from the browser. also […]
Result cache in 11g
Prior to 10g, every query must be re-executed even if there is no change in the tables. This reexecution is unnecessary for few static tables and only caching using at client tools resolve this issue. But, in 11g, query results can be cached in SGA. Just to avoid confusion, this is much different from buffer […]
Staged APPL_TOP in Oracle Applications R12
A staged Applications system represents an exact copy of your Production system, including all APPL_TOPs as well as a copy of the Production database. Patches are applied to this staged system, while your Production system remains up. When all patches have been successfully applied to the test system, the reduced downtime for the Production system […]
