Re: v$sql how to distinguish between internal dictionary selects and user selects

On Sun, 15 Oct 2006 16:31:22 -0700, DA Morgan wrote:

> In 10gR2 gv$sql contains a SERVICE column too.

Service column is not usable for that purpose. Service column is for attaching processes to services, like jobs started by DBMS_SCHEDULER. You can create a service by using DBMS_SERVICE (srvctl in the RAC environment) and attach a job class to that service. DBMS_SERVICE.STOP_SERVICE can then be used as a "stop all" command which will stop all jobs in that class. It can also be used to attach jobs to a particular instance as service can be started on the particular instance in a RAC environment. That replaces instance affinity of DBMS_JOBS.

-- 
http://www.mladen-gogala.com