Monitoring ASM Operations in Oracle Database, Using thev$asm_operationView SQL Code 1select * 2from v$asm_operation 3/ Mount/dismount disk groups 1alter diskgroup all mount 2/ 1alter diskgroup data1 mount 2/ 1alter diskgroup all dismount 2/ 1alter diskgroup data1 dismount 2/ Description of the Oracle Database SQL code …

Removing a Disk Group Permanently in Oracle Database, The drop diskgroup Command SQL Code 1drop diskgroup '<name>' 2/ Description of the Oracle Database SQL code Purpose: The primary purpose of this SQL code is to permanently remove an entire disk group, identified by its name, from the Oracle database environment. …

Expanding Storage Capacity in Oracle Database, Adding a Disk to Diskgroup Data1 SQL Code Note: Wildcards can be used for raw device names (eg. raw* 1alter diskgroup data1 2add disk '/dev/raw/raw4' 3/ Sample Oracle Output 1no rows selected 2SQL> Description of the Oracle Database SQL code Purpose: The primary purpose of …

Creating an ASM Disk Group with External Redundancy in Oracle SQL Code 1create diskgroup data1 2external redundancy 3disk '/dev/raw/raw1' 4/ Or with multiple raw partitions SQL Code 1create diskgroup data1 2external redundancy 3disk '/dev/raw/raw1' 4/ Or with multiple fail groups... SQL Code 1create diskgroup data3 …

Querying ASM Disk Information in Oracle SQL Code 1select name 2, group_number 3, disk_number 4, total_mb 5, free_mb 6from v$asm_disk 7order by group_number 8/ Sample Oracle Output 1no rows selected 2SQL> Purpose: Retrieves and displays key information about Automatic Storage Management (ASM) disks within the database. …

Visualizing Disk Groups in Oracle ASM with SQL Note: A group number of zero his indicates that a disk is available but hasn't yet been assigned to a disk group. SQL Code 1set lines 100 2col name format a10 3col path format a30 4select name 5, group_number 6, disk_number 7, mount_status 8, state 9, path 10from …

Checking Cluster Health with crsctl check cssd SQL Command 1crsctl check cssd Purpose: To verify the status and health of the Cluster Synchronization Services (CSS) daemon (cssd), a crucial component of Oracle Clusterware. It's typically used in Oracle Real Application Clusters (RAC) and Oracle Automatic Storage …

Examining Role Table Privileges in Oracle Using role_tab_privs This page delves into an Oracle SQL code snippet that investigates table privileges granted to a specific role. SQL Code 1select owner || '.' || table_name "TABLE" 2, column_name 3, privilege 4, grantable 5from role_tab_privs 6where role like '&role' 7/ …

Find an Oracle role using the view dba_roles This page explores an Oracle SQL code snippet that retrieves information about database roles based on user-provided search criteria. SQL Code 1select * 2from dba_roles 3where role like '&role' 4/ Purpose: This code retrieves information about a specific database role, based …

Retrieving User Role Privileges in Oracle using the view dba_role_privs This page examines an Oracle SQL code snippet that fetches granted roles and their associated admin options for a specified user. SQL Code 1select grantee 2, granted_role 3, admin_option 4from dba_role_privs 5where grantee like upper('&username') …