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
Recent Comments