Scripts

Removing a Disk Group Permanently in Oracle Database, The drop diskgroup Command SQL Code 1drop diskgroup <name> including contents 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 …

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', '/dev/raw/raw2' 4/ Or with multiple fail groups... SQL Code 1create …

Querying ASM Disk Information in Oracle A disk group that reports plenty of free space can still be one disk failure away from trouble, and a LUN the storage team says is ready can still be invisible to ASM. Both show up in one query against v$asm_disk: the per-disk free space, and the group 0 rows for disks not yet in …

Visualizing Disk Groups in Oracle ASM with SQL Purpose V$ASM_DISK is the view that lists every disk the Oracle ASM instance finds, including disks that are not part of any disk group. The query below reads six of its columns and sorts the rows by disk group number. The result is a plain text listing in SQL*Plus, one …

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 …

dba_role_privs: List Oracle Roles Granted to a User Purpose Which roles does an Oracle user hold, and can that user pass them on to others? The view DBA_ROLE_PRIVS answers both questions. It describes the roles granted to all users and roles in the database. One row is one grant. The query below filters that view for …

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 …

Oracle Table Privileges Granted to a Role via role_tab_privs Purpose ROLE_TAB_PRIVS lists the object privileges granted to roles — every table, view, and sequence grant, the precise privilege type, and whether the right covers the entire object or is scoped to a single column. Oracle's reference notes that "Information …

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 …