|Oracle9i OLAP Services Developer's Guide to the OLAP DML
Release 1 (9.0.1)
Part Number A86720-01
Defining and Working with Analytic Workspaces, 9 of 12
An analytic workspace can be accessed simultaneously by several sessions. However, only one session can have the analytic workspace open with read/write access at any given time.
When you attach an analytic workspace, your default access to it is read-only. OLAP Services supports simultaneous access for one writer and many readers of an analytic workspace. Provided your user ID has the appropriate access rights, you can always get read-only access to an analytic workspace, no matter how many other users are using it. If another user has read/write access and updates the analytic workspace, then your view of the analytic workspace does not change; you must detach and reattach the analytic workspace to see the changes.
If you want read/write access, then you must explicitly specify it in the DATABASE command. If you request read/write access to an analytic workspace that is being used in read/write mode by another session, whether or not OLAP Services waits for the analytic workspace and the message OLAP Services returns to the application depends on how you have coded the DATABASE command as described in "Waiting for an analytic workspace".
You can specify whether or not you want to wait until an analytic workspace is available for the type of access you are you are requesting by using the WAIT and NOWAIT keywords of the DATABASE command.
If your analytic workspaces are in use almost all of the time, you need to develop a strategy for attaching the analytic workspace in read/write, exclusive mode. Some possible strategies are listed below:
You can submit batch jobs using the OLAP Service Manager (
xscosvc). You can define scripts that invoke
xscosvc. You can schedule the running of these scripts with the Unix
cron facility, the Windows NT
at command, or the job-scheduling facility within Oracle Enterprise Manager. For more information about input files, refer to the INFILE command in the OLAP DML Reference.