IsWorkspaceOccupied Function

This function checks whether or not a workspace has any active sessions.

Syntax

DBMS_WM.IsWorkspaceOccupied(
   workspace  IN VARCHAR2) 
RETURN VARCHAR2;

Parameters

Table 70-21 IsWorkspaceOccupied Function Parameters  

Parameter	Description
workspace	Name of the workspace. The name is case sensitive.

Usage Notes

This function returns YES if the workspace has any active sessions and NO if the workspace has no active sessions.

An exception is raised if the LIVE workspace is specified or if the user does not have the privilege to access the workspace.

Examples

The following example checks if any sessions are active in the B_focus_2 workspace.

SELECT DBMS_WM.IsWorkspaceOccupied('B_focus_2') FROM DUAL;

DBMS_WM.ISWORKSPACEOCCUPIED('B_FOCUS_2')                                                 
--------------------------------------------------------------------------------
YES