PL/SQL Packages and Types Reference 10g Release 1 (10.1) Part Number B10802-01 |
|
|
View PDF |
The DBMS_SERVICE package lets you create, delete, activate and deactivate services for a single instance.
The chapter contains the following topics:
See Also:
|
The client using this package should have the ALTER
SYSTEM
execution privilege and the V$SESSION
table read privilege.
Subprogram | Description |
---|---|
Creates service | |
Deletes service | |
Disconnects service | |
Activates service | |
Stops service |
This procedure creates a service name in the data dictionary. Services are also created in the data dictionary implicitly when you set the service in the servive_names parameter or by means of the ALTER
SYSTEM
SET
service_names
command.
DBMS_SERVICE.CREATE_SERVICE( service_name IN VARCHAR2, network_name IN VARCHAR2);
DBMS_SERVICE.CREATE_SERVICE('ernie.us.oracle.com','ernie.us.oracle.com');
This procedure deletes a service from the data dictionary.
DBMS_SERVICE.DELETE_SERVICE( service_name IN VARCHAR2);
Parameter | Description |
---|---|
|
The name of the service limited to 64 characters in the Data Dictionary. |
DBMS_SERVICE.DELETE_SERVICE('ernie.us.oracle.com');
This procedure disconnects sessions with the named service at the current instance.
DBMS_SERVICE.DISCONNECT_SESSION( service_name IN VARCHAR2);
Parameter | Description |
---|---|
|
The name of the service limited to 64 characters in the Data Dictionary |
This procedure can be used in the context of a single instance as well as with Real Application Clusters.
DBMS_SERVICE.DISCONNECT_SESSION('ernie.us.oracle.com');
This disconnects sessions with service_name
'ernie.us.oracle.com'
.
This procedure starts a service.
DBMS_SERVICE.START_SERVICE( service_name IN VARCHAR2, instance_name IN VARCHAR2);
Parameter | Description |
---|---|
|
The name of the service limited to 64 characters in the Data Dictionary. |
|
The name of the instance where the service should be activated (optional). |
DBMS_SERVICE.START_SERVICE('ernie.us.oracle.com');
This procedure stops a service.
DBMS_SERVICE.STOP_SERVICE( service_name IN VARCHAR2, I instance_name IN VARCHAR2);
Parameter | Description |
---|---|
|
The name of the service limited to 64 characters in the Data Dictionary. |
|
The name of the instance where the service should be stopped (optional). |
DBMS_SERVICE.STOP_SERVICE('ernie.us.oracle.com');