Archive for July, 2008
Database Replace Function to change profile option values
Heres an example of using the replace() to update profile_option_value column in fnd_profile_option_values table.
Scenario: Imagine you did a clone from DEV to TEST and in DEV there were lot of profile option values set at the responsibility and user level for the discoverer viewer url which came as is to TEST. Now you want to [...]
Active Users concurrent program never completes after clone
Recently we did a clone (R12). Everything worked as expected, except for Active Users Concurrent program which never completed when submitted. The status remains Running – Normal for hours together. But “Prints environment variable values” concurrent program completed within no time.
This is how the issue was approached and resolved.
1. This is not a concurrent manager [...]
How to execute / run a report manually from command prompt
Eg. Active Users
rwrun report=FNDSCURS.pdf userid=apps/[passwd] desformat=xml destype=file desname=AU.xml
cheers,
OraclePitStop
How to enable / generate trace for a concurrent program
Login as Sysadmin -> System Administrator -> Concurrent : Program -> Define
Press F11 -> Enter the COncurrent Program Name (Eg. Active Users) -> Press Ctrl + F11
Enable the check box “Enable Trace” above “Copy To” button.
Click on Save.
Close the window.
Select Requests -> Run
Submit the concurrent request.
After completion or during execution of the request, you should [...]
Ad-hoc tips (fbackup/frecover commands in HP-UX)
We use HP-UX for running one of our 11i instances and i manage the backups using fbackup and frecover commands. I am sharing the syntax for some of the basic commands. Hope it would help.
======== Fbackup =========
(1)
Create a defaults file (eg, defaults.prod) and include/exclude file systems to be backed up/excluded.
$ cat defaults.prod
i /u02/oracle
e /u02/oracle/proddb/8.1.6
i /u07/oracle/proddata
This [...]
Ad-hoc Tips (HIT and MISS Ratios)
Got few useful scripts to check HIT and MISS ratios… Wanted to share the same. Check out below scripts.
prompt
prompt =========================
prompt DATA DICTIONARY HIT RATIO
prompt =========================
prompt Should be higher than 90 else increase shared_pool_size in init.ora prompt
column “Data Dict. Gets” format 999,999,999
column “Data Dict. cache misses” format 999,999,999
select sum(gets) “Data Dict. Gets”,
sum(getmisses) “Data Dict. cache misses”,
trunc((1-(sum(getmisses)/sum(gets)))*100) [...]
Ad-hoc tips (High Water Mark)
This is another tip which i used recently.
Whenever, we get alerted about a tablespace reaching threshold levels, our immediate action would be to add a datafile. In some cases, we can resize/shrink the datafiles of the tablespaces to gain space. This can be done by knowing the high-water mark of the datafile.
Metalink Note : 130866.1 [...]
Ad-hoc Tips (Database Links)
Hope the Apps DBA community is doing great and is (as always) ever busy.This post is a small tip that might be of use.
Occasionally,in small companies (and most often in big companies),
there will be a necessity to create DB links between Apps database
and some legacy/standalone Oracle database.
We obviously don’t want them to
connect to our database [...]
« Previous Entries
