Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2008
    Posts
    464

    Unanswered: sysdate and localtimestmap - 10g

    Hi guys

    I'm in the timezone GMT+4.

    My 10g DB shows:

    Code:
    SELECT DBTIMEZONE FROM DUAL: -04:00
    SELECT SESSIONTIMEZONE FROM DUAL: +04:00
    Code:
    SELECT SYSDATE FROM DUAL;
    SELECT LOCALTIMESTAMP FROM DUAL;
    SELECT CURRENT_TIMESTAMP FROM DUAL;
    all show the datetime of the OS.

    The issue is that the application is sending out reports approx 8hrs after the scheduled time.

    Any ideas why?

  2. #2
    Join Date
    Feb 2006
    Posts
    173
    Provided Answers: 1
    How are you scheduling the job(via cron, dbms_scheduler, etc)?
    Post what the scheduled job looks like.

  3. #3
    Join Date
    Aug 2008
    Posts
    464
    The report to be sent out is scheduled via the application. It's not set up as an individual job in oracle.

    I tried to get the background SQL in SQL MON but nothing returns although I can select the particular app in SQL MON. But when the app is running, nothing appears in SQLMON. OS: Win7 (64-bit) and Oracle 10g.
    Last edited by shajju; 10-17-12 at 05:45.

  4. #4
    Join Date
    Feb 2006
    Posts
    173
    Provided Answers: 1
    Ok, Then how is the application scheduling the job(s)?

    You can view different job schedule info via:
    Code:
    select * from dba_jobs
    select * from dba_scheduler_schedules
    select * from dba_scheduler_jobs
    select * from dba_scheduler_job_log order by log_date desc
    select * from dba_scheduler_job_run_details order by log_date desc

  5. #5
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >I tried to get the background SQL in SQL MON
    What is SQL MON?
    post URL where it is documented.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •