queries used to check SQL cluster view status

check about sql cluster
-------------------------------
select serverproperty('ComputerNamePhysicalNetBIOS');

SELECT * FROM fn_virtualservernodes();

SELECT * FROM sys.dm_os_cluster_nodes ;

script to check the DG sync status from primary Database

set time on
set echo off
set verify off
set feedback off
set pagesize 999 lines 200
col dest_name for a40
col destination for a40
col applied_seq# for 999999999
col archived_seq# for 999999999
select dest_name,status,destination,archived_seq#,applied_seq#
from v$archive_dest_status
where status='VALID';

steps to change the oracle DB SAp user password.

Please use the below SYNTAX.

brconnect -c -p initTEST.sap -l E -f chpass -o SYSTEM -password <PASSWORD>

steps to do table level re-org in SAP oracle database?

1.check the table size before re-org
2.here is the syntax:
brspace -u / -c force -f  tbreorg -m online -a reorg -t <Table_name> -degree 4 -initial 2
3.check the table size after re-org it will be reduced.