postgresql – To Kill postgresql Sessions for a specific database Sometimes it is necessary for the database administrator to remove existing connected sessions. For example to drop a database when users and/or applications cannot (or…
When a SQL Server process is killed (kill spid), the non-commited work (transactions) will take a certain amount of time to roll back. Use kill spid with statusonly to determine how much time a killed…
RMAN -Display RMAN Backups — display rman backups select j.session_recid, j.session_stamp, to_char(j.start_time, ‘dd.mm.yyyy hh24:mi:ss’) start_time, to_char(j.end_time, ‘dd.mm.yyyy hh24:mi:ss’) end_time, (j.output_bytes/1024/1024) output_mbytes, j.status, j.input_type, decode(to_char(j.start_time, ‘d’), 1, ‘Sunday’, 2, ‘Monday’, 3, ‘Tuesday’, 4, ‘Wednesday’, 5, ‘Thursday’,…
# java -XshowSettings:properties -version 2>&1 > /dev/null | grep ‘java.home’ java.home = /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.161-0.b14.el7_4.x86_64/jre set JAVA_HOME in ./etc/hadoop(hadoop-env.sh From hadoop installation directory $ ./bin/hadoop jar share/hadoop/mapreduce/hadoop-mapreduce-examples-3.0.0.jar wordcount input output output directory should not exist before running…
Hidden Oracle Initialization Parameters To display hidden Oracle initialization parameters: select ksppinm, ksppstvl from x$ksppi a, x$ksppsv b where a.indx=b.indx and substr(ksppinm,1,1) = ‘_’;
See MOS: Oracle SSO account required. My Oracle Support note 1513912.1 “TFA Collector – Tool for Enhanced Diagnostic Gathering” at https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=1513912.1
DBCC TRACEON(2520) DBCC HELP (‘?’) GO DBCC HELP(<command>) GO Following is the list of all the DBCC commands and their syntax. List contains all documented and undocumented DBCC commands. DBCC activecursors [(spid)] DBCC addextendedproc (function_name,…
PS C:\> Get-WindowsFeature RSAT-AD* PS C:\> Install-WindowsFeature RSAT-AD-PowerShell PS C:\> import-module ActiveDirectory PS C:\> Get-Command Get-ADComputer PS C:\> Get-ADComputer -Filter ‘Name -like “*SQL*”‘
Using SSMS to Display Deadlock History with Extended Events To use Extended Events to display deadlock history, the following method can be used. In the Object Explorer, Open Management folder Open Extended Events/Sessions/system_health Right-click on…
Scenario : Oracle Direct NFS, NFS on Windows Server you are using Oracle Direct NFS, and the NFS is running on Windows, there is a potential issue with permissions and ownership changes required. Example An…