An automatic job running via DBMS_JOB has failed. Knowing
only that "it's failed", how do you approach troubleshooting
this issue?
Answer Posted / braj123
>>First check the alert.log file for what reason the job
failed.
>>
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
Query processing is slow(eg select query)how will u solve that
Why would you use sql agent? : sql server DBA
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
Where would you look for errors from the database engine?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
how can you record information about current session?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What the different types of replication and why are they used? : sql server DBA
what are the performance views in an oracle rac environment?
what are the types of connection load-balancing?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?