Technical Blog

    Tablespace Data mining   -----------------------------            Let me call some of my findings as Oracle Tablespace Data minig som...

Exdata is a hardware machine which runs oracle database; supports OLTP, Database Exologic is a hardware machine for application and primar...

Once the database time zone is set (with ALTER DATABASE SET TIME_ZONE command) and you have defined single table with a TSWLTZ column in ...

SELECT sdo_nn_distance (1) dist, a.cid, sdo_geom.sdo_min_mbr_ordinate (b.sdo_geometry, 1) x, sdo_geom.sdo_min_mbr_ordinate (b.sdo_geometry,...

- logging of job runs (job history) (maintain history and a copy of the log file in the database) - simple but powerful scheduling syntax (...