oradebug iutility s especially useful when  things go very bad for example Database hangs,Due to ORA-00600 error your database is crashing frequently, Database just not responding (stop). With oradebug you can see very close view database engine. Oracle Customer support use the utility mainly to debug these issues. You should have sysdba privilege to run this […]

Popularity: 13% [?]

continue reading.....

Source: Oracle Documentations
It is possible to transfer statistics between servers allowing consistent execution plans between servers with varying amounts of data. First the statistics must be collected into a statistics table. In the following examples the statistics for the APPSCHEMA user are collected into a new table, STATS_TABLE, which is owned by DBASCHEMA:
  SQL> EXEC […]

Popularity: 9% [?]

continue reading.....

1)How to check if the partitions of a table are set to LOGGING
select partition_name, logging
from dba_tab_partitions
where table_name=’WF_LOCAL_ROLES’;
2)How to Correct Session Cookie Name.
a)select session_cookie_name from icx_parameters;
b)update icx_parameters set session_cookie_name = ‘<hostname_sid>’;
c)select session_cookie_name from icx_parameters;
3) How to find database SID from a Concurrent request.
column process heading “FNDLIBR PID”
SELECT a.request_id, d.sid, d.serial# ,d.osuser,d.process , c.SPID
FROM apps.fnd_concurrent_requests a,
apps.fnd_concurrent_processes b,
v$process […]

Popularity: 10% [?]

continue reading.....

 Source: Oracle Documentations 
Log and Output files retention policy can be controlled by you at o/s level. Once you decide the retention policy for these logs and output files, the Purge Concurrent Request Concurrent Program or the Manager Data Concurrent Program will act, based on the information located in the database tables to determine which files […]

Popularity: 7% [?]

continue reading.....

Workflow Scripts: Source Oracle Documentations
The below are the collection of Workflow Administration Scripts and/or Concurrent Program.
1. FNDWFPR
For Oracle Workflow embedded in Oracle Applications, use the standard concurrent program FNDWFPR ”Purge Obsolete Workflow Runtime Data” to purge old data from the Oracle Workflow runtime tables regularly. Navigate to the Submit Requests form in Oracle Applications to […]

Popularity: 11% [?]

continue reading.....