SNP Trace Files(ASG)

udump에 보면 ASG의 snp trace(snp*.trc, j00*.trc) 파일이 많이 생성된다.

사용하지 않는 모듈이어서 관련 job 삭제함.

[trace file 내용]

select 1 from all_tables where owner = 'ADMIN' and table_name = 'ASG_SERVER' and rownum = 1

2

select distinct f.oracle_username from fnd_oracle_userid f, fnd_product_installations p  where f.oracle_id = p.oracle_id and f.oracle_id = 689 and  RO

ASG

select distinct f.oracle_username from fnd_oracle_userid f, fnd_product_installations p  where f.oracle_id = p.oracle_id and f.oracle_id = 689 and  RO

[JOB 내용]

       JOB LOG_USER                       PRIV_USER                      SCHEMA_USER

---------- ------------------------------ ------------------------------ ------------------------------

LAST_DATE  LAST_SEC         THIS_DATE  THIS_SEC         NEXT_DATE  NEXT_SEC         TOTAL_TIME B

---------- ---------------- ---------- ---------------- ---------- ---------------- ---------- -

INTERVAL

--------------------------------------------------------------------------------------------------------------

  FAILURES

----------

WHAT

--------------------------------------------------------------------------------------------------------------

NLS_ENV

--------------------------------------------------------------------------------------------------------------

MISC_ENV                                                           INSTANCE

---------------------------------------------------------------- ----------

        83 APPS                           APPS                           APPS

2009-10-06 11:02:34                                     2009-10-06 11:02:44           12740156 N

sysdate+(10/(24*60*60))

         0

ASG_MOBTRAN.process_queue_transaction;

NLS_LANGUAGE='AMERICAN' NLS_TERRITORY='AMERICA' NLS_CURRENCY='$' NLS_ISO_CURRENCY='AMERICA' NLS_NUMERIC_CHARAC

TERS='.,' NLS_DATE_FORMAT='DD-MON-RR' NLS_DATE_LANGUAGE='AMERICAN' NLS_SORT='BINARY'

0102000200000000                    

[메타링크 참조문서]

Doc ID: 185902.1

fix: This job is actually used as Gateway for Oracle Mobile modules.

SQL> select job from dba_jobs where upper(what) like 'ASG_MOBTRAN%'; 

SQL> execute dbms_job.remove(:jobid);