Search This Blog

Wednesday, 8 September 2021

SMART SCAN PRE_REQUISITE

 

=> Query must go full table scan

=>_Serial_direct_read = Always

=>Cell_offload_process= True


Generate explain plan

=>table access full(Smart Scan)

=>v$session_stat (Total eligible bytes I/O / Eligible bytes I/O returned by SMARTSCAN)

Saturday, 4 September 2021

 

Bash While loop running on linux:

while true; do {command}; sleep 180; done &

 

Check services on windows: 

wmic service get name,startname