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') …

How large is the Oracle Database? Gain a comprehensive overview of database size, free space, and used space to proactively manage storage resources and plan for future growth. SQL Code 1col "Database Size" format a20 2col "Free space" format a20 3col "Used space" format a20 4select round(sum(used.bytes) / 1024 / 1024 …