Simple sqlplus to display 12c adaptive explain plan with autotrace on statistics – adaptive query optimization

set autotrace on statistics; set linesize 150 pagesize 1000; explain plan for select distinct object_name from dba_objects; select * from table (dbms_xplan.display(format=>’adaptive’))  

wipe out / clean an offline or online windows disk drive with diskpart

# get to an elevated (run as Admistrator) DOS command prompt to run diskpart # be careful as the operation you choose will work on the current disk – select disk changes current – list disk shows current diskpart> list disk # select disk # diskpart> select disk 1 # list disk will now show…

Create a Windows 7 Pro installation USB – using rufus

Rufus Rufus is a program that allows you to create bootable USB drives for Windows and Linux. You can create a bootable USB drives for almost any version of Windows, as well as almost all popular Linux distributions, such as Ubuntu, Kubuntu, Fedora, and OpenSUSE. Rufus is easy to use, I usually get it reliably…

Oracle Support Notes for Latest Available PSU

Patch Set Update Availability The latest available PSUs are listed in the My Oracle Support notes indicated below: Product My Oracle Support Note Database Document 756671.1 Enterprise Manager Document 822485.1 WebLogic Server Document 859115.1 Oracle Elastic Exalogic Cloud Software Document 1456286.1