Kaley's (mostly) Oracle Database Blog
Hi! I'm Kaley Crum, Oracle DBA.
Welcome to my (mostly) Oracle database blog.

Archive: Feb 2017

DBMS_PARALLEL_EXECUTE Example

You may know that pulling data over a database link is serial, which is a great opportunity to take advantage of DBMS_PARALLEL_EXECUTE.

Here’s an example of how to pull something over a database link in parallel.

 

 

Oracle Java Procedure Example

I had a book tell  me that Java procedures couldn’t be scheduled using DBMS_SCHEDULER, which I didn’t buy because I had just read in another book that you *could* schedule Java procedures using DBMS_SCHEDULER.  I tried it for my self…turns out, you can, in fact, schedule Java procedures.  Here’s the proof (from Oracle 11.2).