| |
 |
|
Oracle Tips by Burleson |
Workspaces in Oracle9i
The concept of a database workspace was introduced with Oracle9i. A
workspace is an environment for a long-term transaction that allows
multiple versions of objects and can be shared among many users. The
workspace environment is managed through a series of short
transactions and multiple data versions that lead to a complete
long-term transaction event. This process maintains atomicity, as
well as concurrency.
The Workspace Manager (WKS) is installed by default in all seed and
DBCA databases. If it is needed in a manually created database, it
must be installed following the guide in the Oracle9i Application
Developers Guide--Workspace Manager, Release 1 9.0.1, PART#
A88806-01, Oracle Corporation, June 2001.
* workspace_status.sql
-- *************************************************
-- Copyright © 2005 by Rampant TechPress
-- This script is free for non-commercial purposes
-- with no warranties. Use at your own risk.
--
-- To license this script for a commercial purpose,
-- contact info@rampant.cc
-- *************************************************
COLUMN WORKSPACE FORMAT a10 HEADING 'Workspace'
COLUMN owner FORMAT a10 HEADING 'Owner'
COLUMN freeze_status FORMAT a8 HEADING 'Freeze|Status'
COLUMN resolve_status FORMAT a8 HEADING 'Resolve|Status'
COLUMN parent_workspace FORMAT a10 HEADING 'Parent|Workspace'
COLUMN freeze_mode FORMAT a8 HEADING 'Freeze|Mode'
ttitle 'Workspace_Status'
spool workspace_status
select
workspace,
NVL(parent_workspace,'NONE') parent_workspace,
owner,
freeze_status,
NVL(freeze_mode,'NONE') freeze_mode,
resolve_status
from
dba_workspaces
;
spool off
ttitle off
The following is a sample listing from the above query:
Parent Freeze Freeze Resolve
Workspace Workspace Owner Status Mode Status
---------- ---------- ---------- -------- -------- --------
LIVE NONE SYS UNFROZEN NONE INACTIVE
Other items, such as workspace privileges and save points, can also
be monitored using the dba_ series of views. The next section will
examine the pga_aggregate_target
The above book excerpt is from:
Oracle
Tuning Power Scripts
With 100+ High Performance
SQL Scripts
Oracle In-Focus Series
ISBN
0-9744486-7-2
Mike Ault, Donald K.
Burleson. Harry Conway
http://www.rampant-books.com/book_2005_1_power_tuning.htm |
