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 […]
What is Oracle Database Lite 10g
Oracle Database Lite 10g extends the power of grid computing to a mobile workforce with a complete, integrated, secure database for building, deploying, and managing mobile applications for a broad range of mobile devices. Oracle Database Lite 10g enables persistent access to critical information and applications without requiring continuous connectivity to back-end enterprise systems. As […]
How to Clone Oracle Application Server 10g
Here are the steps outlined to How to Clone Application Server Given source machine is SUN1 and target machine is SUN2. Prepare steps 1) On the source and target ensure that the PERL5LIB variable is set. 2) $ export PERL5LIB=$ORACLE_HOME/perl/lib/5.6.1:$ORACLE_HOME/perl/lib/site_perl/5.6.1 3) cd $ORACLE_HOME/clone/bin 4) ./prepare_clone.pl ORACLE_HOME=$ORACLE_HOME Create tar file and copy to target system 5) […]