Monthly Archives: April 2022

Inconsistent Line Endings in SSMS

Posted on April 15, 2022 by myother

Tools → Options → Environment → Documents → Check for consistent line endings on load

Posted in SSMS | Leave a comment

Another way to do explain plans in Oracle

Posted on April 14, 2022 by myother

set autotrace traceonly explain select /*+ PARALLEL(8) */ count(*) from SFC_STEP ; OR explain plan for select count(*) from SFC_STEP ; select * from table(dbms_xplan.display(format=>’ADVANCED’)); OR explain plan for select user, sysdate from dual; select * from table(dbms_xplan.display); SELECT * … Continue reading →

Posted in Oracle | Leave a comment

12c on Virtualbox

Posted on April 14, 2022 by myother

Install Virtualbox “as administrator” Oracle Database 12c: How to create a Virtual Box VM with Oracle Enterprise Linux inside – A dummy guide startx – Server distros never have a GUI by default. http://www.virtualbox.org/manual/ch01.html http://oracle-base.com/articles/linux/oracle-linux-7-installation.php https://blogs.oracle.com/OTNGarage/entry/more_tips_for_remote_access1 http://docs.oracle.com/cd/E26217_01/E26796/html/qs-preparation.html 12c Template https://updates.oracle.com/Orion/PatchDetails/process_form?aru=18539278&patch_password=&no_header=0

Posted in Oracle, Uncategorized, Virtualbox | Leave a comment

SQL Profiles

Posted on April 14, 2022 by myother

Query to show sql_ids related to SQL Profiles  

Posted in SQL Server, Uncategorized | Leave a comment