https://www.brentozar.com/archive/2009/08/backup-log-with-truncate-only-in-sql-server-2008/
Oracle – Install Database Software 11.2.0.4.0
From MOS, search for patch 13390677 (it’s a full install)
- p13390677_112040_platform_1of7.zip (Oracle Database, including Oracle RAC components)
- p13390677_112040_platform_2of7.zip (Oracle Database, including Oracle RAC components)
Powershell – Get last Reboots Windows Server
#example Get-WMIobject win32_ntlogevent -filter "(logfile='system') AND (EventCode='1074') and Message like '%restart%'" | select -first n
Oracle – ezconnect
sqlplus username/pwd@//host[:port]/service prompt for password: sqlplus username@\"//host/[:port]/service\"
Windows – svchost 100% cpu on Windows Update (Virtual Machine on Virtual Box)
Solve the svchost 100% cpu issue om Windows 7 SP1
I installed all these:
IE11-Windows6.1-x64-en-us.exe
Windows6.1-KB3020369-x64.msu
Windows6.1-KB3102810-x64.msu
windows6.1-kb3125574-v4-x64_2dafb1d203c8964239af3048b5dd4b1264cd93b9.msu
Windows6.1-KB3179573-x64.msu
windows6.1-kb3197868-x64_b07be176e165c11b9ccbcf03d014b2aef9a514b6.msu
windows6.1-KB976932-X64.exe
After this, the problem still occurred.
Then:
19.12.2016 12:55 30’659’457 Windows6.1-KB3172605-x64.msu
https://support.microsoft.com/en-us/kb/3172605
July 2016 update rollup for Windows 7 SP1 and Windows Server 2008 R2 SP1
and set number of processors to 2
Windows – Windows Updates – “Offline”
To update Windows – when you have all updates to execute, the Windows Updater can get stuck (with 100% cpu) – seems to be doing nothing, then fails. Use this instead:
Oracle – ASM – asmcmd
Get a list of diskroups – bash shell
diskgroups=$(sqlplus -s -L / as sysdba << EOF
set pages 0 feedback off
select listagg (name, ' ') within group (order by name) from v\$asm_diskgroup;
EOF
)
asmcmd web page – Sachin’s DBA Blog
Windows – Display Computer/Laptop model, make from Windows Command Line
c:\> wmic computersystem get model,name,manufacturer,systemtype
Linux – grep
Display filenames only:
grep -l dba *.trc (lowercase letter l as switch)
Display filenames and matches
grep -H dba *.trc
Recursively find files and executes grep on each:
find . -name “*.trc*” -exec -l dba {} \; — space required between closing brace and backslash
Oracle – Idle Connections
Determine connections that have been idle for more than a certain amount of time (be aware that last_call_et also shows number of seconds active also) Examples -- Connections idle for > 60 minutes select s.sid,s.serial#,s.username,s.status, to_char(s.logon_time,'dd-mm-yy hh:mi:ss') "LOGON", floor(s.last_call_et/3600)||':'|| floor(mod(s.last_call_et,3600)/60)||':'|| mod(mod(s.last_call_et,3600),60) "IDLE", s.program, s.inst_id,p.spid, 'alter system kill session '''||s.sid||','||s.serial#||'''' from gv$session s JOIN gv$process p ON p.addr = s.paddr AND p.inst_id = s.inst_id where type='USER' and (LAST_CALL_ET / 60) >60 order by username, last_call_et desc; -- Connections idle for > 1 day select s.sid,s.serial#,s.username,s.status, to_char(s.logon_time,'dd-mm-yy hh:mi:ss') "LOGON", floor(s.last_call_et/3600)||':'|| floor(mod(s.last_call_et,3600)/60)||':'|| mod(mod(s.last_call_et,3600),60) "IDLE", s.program, s.inst_id,p.spid, 'alter system kill session '''||s.sid||','||s.serial#||'''' from gv$session s JOIN gv$process p ON p.addr = s.paddr AND p.inst_id = s.inst_id where type='USER' and (LAST_CALL_ET / 60 / 60 /24) > 1 order by username, last_call_et desc; -- Connections idle for > 5 days select s.sid,s.serial#,s.username,s.status, to_char(s.logon_time,'dd-mm-yy hh:mi:ss') "LOGON", floor(s.last_call_et/3600)||':'|| floor(mod(s.last_call_et,3600)/60)||':'|| mod(mod(s.last_call_et,3600),60) "IDLE", s.program, s.inst_id,p.spid, 'alter system kill session '''||s.sid||','||s.serial#||'''' from gv$session s JOIN gv$process p ON p.addr = s.paddr AND p.inst_id = s.inst_id where type='USER' and (LAST_CALL_ET / 60 / 60 /24) > 5 order by username, last_call_et desc;