Understanding oifcfg for Changing Oracle Cluster Interconnect Subnet The oifcfg Oracle Clusterware commands presented involve modifying the Oracle Clusterware private interconnect subnet.What follows is a breakdown of their purpose, usage, and key points: Make a note of the interface name (eth1 in the following …
Read MoreSQL lists all objects within a specific tablespace in an Oracle database A detailed explanation of Oracle Database SQL code used to list objects within a tablespace, including purpose, breakdown, key points, and insights. Sample SQL Command 1set pages 999 2col owner format a15 3col segment_name format a40 4col …
Read MoreAlters The Default Temporary Tablespace for the Entire Database to "temp" Sample SQL Command 1alter database default temporary tablespace temp 2/ Purpose: To specify the preferred location where temporary data should be stored for all user sessions within the database. This provides centralized management and …
Read MoreIdentifying Segments Nearing Maximum Extents in Oracle Database
Identify Oracle Database Segments Nearing Their Maximum Extent Limit Sample SQL Command 1col segment_name format a40 2select owner 3, segment_type 4, segment_name 5, max_extents - extents as "spare" 6, max_extents 7from dba_segments 8where owner not in ('SYS','SYSTEM') 9and (max_extents - …
Read MoreAdjusting Segment Growth with MAXEXTENTS in Oracle Database
Alters The MAXEXTENTS Parameter For A Specific Database Segment Sample SQL Command 1alter <segment_type> <segment_name> storage(maxextents 150); 2/ Purpose: To define the maximum number of extents the segment can occupy, controlling its potential growth and space allocation behavior. Breakdown: alter …
Read MoreMonitoring Temporary Tablespace Usage in Oracle Database
Jan 31, 2024 · 3 min read · oracle sql-queries database-administration oracle tablesapce segments dba_segments ·Lists the Contents of the Temporary Tablespace(s), Including Details About Each Temporary Object and Its Associated Session Sample SQL Command 1set pages 999 lines 100 2col username format a15 3col mb format 999,999 4select su.username 5, ses.sid 6, ses.serial# 7, su.tablespace 8, ceil((su.blocks * dt.block_size) / …
Read MoreModifying VIP Address, Subnet Mask, or Interface in Oracle Clusterware
Jan 28, 2024 · 3 min read · start stop modify srvctl administration Oracle CRS Oracle Clusterware Oracle Managing RAC ·Modifying VIP Address, Subnet Mask, or Interface in Oracle Clusterware Learn how to change the Virtual IP (VIP) address, subnet mask, or network interface for clustered nodes in an Oracle environment. This step-by-step guide includes commands, explanations, and key points to ensure a smooth and successful configuration …
Read MoreUnderstanding the srvctl config nodeapps Command in Oracle Clusterware
Jan 27, 2024 · 3 min read · srvctl start stop administration Oracle CRS Oracle Clusterware Oracle Managing RAC ·Understanding the srvctl config nodeapps Command in Oracle Clusterware Check the VIP config 1srvctl config nodeapps -n <node> -a -g -s -l Sample Oracle Output: 1 2no rows selected 3SQL> Description of the Oracle Database SQL code: Purpose: The srvctl config nodeapps -n <node> -a -g -s -l command is not …
Read MoreStarting and Stopping Oracle Database Instances with SRVCTL
Jan 26, 2024 · 3 min read · srvctl start stop administration Oracle CRS Oracle Clusterware Oracle Managing RAC ·Start and stops a specific Oracle Database instance with the Server Control Utility (SRVCTL) SQL Code Start Database (Specific Node or Instance) 1srvctl start instance -d <database name> -i <instance name> Stop Database (Specific Node or Instance) 1srvctl stop instance -d <database name> -i …
Read MoreControlling Database Operations Starting and Stopping Databases with srvctl in Oracle Clusterware
Jan 25, 2024 · 2 min read · start stop administration Oracle CRS Oracle Clusterware Oracle Managing RAC ·Demystifying Database Start/Stop in Oracle Clusterware with srvctl SQL Code Start Database (All Nodes) 1srvctl start database -d <database name> Stop Database (All Nodes) 1srvctl stop database -d <database name> Sample Oracle Output: 1 2no rows selected 3SQL> Description of the Oracle Database SQL code: …
Read More