I know you can write SQL queries to find out what's going on inside Oracle' Concurrent manager - it's pretty easy to find such scripts on Google. The implication is that part or all of the Concurrent Manager subsystem is maintained in Oracle tables. Question: Is is also possible to submit jobs via Java and/or SQL requests? That is, can a Java app perform the same operations as the CONCSUB utility?
Experience keeps a dear School, but Fools will learn in no other.
---
Benjamin Franklin - Postal official and Weather observer
Tim, I think it all depends on how you have JDBC log into your Oracle system. If you log in with just a user, then the user will only have access to the same tables that they would get if they were using SQLPLUS. including user_tables. They are all available based on your grants, etc. Mark
