AskTom

SQL> col nm for a8
select nm, max(description) descript
from
(select regexp_replace( name, ‘[0-9a-z]‘, ‘#’ ) nm, description
from v$bgprocess)
group by nm
order by nm
/SQL>

NM       DESCRIPT
——– —————————————————————-
ACMS     Atomic Controlfile to Memory Server
ARB#     ASM Rebalance 9
ARBA     ASM Rebalance 10
ARC#     Archival Process 9
ASMB     ASM Background
CJQ#     Job Queue Coordinator
CKPT     checkpoint
CTWR     Change Tracking Writer
DBRM     Resource Manager process
DBW#     db writer process 9
DIA#     diagnosibility process 9
DIAG     diagnosibility process
DMON     DG Broker Monitor Process
DSKM     slave DiSKMon process
EMNC     EMON Coordinator
FBDA     Flashback Data Archiver Process
FMON     File Mapping Monitor Process
FSFP     Data Guard Broker FSFO Pinger
GMON     diskgroup monitor
GTX#     Global Txn process 9
INSV     Data Guard Broker INstance SlaVe Process
LCK#     Lock Process 0
LGWR     Redo etc.
LMD#     global enqueue service daemon 0
LMON     global enqueue service monitor
LMS#     global cache service process 9
LNS#     Network Server 9
LSP#     Set Guard Standby Information for Logical Standby
MARK     mark AU for resync koordinator
MMAN     Memory Manager
MMNL     Manageability Monitor Process 2
MMON     Manageability Monitor Process
MRP#     Managed Standby Recovery
NSV#     Data Guard Broker NetSlave Process 9
OFSC     OFS CSS
PING     interconnect latency measurement
PMON     process cleanup
PSP#     process spawner 0
QMNC     AQ Coordinator
RBAL     ASM Rebalance master
RCBG     Result Cache: Background
RECO     distributed recovery
RMS#     rac management server
RSM#     Data Guard Broker Resource Guard Process 1
RSMN     Remote Slave Monitor
RVWR     Recovery Writer
SMCO     Space Manager Process
SMON     System Monitor Process
VBG#     Volume BG 9
VDBG     Volume Driver BG
VKTM     Virtual Keeper of TiMe process

51 rows selected.

SQL>

Regards,

Tom

Hi,

there are two ways how to get information about disk group usage.

Sqlplus
——–

SQL> set lines 255
SQL> col path for a35
SQL> col Diskgroup for a15
SQL> col DiskName for a20
SQL> col disk# for 999
SQL> col total_mb for 999,999,999
SQL> col free_mb for 999,999,999
SQL> compute sum of total_mb on DiskGroup
SQL> compute sum of free_mb on DiskGroup
SQL> break on DiskGroup skip 1 on report -
>
SQL> set pages 255
SQL>
SQL> select a.name DiskGroup, b.disk_number Disk#, b.name DiskName, b.total_mb, b.free_mb, b.path, b.header_status
2  from v$asm_disk b, v$asm_diskgroup a
3  where a.group_number (+) =b.group_number
4  order by b.group_number, b.disk_number, b.name
5  /

set lines 122
set pages 66
DISKGROUP       DISK# DISKNAME                 TOTAL_MB      FREE_MB PATH       HEADER_STATU
————— —– ——————– ———— ———— ———————————– ————
DATA                0 DATA                      238,747       37,328 ORCL:DATA  MEMBER
***************                            ———— ————
sum                                             238,747       37,328

ASMCMD tool
———–

oracle@antarctic:~> asmcmd
ASMCMD> lsdg
State    Type    Rebal  Sector  Block       AU  Total_MB  Free_MB Req_mir_free_MB  Usable_file_MB  Offline_disks  Name
MOUNTED  EXTERN  N         512   4096  1048576    238747    37293 0           37293              0  DATA/

Regards,

Tom

DISABLE Database vault

1) Shutdown database
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit

2) Stop database control
[oracle@centos53 datvault]$ emctl stop dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.1.0.6.0
Copyright (c) 1996, 2007 Oracle Corporation.  All rights reserved.
https://centos53.server.cz:1158/em/console/aboutApplication
Stopping Oracle Enterprise Manager 11g Database Control ……  Stopped.

3) Relink Oracle

[oracle@centos53 datvault]$ cd $ORACLE_HOME/rdbms/lib
[oracle@centos53 lib]$ make -f ins_rdbms.mk dv_off
/usr/bin/ar d /u01/app/oracle/product/11.1.0/db_1/rdbms/lib/libknlopt.a kzvidv.o
/usr/bin/ar cr /u01/app/oracle/product/11.1.0/db_1/rdbms/lib/libknlopt.a /u01/app/oracle/product/11.1.0/db_1/rdbms/lib/kzvndv.o
[oracle@centos53 lib]$ cd $ORACLE_HOME/bin
[oracle@centos53 bin]$ relink oracle

4) startup database

[oracle@centos53 bin]$ sqlplus / as sysdba

SQL*Plus: Release 11.1.0.6.0 - Production on Wed Jan 13 11:43:00 2010

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area  238530560 bytes
Fixed Size                  1299116 bytes
Variable Size             155192660 bytes
Database Buffers           79691776 bytes
Redo Buffers                2347008 bytes
Database mounted.
Database opened.

5) Disable triggers
SQL> ALTER TRIGGER DVSYS.DV_BEFORE_DDL_TRG DISABLE;

Trigger altered.

SQL> ALTER TRIGGER DVSYS.DV_AFTER_DDL_TRG DISABLE;

Trigger altered.

ENABLE Database vault

ALTER TRIGGER DVSYS.DV_BEFORE_DDL_TRG ENABLE;
ALTER TRIGGER DVSYS.DV_AFTER_DDL_TRG ENABLE;

make -f ins_rdbms.mk dv_on

Regards,

Tom