Thought And Prayers Are Not Enough
May 8th, 2018, posted in WordsFind Concurrent Manager Jobs By Query
May 6th, 2018, posted in Concurrent Request, Oracle QueriesQuery :
select sess.sid, sess.sql_hash_value, oracle_process_id OS_PROCESS_ID, fusr.description user_name , fcp.user_concurrent_program_name progName, to_char(actual_Start_date,'DD-MON-YYYY HH24:MI:SS') StartDate, request_id RequestId, (sysdate - actual_start_date)*24*60 ETime_in_Mins from apps.fnd_concurrent_requests fcr, apps.fnd_concurrent_programs_tl fcp, apps.fnd_user fusr, v$session sess where fcp.concurrent_program_id = fcr.concurrent_program_id and fcr.program_application_id = fcp.application_id and fcp.language = 'US' and fcr.phase_code = 'R' and fcr.status_code = 'R' and fcr.requested_by = fusr.user_id and fcr.oracle_session_id = sess.audsid (+) -- and p.addr = sess.paddr order by 6 DESC
Prophet Muhammad About Labours Right
May 1st, 2018, posted in DAtEs iN a YeAR, MESSAGEs, Saying Of Holy Prophet ( P.B.U.H)
Tar: .file too large to archive. Use E function modifier
April 30th, 2018, posted in Solaris
tar: .file too large to archive. Use E function modifier.
Using TAR for big files ( > 8GB)
In Unix environment, If you are trying to “tar” OS files that is bigger than 8 GB of size. Following error is observed.
Regular tar command:
tar -cvf test.dmp.tar test.dmp
Error:
tar: test.dmp too large to archive. Use E function modifier.
Solution:
tar -cvEf test.dmp.tar test.dmp