Archive for August, 2008
SQL Query to view sql for a OS Pid / process
Select a.sid,a.serial#,b.pid,c.sql_text,a.module,
to_number(b.spid) PROCESSID,
substr(a.username, 1, 12) username
From v$session a,
v$process b,v$sql c
Where a.paddr = b.addr
and a.sql_address = c.address
and b.spid = ‘&spid’
/
SQL Query to view sql of a session
SELECT
T.sql_text
FROM
v$session S,
v$sqltext_with_newlines T
WHERE
S.sid = &sid
AND S.serial# = &serial
[...]
SQL Query to list running concurrent requests
col user_name format a20 word_wrapped
col ProgName format a25 word_wrapped
col requestId format 99999999
col StartDate format a20 word_Wrapped
col OS_PROCESS_ID format a6
col ETime [...]
Cloning or Refresh – What did I do?
Most of us use these terms, interchangeably. Is there a difference in the actual meaning of these terms, Yes, it does.
Clone – Describes when you create a new environment exactly as that of an existing environment. Eg. RAC to RAC, Multi Node Appl Top to Multi Node Appl Top
Refresh – Describes wherein you already [...]
Post Clone – Forms Error – oracle.forms.engine.RunformException: Forms session failed during startup: no response from runtime process
We recently did a clone and everything went well – autoconfig ran properly – services started sucessfully – but when we selected a responsibility which will launch a form it errored out with below message :
formsweb: Forms session exception stack trace:
oracle.forms.engine.RunformException: Forms session failed during startup: no response from runtime process
[...]
Missing Libraries during Post Clone Stage (adcfgclone.pl)
We recently faced this interesting issue during the post clone stage. All the .a and .o library files were removed during execution of adcfgclone.pl which ultimately results in relinking errors of forms and reports … strange isnt it …
Both Source and Target boxes were of the same OS configuration : HP UX 11.23 Itanium [...]
ASO_ORDER_FEEDBACK_T is huge !!!
Friends,
As part of regular house-keeping activities, we were checking for objects with huge sizes in our 11i10 apps instance and came across this object : ASO_ORDER_FEEDBACK_T
This is basically an “Order Capture” queue table that is maintained by Order Management. It works in a broadcast-subscribe concept. Order Management broadcasts evets (messages) via this queue and ANY [...]
User ‘SYSADMIN’ does not have access to notification. ORA-06512: at APPS.WF_ADVANCED_WORKLIST
Users reported that they got below error message when they were trying to view the notifications while logged in as SYSADMIN user on a development instance.
ORA-20002: 3207: User ‘SYSADMIN’ does not have access to notification .
ORA-06512: at “APPS.WF_ADVANCED_WORKLIST”, line 82
A quick check on the Workflow System Administrator Value (How to check this value) revealed that [...]
How to enable users to view other users workflow notifications
By default and design, only SYSADMIN user can view other users notifications. What if a requirement comes to enable everyone/certain group of people to view everyones notifications … this might sound crazy for a production environment but its a valid request on a Development environment.
Ok coming to the technicalities,
Step 1: Login as SYSADMIN User
Step 2: [...]
