Billy Aung Myint

Oracle Performance tuning – Tracing Oracle

An Oracle tracing process from various websites and tutorials I have read over the year. Hopefully , it helps someone to troubleshoot the issue. Also …

Source: SQL Server: Understanding Logging and Recovery in SQL Server

In my database i found some thing strange that is

Source: gethitratio and pinhitratio | Oracle Community

Here I am listing out the steps to install 11gR2 RAC on OS OEL6.5 on Oracle VM Virtual BOX. Step1: Create new Virtual BOX VM. Click on new and provide …

touch /etc/oracle/scls_scr/$HOSTNAME/root/ohasdrun

Source: How to Proceed from Failed Upgrade to 11gR2 Grid Infrastructure (CRS) [ID 969254.1] – David Dai — Focus on Oracle – 博客频道 – CSDN.NET

dd if=/dev/zero of= count=4 bs=1024

Source: How to turn ASM disks from Member to Candidates | Oracle Community

alter database add supplemental log data (primary key) columns;

Source: Oracle Database 11g: The Top New Features for DBAs and Developers | Transaction Management with LogMiner and Flashback Data Archive

SELECT JOB_TITLE, DEPARTMENT_NAME, LAST_NAME, START_DATE FROM JOB_HISTORY JOIN JOBS USING (JOB_ID) JOIN DEPARTMENTS USING (DEPARTMENT_ID) JOIN EMPLOYEES USING (EMPLOYEE_ID) WHERE TO_CHAR(START_DATE,’YYYY’) BETWEEN 2000 AND 2005

Source: HR Schema Queries and PL/SQL …

Source: Ask Tom: On Query Tuning

Source: Oracle Database Undo space explained – Oracle 48