To get the TABLESPACE SIZE from the database
select tablespace_name,sum(bytes)/1024/1024 “SIZE_IN_MB” from dba_data_files group by tablespace_name;
Read MoreTo get the datafile sizes from the database
col file_name for a70 col tablespace_name for a30 clear breaks clear computes compute sum of SIZE_IN_MB on report break on report select tablespace_name,file_name,AUTOEXTENSIBLE,INCREMENT_BY,MAXBYTES/1024/1024 “MAX in MB”,bytes/1024/1024 “SIZE_IN_MB” from dba_data_files order…
Read MoreTo get information about the database
Following queries can be used to get information about the database SET LINESIZE 150 SET PAGESIZE 50000 cOL HOST_NAME FOR A25 col LOGINS FOR A20 col STATUS for A15 col…
Read MoreGiven a portion of the profile option name – list all profile option name and their value
SELECT t.profile_option_name,v.profile_option_value FROM FND_PROFILE_OPTION_VALUES v, fnd_profile_options t, fnd_profile_options_tl tl where v.profile_option_id = t.profile_option_id and tl.profile_option_name =t.profile_option_name and tl.user_profile_option_name like ‘&Profile_option_name’
Read MoreConcurrent request running abnormally for very long time without completion
1. Identified the long running query by taking trace of the concurrent request 2. Executed the tuning advisor for the problematic query using the following steps Create Tuning Task: ===============…
Read MoreIf a Patch is applied when was it applied and what are the files affected by this patch
Step 1: Log in to Oracle Applications ManagerStep 2: Go the Simple Search pageStep 3: Select search criteriaApplied Patches Search PagesSimple Search Patch: Enter the patch number in this field.…
Read MoreIssue with using ASMLIB with Multipath Disks
During Grid infrastructure installation root.sh ran successfully in first root and it errored in the second node with the following message as it could not recognize the voting disk from…
Read MoreHow To License A New Product in Oracle Applications
1. After we purchase a license for an Application Product/Module, we have to use license manager to record that the product/module is now licensed. License manager can be run…
Read MorePatch restart on failure due to pre-requisites
If the Adpatch Fails due to a pre-requisite Patch or for some other reason and a lot of time has already been spent since the patch has started running then…
Read MorePatch Impact Analysis in Oracle Applications R12
Basic Patch Analysis:- 1) view the readme.txt in the patch directory or in metalink, 2) note all the prerequisites the patch tells about, 3) check if the prerequisites are applied,…
Read More