OS Quick Tit Bits

1,$s/^/###Ram###/g - disable

1,$s/^###Ram###/g - enable

admanagedsrvctl.sh stopall oacore

admanagedsrvctl.sh stop oacore_server1

$EBS_DOMAIN/servers/

tfactl alertsummary

=====

ps -eo pcpu,pid,user,args|tail -n +2|sort -k1 -r -n|head -20

netstat -a|grep 7001

ps -eaf|grep 7001

du -sh *|grep G

ps -ef|grep -i tns

find .  -type f -size +100M -exec ls -lh {}\;|awk \{print $5,$9}'

find . -type f -mtime +8  -exec ls -ltr {}\;

select to_char(RESETLOGS_TIME, 'DD-MON-YYYY, hh24:mi:ss') from v$database;

=================

select originating_timestamp, inst_id, record_id,message_text from sys.X$DBGALERTEXT where originating_timestamp>systimestamp-1 and regexp_like(message_text, '(ORA-|error|fatal|Reason=alter system kill session)') and message_text not like '%opiodr aborting process unknown ospid%' and message_text not like '%E-Business Suite Patch Edition does not exist%';

======

. $RUN_BASE/../EBSapps.env RUN

. $RUN_BASE/../EBSapps.env PATCH

. $RUN_BASE/../../ETCC/CheckMTpatch.sh

==========

SELECT distinct t.user_concurrent_program_name,

r.REQUEST_ID,u.USER_NAME,

to_char(r.ACTUAL_START_DATE,'dd-mm-yy hh24:mi:ss') "Started at",

to_char(r.ACTUAL_COMPLETION_DATE,'dd-mm-yy hh24:mi:ss') "Completed at",round(((nvl(v.actual_completion_date,sysdate)-v.actual_start_date)*24*60)) Etime,

decode(r.PHASE_CODE,'C','Completed','I','Inactive','P ','Pending','R','Running','NA') phasecode,

decode(r.STATUS_CODE, 'A','Waiting', 'B','Resuming', 'C','Normal', 'D','Cancelled', 'E','Error', 'F','Scheduled', 'G','Warning', 'H','On Hold', 'I','Normal', 'M',

'No Manager', 'Q','Standby', 'R','Normal', 'S','Suspended', 'T','Terminating', 'U','Disabled', 'W','Paused', 'X','Terminated', 'Z','Waiting') "Status",r.argument_text "Parameters"

FROM

apps.fnd_concurrent_requests r ,

apps.fnd_concurrent_programs p ,

apps.fnd_concurrent_programs_tl t,

apps.fnd_user u, apps.fnd_conc_req_summary_v v

WHERE 

r.CONCURRENT_PROGRAM_ID = p.CONCURRENT_PROGRAM_ID

AND r.actual_start_date >= (sysdate-103)

--AND r.requested_by=22378

AND   r.PROGRAM_APPLICATION_ID = p.APPLICATION_ID

AND t.concurrent_program_id=r.concurrent_program_id

AND r.REQUESTED_BY=u.user_id

AND v.request_id=r.request_id

--AND r.request_id ='2260046' in ('13829387','13850423')

and t.user_concurrent_program_name like '%Purge%'

order by to_char(r.ACTUAL_COMPLETION_DATE,'dd-mm-yy hh24:mi:ss')