Actually in Execute DBMS_JOB.SUBMIT(:Jobno,'Analyze_object(''TABLE'',''DEPT'');',SYSDATE+1/288) ,its said that this job will be done in 5 minutes from now.So can anyone explain how does 1/288 represent 5 minutes from now? Thanks.
How to Unravel a Tricky Query
If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them. …
This post first appeared at Oracleinaction (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself).
I will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines