From the trace log of oracle, i found 1 file that mention ORA$A_SQ_SQL_SW running and give the below information. One of them information said status=(pst=ERROR). What does it mean? from the alert log didnt show anything about this error.
*** 2014-06-23 20:31:37.336
*** MODULE NAME:(DBMS_SCHEDULER) 2014-06-23 20:31:37.336
*** ACTION NAME:(ORA$AT_SQ_SQL_SW_753) 2014-06-23 20:31:37.336
status=(pst=SUCCESS)
**************************************************************
Execution Statistics
Exec count: 1
CR gets: 24004
CU gets: 1
Disk Reads: 0
Disk Writes: 0
IO Read Requests: 0
IO Write Requests: 0
Bytes Read: 0
Bytes Written: 0
Bytes Exchanged with Storage: 0
Bytes Exchanged with Disk: 0
Bytes Simulated Read: 0
Bytes Simulated Returned: 0
Elapsed Time: 23 (s)
CPU Time: 19 (s)
User I/O Time: 0 (us)
*** 2014-06-23 20:32:42.449
status=(pst=SUCCESS)
**************************************************************
Execution Statistics
Exec count: 1
CR gets: 24003
CU gets: 0
Disk Reads: 0
Disk Writes: 0
IO Read Requests: 0
IO Write Requests: 0
Bytes Read: 0
Bytes Written: 0
Bytes Exchanged with Storage: 0
Bytes Exchanged with Disk: 0
Bytes Simulated Read: 0
Bytes Simulated Returned: 0
Elapsed Time: 21 (s)
CPU Time: 19 (s)
User I/O Time: 0 (us)
status=(pst=SUCCESS)
**************************************************************
Execution Statistics
Exec count: 1
CR gets: 62
CU gets: 0
Disk Reads: 0
Disk Writes: 0
IO Read Requests: 0
IO Write Requests: 0
Bytes Read: 0
Bytes Written: 0
Bytes Exchanged with Storage: 0
Bytes Exchanged with Disk: 0
Bytes Simulated Read: 0
Bytes Simulated Returned: 0
Elapsed Time: 246 (us)
CPU Time: 200 (us)
User I/O Time: 0 (us)
status=(pst=ERROR)
status=(pst=ERROR)
status=(pst=SUCCESS)
**************************************************************
Execution Statistics
Exec count: 1
CR gets: 30
CU gets: 0
Disk Reads: 0
Disk Writes: 0
IO Read Requests: 0
IO Write Requests: 0
Bytes Read: 0
Bytes Written: 0
Bytes Exchanged with Storage: 0
Bytes Exchanged with Disk: 0
Bytes Simulated Read: 0
Bytes Simulated Returned: 0
Elapsed Time: 103 (us)
CPU Time: 199 (us)
User I/O Time: 0 (us)
status=(pst=ERROR)
status=(pst=SUCCESS)
**************************************************************
Execution Statistics
Exec count: 1
CR gets: 17
CU gets: 0
Disk Reads: 0
Disk Writes: 0
IO Read Requests: 0
IO Write Requests: 0
Bytes Read: 0
Bytes Written: 0
Bytes Exchanged with Storage: 0
Bytes Exchanged with Disk: 0
Bytes Simulated Read: 0
Bytes Simulated Returned: 0
Elapsed Time: 93 (us)
CPU Time: 100 (us)
User I/O Time: 0 (us)