I use the database paas trial service. I want to run long-running plsql procedures. (These procedures run several hours on my laptop.) I quickly ran into the 30sec hard limit for user processes. Is there any way to change this limit on my service? Or should I use a different service? Are there any public cloud services to support this kind of requirements?
Thanks for your interest in the Database Cloud Service. There is no real easy answer on the Service side for your question. You might consider the upcoming Oracle Cloud Database as a Service offering, but it is not due out until CY2014. I cannot comment on any limitations on other Cloud services, but good luck.