Itrprof – analizador de arquivos gerados pelo tkprof evento 10046 Outubro 31, 2007
Posted by heliodias in Uncategorized.add a comment
Encontrando usuarios do Oracle Application Outubro 29, 2007
Posted by heliodias in Uncategorized.add a comment
select
d.user_name “User Name”,
b.sid SID,b.serial# “Serial#”, c.spid “srvPID”, a.SPID “ClPID”,
to_char(START_TIME,’DD-MON-YY HH:MM:SS’) “STime”
from
fnd_logins a, v$session b, v$process c, fnd_user d
where
b.paddr = c.addr
and a.pid=c.pid
and a.spid = b.process
and d.user_id = a.user_id
and (d.user_name = ‘
APPS SID Outubro 29, 2007
Posted by heliodias in Uncategorized.add a comment
select v.request_id,
s.sid,
s.serial#,
p.spid
from fnd_conc_requests_form_v v,
v$process p,
v$session s
where v.request_id like PUT_REQ_NUMBER
and v.oracle_process_id = p.spid(+)
and p.addr = s.paddr(+);
put req number and get the session info sid and pid
FND_USER Outubro 29, 2007
Posted by heliodias in Uncategorized.add a comment
Tabela do oracle applications
Xadrez para tres Outubro 26, 2007
Posted by heliodias in Uncategorized.add a comment
http://www.endprod.com/chess/3a.htm
google “chess for three”
Terminal Service Manager Outubro 26, 2007
Posted by heliodias in Uncategorized.add a comment
Remote Desktop Control
Building Your Own Alert Mechanism Outubro 25, 2007
Posted by heliodias in Uncategorized.add a comment
You can use the following steps to set up a threshold and alert mechanism if you do not want
to use the EM Database Control:
1. Query V$METRICNAME to identify the metrics in which you are interested.
2. Set warning and critical thresholds using the DBMS_SERVER_ALERT.SET_THRESHOLD
procedure.
3. Subscribe to the ALERT_QUE AQ using the DBMS_AQADM.ADD_SUBSCRIBER procedure.
4. Create an agent for the subscribing user of the alerts using the DBMS_AQADM.CREATE_
AQ_AGENT procedure.
5. Associate the user with the AQ agent using the DBMS_AQADM.ENABLE_DB_ACCESS
procedure.
6. Grant the DEQUEUE privilege using the DBMS_AQADM.GRANT_QUEUE_PRIVILEGE procedure.
7. Optionally register for the alert enqueue notification using the DBMS_AQ.REGISTER
procedure.
8. Configure e-mail using the DBMS_AQELM.SET* procedures.
