How Table Monitoring and STATISTICS_LEVEL parameter are connected from 10g onwards

Last updated on July 17th, 2015 at 06:05 pmBefore Oracle 10g -Automated collection of statistics for objects that had become stale was controlled by the setting of the MONITORING flag on table. Depending on the MONITORING flag, the GATHER_STATS_JOB job collected “GATHER EMPTY” and “GATHER STALE” on the flagged objects. 10g onwards -The MONITORING and NOMONITORING keywords are deprecated and will be ignored.Table-monitoring feature is … Continue reading How Table Monitoring and STATISTICS_LEVEL parameter are connected from 10g onwards »

How to find how much space is actually used by the lobsegments

Last updated on November 28th, 2015 at 12:35 pmLet us take the example of FND_LOBS tables in Oracle Apps Database.FND_LOBS has LOB datatype column FILE_DATA How to  find how much space is actually used by the lobsegments Query to find the actual bytes used by the lob datatype select sum(dbms_lob.getlength (FILE_DATA)) from FND_LOBS; SUM(DBMS_LOB.GETLENGTH(FILE_DATA)) ———————————- 13313 The total space allocated in the extents could be … Continue reading How to find how much space is actually used by the lobsegments »

How to correct error RMAN-20004

Last updated on December 21st, 2015 at 04:14 amProblem:When Recovery catalog has been configured.and Production Database has been cloned and a connection has been made from the clone to Catalog database using rman with out changing the DBID of the clone,then we are in some trouble Then when you try to backup the production instance with the catalog,The backup fails with following error RMAN-06004: ORACLE … Continue reading How to correct error RMAN-20004 »

How to add debug codes in the application executable

Last updated on December 21st, 2015 at 03:53 amIt often happens the executable are either coredumping or not behaving exactly.We need to debug the executable. Here are the General steps on How to add debug codes in the application executable. Infact these are steps even followed  by adpatch to replace lib files in the product executables Let’s say that you need to link the object file … Continue reading How to add debug codes in the application executable »

Patch history tables in Oracle Apps

Last updated on November 28th, 2015 at 12:03 pmPatch history tables in Oracle Apps AD_APPL_TOPS – Stores information about all APPL_TOPS utilizing this instance. AD_APPLIED_PATCHES – Stores information about all distinct updates applied. AD_BUGS – Stores information about all distinct bug fixes applied. AD_DRIVERS – Stores information about the drivers that comprise an update. AD_FILE_VERSIONS – Stores version information for files. AD_FILES – Stores information … Continue reading Patch history tables in Oracle Apps »

Result cache in 11g

Last updated on September 1st, 2016 at 05:21 amPrior 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 cache caching … Continue reading Result cache in 11g »

How to improving Maintenance and Reducing Patching Downtime

Last updated on November 28th, 2015 at 12:01 pmHow to improving Maintenance and Reducing Patching Downtime 1) Keep up-to-date on latest AD/OAM code AD Minipack I AD Merge Patch zip support and metadata based merge AutoConfig Integration with AutoPatch Parallel Index Creation Improved Distributed AD Maintenance Mode Improved Patch UI in OAM RAC Support for Rapid Clone 2) Schedule periodic, proactive maintenance 3) Combine patches … Continue reading How to improving Maintenance and Reducing Patching Downtime »

Distributed AD

Last updated on November 23rd, 2015 at 03:46 pm1)Distributed AD offers improved scalability, performance, and resource utilization by allowing workers of the same AD session to be started on additional middle tier systems. 2)AD has always utilized a Parallel Jobs System, where multiple AD workers start and are assigned jobs. Information for the Jobs System is stored in the database, and workers receive their assignments … Continue reading Distributed AD »

Staged APPL_TOP in R12

Last updated on September 1st, 2016 at 05:22 amA 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 can begin. … Continue reading Staged APPL_TOP in R12 »

Interconnect setup in RAC

Last updated on November 23rd, 2015 at 03:42 pmThe interconnect is a very important part of the cluster environment it is on of the aorta’s of a cluster environment. The interconnect is used as physical layer between the cluster nodes to perform heartbeats as well as the cache fusion is using it. The interconnect must be a private connection. Cross over cable is not support. … Continue reading Interconnect setup in RAC »

Oracle apps:Topology information

Last updated on November 23rd, 2015 at 03:32 pmHere is the statement to find out Topology information for R12/R11i SELECT fn.HOST || ‘.’ || fn.DOMAIN HOSTNAME, ftlp.PORT, fdi.SID SID FROM FND_DATABASES fd, FND_DATABASE_INSTANCES fdi, FND_TNS_LISTENERS ftl, FND_TNS_LISTENER_PORTS ftlp, FND_APP_SERVERS fas, FND_NODES fn WHERE fd.DB_GUID=fdi.DB_GUID AND fdi.SERVER_GUID=fas.SERVER_GUID AND ftl.LISTENER_GUID = ftlp.LISTENER_GUID AND ftl.SERVER_GUID = fas.SERVER_GUID AND fn.NODE_ID = fas.NODE_ID; select NAME, SERVER_TYPE from FND_APP_SERVERS, FND_NODES where FND_APP_SERVERS.NODE_ID … Continue reading Oracle apps:Topology information »

How to find optimizer underscore parameter

Last updated on November 23rd, 2015 at 03:31 pmHow to find optimizer underscore parameter SELECT x.ksppinm name, y.ksppstvl VALUE, ksppstcmnt update_comment FROM x$ksppi x, x$ksppcv y WHERE x.inst_id = userenv(‘Instance’) AND y.inst_id = userenv(‘Instance’) AND x.indx = y.indx AND x.ksppinm LIKE ‘%optim%%’; How to find background process information select nm, max(description) descript from (select regexp_replace( name,'[0-9a-z]’,’#’) nm, description from v$bgprocess) group by nm order by … Continue reading How to find optimizer underscore parameter »